public static bool InsertNew(PW_GROUP t_new)
{
DBHelper DBHelper_SqlServer = new DBLink();
try
{
PW_GROUP tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" Insert into PW_GROUP ( ");
sb.Append("ID, ");
sb.Append("GROUPNAME, ");
sb.Append("GROUPDESCRIBE, ");
sb.Append("STATUS )");
sb.Append(" values ( ");
sb.Append("@ID,");
sb.Append("@GROUPNAME,");
sb.Append("@GROUPDESCRIBE,");
sb.Append(" @STATUS )");
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("@GROUPNAME", DbType.String)
{
Value = tt.GROUPNAME
});
cmd.Parameters.Add(new SqlParameter("@GROUPDESCRIBE", DbType.String)
{
Value = tt.GROUPDESCRIBE
});
cmd.Parameters.Add(new SqlParameter("@STATUS", DbType.String)
{
Value = tt.STATUS
});
foreach (SqlParameter p in cmd.Parameters)
{
p.IsNullable = true;
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
int val = DBHelper_SqlServer.ExecuteNonQuery(cmd);
if (val > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
private static List <PW_GROUP> DoQuery(string sql_str)
{
List <PW_GROUP> rtn = new List <PW_GROUP>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new PW_GROUP();
p.ID = DBHelper_SqlServer.GetDataValue <string>(dr, "ID");
p.GROUPNAME = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUPNAME");
p.GROUPDESCRIBE = DBHelper_SqlServer.GetDataValue <string>(dr, "GROUPDESCRIBE");
p.STATUS = DBHelper_SqlServer.GetDataValue <string>(dr, "STATUS");
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
private void lsV_r_Group_SelectedIndexChanged_1(object sender, EventArgs e)
{
string groupname = "";
if (lsV_r_Group.SelectedItems.Count == 0)
{
return;
}
groupname = lsV_r_Group.SelectedItems[0].Text;
if (groupLst.Count > 0)
{
oneGroup = groupLst.Find(x => x.GROUPNAME == groupname);
}
tb_r_GroupName.Text = oneGroup.GROUPNAME;
rTB_r_GroupDesc.Text = oneGroup.GROUPDESCRIBE;
inialGroupVsFunction();//刷新组功能表
inial_lsB_r_User();
}
private void btn_r_SaveDesc_Click(object sender, EventArgs e)
{
if (tb_r_GroupName.Text.Trim() == "")
{
return;
}
using (ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient srv = new ASRS_Volvo.ServiceForVolvo.ASRS_ServiceSoapClient())
{
PW_GROUP newGroup = new PW_GROUP();
newGroup.ID = Guid.NewGuid().ToString();
newGroup.GROUPDESCRIBE = rTB_r_GroupDesc.Text;
newGroup.GROUPNAME = tb_r_GroupName.Text;
if (srv.PW_Group_InsertOne(newGroup))
{
MessageBox.Show(this, "保存成功!");
Close();
}
else
{
MessageBox.Show(this, "保存失败!");
}
}
}
public bool PW_Group_UpadteOne(PW_GROUP t_One)
{
return(SQL_Da_PW_GROUP.UpdateOne(t_One));
}
public bool PW_Group_InsertOne(PW_GROUP t_One)
{
return(SQL_Da_PW_GROUP.InsertNew(t_One));
}
