我用来循环一个 isforeach另一个 is for loop。Foreach 循环用于system.Data和for loop用于数组的数据。我正在尝试匹配两个对象的属性,如果匹配,则将值传递给我的 Oracle 过程以保存数据。这是我的代码:
foreach (System.Data.DataRow dz in ViewBag.MenuData2.Rows)
{
ViewBag.comp = @dz["mnud_text"];
for (int i =0; i<data.Length;i++ )
{
if (ViewBag.comp == data[i])
{
if (@dz["chk"].ToString() == "0" || @dz["umnu_oid"].ToString() == "N")
{
actv = "1";
}
string user_id = data[i];
ds = new DataSet();
ds = _clsDataAccess.update_menu_permission("00003", ViewBag.comp.ToString(), actv,"N", "00002");
}
}
}
程序是:
public void update_menu_permission(string user_id, string menu_id, string actv, string oid, string euser)
{
conn = new OracleConnection(clsConnection.ConnectionSave);
conn.Open();
if (oid == "N")
{
strComm = "insert into thlhr.t_umnu (oid, umnu_mnud, umnu_user, umnu_actv, iuser, euser) values "
+ "(:oid, :umnu_mnud, :umnu_user, :umnu_actv, :iuser, :euser)";
cmd = new OracleCommand(strComm, conn);
cmd.Parameters.Add("oid", OracleType.VarChar).Value = "UMNU" + user_id.ToUpper() + menu_id.ToUpper();
cmd.Parameters.Add("umnu_mnud", OracleType.VarChar).Value = menu_id;
cmd.Parameters.Add("umnu_user", OracleType.VarChar).Value = user_id;
cmd.Parameters.Add("umnu_actv", OracleType.VarChar).Value = actv;
cmd.Parameters.Add("iuser", OracleType.VarChar).Value = euser;
cmd.Parameters.Add("euser", OracleType.VarChar).Value = euser;
}
else
}
当我传递值时,我遇到了这个错误,"Additional information: Cannot implicitly convert type 'void' to 'object'"请帮我解决这个问题。让我知道是否需要更多信息。
慕侠2389804
相关分类