public static int InsertInformation(A2ZITEMGROUPDTO dto)
{
int rowEffect = 0;
var prm = new object[7];
prm[0] = dto.GroupCode;
prm[1] = dto.GroupName;
prm[2] = dto.MakingRangeFrom;
prm[3] = dto.MakingRangeTo;
prm[4] = dto.Purity22;
prm[5] = dto.Purity21;
prm[6] = dto.Purity18;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_InsertItemGroup", prm, "A2ZACGMS"));
if (result == 0)
{
rowEffect = 1;
}
else
{
rowEffect = 0;
}
return(rowEffect);
}
public static A2ZITEMGROUPDTO GetInformation(int GroupCode)
{
var prm = new object[1];
prm[0] = GroupCode;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_GetItemGroup", prm, "A2ZACGMS");
var p = new A2ZITEMGROUPDTO();
if (dt.Rows.Count > 0)
{
p.GroupCode = Converter.GetInteger(dt.Rows[0]["GroupCode"]);
p.GroupName = Converter.GetString(dt.Rows[0]["GroupName"]);
p.MakingRangeFrom = Converter.GetDecimal(dt.Rows[0]["MakingRangeFrom"]);
p.MakingRangeTo = Converter.GetDecimal(dt.Rows[0]["MakingRangeTo"]);
p.Purity22 = Converter.GetDecimal(dt.Rows[0]["Purity22"]);
p.Purity21 = Converter.GetDecimal(dt.Rows[0]["Purity21"]);
p.Purity18 = Converter.GetDecimal(dt.Rows[0]["Purity18"]);
return(p);
}
else
{
p.GroupCode = 0;
}
return(p);
}
public static int DeleteInformation(A2ZITEMGROUPDTO dto)
{
int rowEffect = 0;
var prm = new object[1];
prm[0] = dto.GroupCode;
int result = Converter.GetInteger(CommonManager.Instance.GetScalarValueBySp("Sp_DeleteItemGroup", prm, "A2ZACGMS"));
if (result == 0)
{
rowEffect = 1;
}
else
{
rowEffect = 0;
}
return(rowEffect);
}
