/// <summary>
/// 修改分组
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Group(Total_Group DX)
{
JsMessage js = new JsMessage();
// string SqlStr = @" UPDATE [dbo].[Total_Group]
// SET [GroupName]= @GroupName,
// [WJID] = @WJID,
// [IDValue] = @IDValue,
// WHERE ID=@ID ";
string SqlStr = @" UPDATE [dbo].[Total_Group]
SET [IDValue] = @IDValue
WHERE ID=@ID ";
SqlParameter[] commandParameters = new SqlParameter[]{
//new SqlParameter("@GroupName",SqlDbType.NVarChar,50){Value=DX.GroupName},
//new SqlParameter("@WJID",DX.WJID),
new SqlParameter("@IDValue",DX.IDValue),
new SqlParameter("@ID",DX.ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 添加分组
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Add_Group(Total_Group DX)
{
JsMessage js = new JsMessage();
string SqlStr = @" INSERT INTO [dbo].[Total_Group]
([GroupName]
,[WJID]
,[IDValue] )
VALUES
(@GroupName,
@WJID,
@IDValue);SELECT @ID=SCOPE_IDENTITY();";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@GroupName",DX.GroupName),
new SqlParameter("@WJID",DX.WJID),
new SqlParameter("@IDValue",DX.IDValue),
new SqlParameter("@ID",SqlDbType.Int){Direction = ParameterDirection.Output}
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
js.ReturnADD_ID = int.Parse(commandParameters[3].Value.ToString());
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
