private static List <MODULE_VS_GROUP> DoQuery(string sql_str)
{
List <MODULE_VS_GROUP> rtn = new List <MODULE_VS_GROUP>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new MODULE_VS_GROUP();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.GROUP_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_NAME");
p.GROUP_DESC = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUP_DESC");
p.MODULE_ID = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_ID");
p.MODULE_NAME = DBHelper_SqlServer.GetDataValue <string>(dr, "MODULE_NAME");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private void btn_r_PW_Add_Click(object sender, EventArgs e)
{
if (oneGroup.ID == null)
{
return;
}
var oneFunc = cmB_PW.SelectedItem as MODULE;
MODULE_VS_GROUP oneGROUPVSFUNCTION = new MODULE_VS_GROUP();
oneGROUPVSFUNCTION.ID = Guid.NewGuid().ToString();
oneGROUPVSFUNCTION.MODULE_ID = oneFunc.ID;
oneGROUPVSFUNCTION.MODULE_NAME = oneFunc.MODULE_NAME;
oneGROUPVSFUNCTION.GROUP_DESC = oneGroup.GROUPDESCRIBE;
oneGROUPVSFUNCTION.GROUP_NAME = oneGroup.GROUPNAME;
List <MODULE_VS_GROUP> tmpList = new List <MODULE_VS_GROUP>();
tmpList = lsB_r_PW.DataSource as List <MODULE_VS_GROUP>;
if (tmpList == null)
{
tmpList = new List <MODULE_VS_GROUP>();
}
var tmp = tmpList.Find(x => x.MODULE_ID == oneGROUPVSFUNCTION.MODULE_ID);
if (tmp != null)
{
MessageBox.Show(this, "已有该功能!");
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
srv.MODULE_VS_GROUP_InsertOne(oneGROUPVSFUNCTION);
inialGroupVsFunction();
}
private void btn_r_Pw_Remove_Click(object sender, EventArgs e)
{
if (lsB_r_PW.SelectedItem == null)
{
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
MODULE_VS_GROUP oneGVF = lsB_r_PW.SelectedItem as MODULE_VS_GROUP;
srv.MODULE_VS_GROUP_DeleteOne(oneGVF.ID);
inialGroupVsFunction();
}
}
public static bool InsertNew(MODULE_VS_GROUP t_new)
{
try
{
MODULE_VS_GROUP tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" Insert into MODULE_VS_GROUP ( ");
sb.Append("ID, ");
sb.Append("GROUP_NAME, ");
sb.Append("GROUP_DESC, ");
sb.Append("MODULE_ID, ");
sb.Append("MODULE_NAME )");
sb.Append(" values ( ");
sb.Append("@ID,");
sb.Append("@GROUP_NAME,");
sb.Append("@GROUP_DESC,");
sb.Append("@MODULE_ID,");
sb.Append(" @MODULE_NAME )");
DbCommand cmd = new SqlCommand();
cmd.CommandText = sb.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@ID", DbType.String)
{
Value = tt.ID
});
cmd.Parameters.Add(new SqlParameter("@GROUP_NAME", DbType.String)
{
Value = tt.GROUP_NAME
});
cmd.Parameters.Add(new SqlParameter("@GROUP_DESC", DbType.String)
{
Value = tt.GROUP_DESC
});
cmd.Parameters.Add(new SqlParameter("@MODULE_ID", DbType.String)
{
Value = tt.MODULE_ID
});
cmd.Parameters.Add(new SqlParameter("@MODULE_NAME", DbType.String)
{
Value = tt.MODULE_NAME
});
foreach (SqlParameter p in cmd.Parameters)
{
p.IsNullable = true;
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
DBHelper DBHelper_SqlServer = new DBLink();
int val = DBHelper_SqlServer.ExecuteNonQuery(cmd);
if (val > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public bool MODULE_VS_GROUP_UpdateOne(MODULE_VS_GROUP one)
{
return(SQL_Da_MODULE_VS_GROUP.UpdateOne(one));
}
public bool MODULE_VS_GROUP_InsertOne(MODULE_VS_GROUP one)
{
return(SQL_Da_MODULE_VS_GROUP.InsertNew(one));
}
