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)); }