2023年6月21日发(作者：)

C#OracleParameter传参实例 1.注：Oracle：OracleParameter，参数命名以“:”作为标识； MSSQL：SqlParameter，参数命名以“@”作为标识，根据数据库不同调⽤不同的接⼝。

2.附()和ge()⽅法的区别：将指定的 SqlParameter 对象添加到 SqlParameterCollection 中ge 将值数组添加到 SqlParameterCollection 的末尾。

在群体操作时，使⽤AddRange取代Add。Oracle实例：public static Boolean getLmt(string lmtd_name) { string usr_user = n["MJERP10username"].ToString(); if (lmtd_name == "") { return true; } //string sql = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name='" + lmtd_name + "' and lmtd_username='" + usr_user + "' union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user = '" + usr_user +

string sql1 = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name=:lmtd_name and lmtd_username=:lmtd_username union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user =:usr_user"; OracleParameter[] param = new OracleParameter[]{ new OracleParameter(":lmtd_name",r,50),

new OracleParameter(":lmtd_username",r,50),

new OracleParameter(":usr_user",r,30) }; param[0].Value = lmtd_name; param[1].Value = usr_user; param[2].Value = usr_user; DataSet ds = new DataSet(); using (OracleConnection connection = new OracleConnection(tings["connString"])) { (); OracleCommand cmd = new OracleCommand(sql1,connection); for (int i = 0; i < ; i++) { (param[i]); } //ge(param); OracleDataAdapter myda = new OracleDataAdapter(cmd); (ds); (); } if ([0]. > 0) { e(); return true; } else { e(); return false; } }View CodeMSSQL实例：//取⽤户权限 public static Boolean getLmt(string lmtd_name) { Dictionary dic = new Dictionary(); string usr_user = n["MJERP10username"].ToString(); if (lmtd_name == "") { return true; } //string sql = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name='" + lmtd_name + "' and lmtd_username='" + usr_user + "' union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user = '" + usr_user +

string sql1 = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name=:lmtd_name and lmtd_username=:lmtd_username union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user =:usr_user"; SqlParameter[] param = new SqlParameter[]{ new SqlParameter(":lmtd_name",ar,50),

new SqlParameter(":lmtd_username",ar,50),

new SqlParameter(":usr_user",ar,30) }; param[0].Value = lmtd_name; param[1].Value = usr_user; param[2].Value = usr_user; DataSet ds = new DataSet(); using (SqlConnection connection = new SqlConnection(tings["connString"])) { (); SqlCommand cmd = new SqlCommand(sql1, connection); //for (int i = 0; i < ; i++) //{ // (param[i]); // } ge(param); SqlDataAdapter myda = new SqlDataAdapter(cmd); (ds); (); } if ([0]. > 0) { e(); return true; } else { e(); return false; } }View Code

2023年6月21日发(作者：)

C#OracleParameter传参实例 1.注：Oracle：OracleParameter，参数命名以“:”作为标识； MSSQL：SqlParameter，参数命名以“@”作为标识，根据数据库不同调⽤不同的接⼝。

2.附()和ge()⽅法的区别：将指定的 SqlParameter 对象添加到 SqlParameterCollection 中ge 将值数组添加到 SqlParameterCollection 的末尾。

在群体操作时，使⽤AddRange取代Add。Oracle实例：public static Boolean getLmt(string lmtd_name) { string usr_user = n["MJERP10username"].ToString(); if (lmtd_name == "") { return true; } //string sql = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name='" + lmtd_name + "' and lmtd_username='" + usr_user + "' union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user = '" + usr_user +

string sql1 = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name=:lmtd_name and lmtd_username=:lmtd_username union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user =:usr_user"; OracleParameter[] param = new OracleParameter[]{ new OracleParameter(":lmtd_name",r,50),

new OracleParameter(":lmtd_username",r,50),

new OracleParameter(":usr_user",r,30) }; param[0].Value = lmtd_name; param[1].Value = usr_user; param[2].Value = usr_user; DataSet ds = new DataSet(); using (OracleConnection connection = new OracleConnection(tings["connString"])) { (); OracleCommand cmd = new OracleCommand(sql1,connection); for (int i = 0; i < ; i++) { (param[i]); } //ge(param); OracleDataAdapter myda = new OracleDataAdapter(cmd); (ds); (); } if ([0]. > 0) { e(); return true; } else { e(); return false; } }View CodeMSSQL实例：//取⽤户权限 public static Boolean getLmt(string lmtd_name) { Dictionary dic = new Dictionary(); string usr_user = n["MJERP10username"].ToString(); if (lmtd_name == "") { return true; } //string sql = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name='" + lmtd_name + "' and lmtd_username='" + usr_user + "' union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user = '" + usr_user +

string sql1 = @"select id from sys_lmtd where lmtd_mde||'_'||lmtd_name=:lmtd_name and lmtd_username=:lmtd_username union all select from role_mstr ro join usr_mstr on usr_role_id = where usr_user =:usr_user"; SqlParameter[] param = new SqlParameter[]{ new SqlParameter(":lmtd_name",ar,50),

new SqlParameter(":lmtd_username",ar,50),

new SqlParameter(":usr_user",ar,30) }; param[0].Value = lmtd_name; param[1].Value = usr_user; param[2].Value = usr_user; DataSet ds = new DataSet(); using (SqlConnection connection = new SqlConnection(tings["connString"])) { (); SqlCommand cmd = new SqlCommand(sql1, connection); //for (int i = 0; i < ; i++) //{ // (param[i]); // } ge(param); SqlDataAdapter myda = new SqlDataAdapter(cmd); (ds); (); } if ([0]. > 0) { e(); return true; } else { e(); return false; } }View Code