public static bool Insert(ObjectModule.Local.Sapcode gs)
{
try
{
string sql = @"insert into Sapcode
(SAPCODE,DESCRIPTION,THAWING_TIME,USAGE_LIFE,DEPARTMENT,NEW_MIN_WEIGHT,NEW_MAX_WEIGHT,
EMPTY_SYRINGE_WEIGHT,SCRAP_WEIGHT,CAPACITY,ON_HOLD,UPDATED_TIME,UPDATED_BY)
VALUES
(@SAPCODE,@DESCRIPTION,@THAWING_TIME,@USAGE_LIFE,@DEPARTMENT,@NEW_MIN_WEIGHT,@NEW_MAX_WEIGHT,
@EMPTY_SYRINGE_WEIGHT,@SCRAP_WEIGHT,@CAPACITY,@ON_HOLD,@UPDATED_TIME,@UPDATED_BY)";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql);
cmd.Parameters.Add("@SAPCODE", System.Data.SqlDbType.VarChar).Value = gs.SAPCODE;
cmd.Parameters.Add("@DESCRIPTION", System.Data.SqlDbType.VarChar).Value = gs.DESCRIPTION;
cmd.Parameters.Add("@THAWING_TIME", System.Data.SqlDbType.Int).Value = gs.THAWING_TIME;
cmd.Parameters.Add("@USAGE_LIFE", System.Data.SqlDbType.Int).Value = gs.USAGE_LIFE;
cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = gs.DEPARTMENT;
cmd.Parameters.Add("@NEW_MIN_WEIGHT", System.Data.SqlDbType.Float).Value = gs.NEW_MIN_WEIGHT;
cmd.Parameters.Add("@NEW_MAX_WEIGHT", System.Data.SqlDbType.Float).Value = gs.NEW_MAX_WEIGHT;
cmd.Parameters.Add("@EMPTY_SYRINGE_WEIGHT", System.Data.SqlDbType.Float).Value = gs.EMPTY_SYRINGE_WEIGHT;
cmd.Parameters.Add("@SCRAP_WEIGHT", System.Data.SqlDbType.Float).Value = gs.SCRAP_WEIGHT;
cmd.Parameters.Add("@CAPACITY", System.Data.SqlDbType.Int).Value = gs.CAPACITY;
cmd.Parameters.Add("@ON_HOLD", System.Data.SqlDbType.VarChar).Value = gs.ON_HOLD;
cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = gs.UPDATED_TIME;
cmd.Parameters.Add("@UPDATED_BY", System.Data.SqlDbType.VarChar).Value = gs.UPDATED_BY;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static void Weight_Validation(string Weighting_weight, string sapcode, string department)
{
DataTable dt = DataProvider.Local.Sapcode.Sap_Infor(sapcode, department);
if (dt.Rows.Count == 0)
{
throw new System.Exception("Invalid Sapcode !!\n无效的物料型号！！");
}
ObjectModule.Local.Sapcode gs = new ObjectModule.Local.Sapcode(dt.Rows[0]);
if (float.Parse(Weighting_weight) < gs.NEW_MIN_WEIGHT || float.Parse(Weighting_weight) > gs.NEW_MAX_WEIGHT)
{
throw new System.Exception("This solder ball weight out of SPEC, please weighting again !!");
}
}
public static ObjectModule.Local.Sapcode Sap_Infor(string Sapcode, string Department)
{
if (Sapcode.Length == 0)
{
throw new System.Exception("Please input Sapcode first !!\n请输入材料型号！！");
}
DataTable dt = DataProvider.Local.Sapcode.Sap_Infor(Sapcode, Department);
if (dt.Rows.Count == 0)
{
throw new System.Exception("Invalid Sapcode !!\n无效的材料型号");
}
ObjectModule.Local.Sapcode gs = new ObjectModule.Local.Sapcode(dt.Rows[0]);
return(gs);
}
private void btn_confirm_Click(object sender, System.Windows.RoutedEventArgs e)
{
try
{
ObjectModule.Local.Sapcode gs = new ObjectModule.Local.Sapcode();
gs.CAPACITY = int.Parse(this.cbb_capacity.Text);
gs.DEPARTMENT = this.cbb_department.Text;
gs.DESCRIPTION = this.txt_description.Text;
gs.EMPTY_SYRINGE_WEIGHT = float.Parse(txt_emptySyringeWeight.Text);
gs.NEW_MAX_WEIGHT = float.Parse(txt_newMaxWeight.Text);
gs.NEW_MIN_WEIGHT = float.Parse(txt_newMinWeight.Text);
gs.ON_HOLD = cbb_onHold.Text;
gs.SAPCODE = this.txt_sapcode.Text;
gs.SCRAP_WEIGHT = float.Parse(txt_scrapWeight.Text);
gs.THAWING_TIME = int.Parse(txt_thawingTime.Text);
gs.UPDATED_BY = StaticRes.Global.Current_User.USER_ID;
gs.UPDATED_TIME = System.DateTime.Now;
gs.USAGE_LIFE = int.Parse(txt_usageLife.Text);
if (lb_title.Content.ToString() == "Add Sapcode")
{
Logic.Common.SAP_Insert(gs);
Common.Reports.LogFile.Log("Add Sapcode: " + gs.SAPCODE + " ; Description:" + gs.DESCRIPTION + " ; Empty Syringe Weight" + gs.EMPTY_SYRINGE_WEIGHT.ToString() +
" ; New Max Weight:" + gs.NEW_MAX_WEIGHT.ToString() + " ; New Min Weight:" + gs.NEW_MIN_WEIGHT.ToString() +
" ; Scrap Weight:" + gs.SCRAP_WEIGHT.ToString() + " ; Thawing Time:" + gs.THAWING_TIME.ToString() +
" ; Usage Life:" + gs.USAGE_LIFE.ToString() + " ; On_Hold:" + gs.ON_HOLD.ToString() +
" by user:"******"Update Sapcode: " + gs.SAPCODE + " ; Description:" + gs.DESCRIPTION + " ; Empty Syringe Weight" + gs.EMPTY_SYRINGE_WEIGHT.ToString() +
" ; New Max Weight:" + gs.NEW_MAX_WEIGHT.ToString() + " ; New Min Weight:" + gs.NEW_MIN_WEIGHT.ToString() +
" ; Scrap Weight:" + gs.SCRAP_WEIGHT.ToString() + " ; Thawing Time:" + gs.THAWING_TIME.ToString() +
" ; Usage Life:" + gs.USAGE_LIFE.ToString() + " ; On_Hold:" + gs.ON_HOLD.ToString() +
" by user:"******"Successful !!", "Message", MessageBoxButton.OK, MessageBoxImage.Asterisk);
SAP_Search();
this.MaskActionPage.Visibility = Visibility.Collapsed;
kb.CurrentTextBox = txt_sapcode_search;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public static bool SAP_Update(ObjectModule.Local.Sapcode gs)
{
if (gs.SAPCODE.Length == 0)
{
throw new System.Exception("Please input SAP Code !!\n请输入SAP号码！！");
}
if (gs.DESCRIPTION.Length == 0)
{
throw new System.Exception("Please input Description !!\n请输入描述！！");
}
if (gs.EMPTY_SYRINGE_WEIGHT >= gs.NEW_MIN_WEIGHT)
{
throw new System.Exception("Empty Syringe Weight can not bigger than New Min Weight\n空注射器重量不能超过新最小重量！！");
}
if (gs.NEW_MIN_WEIGHT >= gs.NEW_MAX_WEIGHT)
{
throw new System.Exception("New Min Weight can not bigger than New Max Weight\n新的最小重量不能超过最大重量！！");
}
if (gs.USAGE_LIFE <= 0)
{
throw new System.Exception("Usage Life must bigger than 0\n用量重量必须大于0！！");
}
return(DataProvider.Local.Sapcode.Update(gs));
}
