private void btnSave_Click(object sender, EventArgs e)
{
if (tBSku.Text.Trim() == string.Empty)
{
return;
}
using (ASRS_ServiceSoapClient srv = new ASRS_ServiceSoapClient())
{
if (item == null || item.SKU == "")
{
item = new IM_Item();
}
else
{
srv.IM_Item_DeleteOne(item.SKU);
}
item.ABCCLASS = "A区";
item.COMPATIBLECODE = tbCMCode.Text.Trim();
item.SKU = tBSku.Text.Trim();
item.SKUDESC = tBDesc.Text.Trim();
item.ITEMCLASS = ddlItemClass.SelectedItem.ToString();
item.UPDATETIME = DateTime.Now.ToString("yyyy-MM-dd");
item.UPDATEUSER = FormLogin.user.USERNAME;
bool val = srv.IM_Item_InsertOne(item);
if (val)
{
Close();
}
else
{
item = null;
MessageBox.Show(this, "保存失败!");
}
}
}
private static List <IM_Item> DoQuery(string sql_str)
{
List <IM_Item> rtn = new List <IM_Item>();
try
{
DBHelper DBHelper_SqlServer = new DBLink();
{
using (IDataReader dr = DBHelper_SqlServer.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new IM_Item();
p.SKU = DBHelper_SqlServer.GetDataValue <string>(dr, "SKU");
p.SKUDESC = DBHelper_SqlServer.GetDataValue <string>(dr, "SKUDESC");
p.BARCODE = DBHelper_SqlServer.GetDataValue <string>(dr, "BARCODE");
p.EANCODE = DBHelper_SqlServer.GetDataValue <string>(dr, "EANCODE");
p.COMPATIBLECODE = DBHelper_SqlServer.GetDataValue <string>(dr, "COMPATIBLECODE");
p.SPEC = DBHelper_SqlServer.GetDataValue <string>(dr, "SPEC");
p.ITEMCLASS = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEMCLASS");
p.ABCCLASS = DBHelper_SqlServer.GetDataValue <string>(dr, "ABCCLASS");
p.UOM = DBHelper_SqlServer.GetDataValue <string>(dr, "UOM");
p.LENGTH = DBHelper_SqlServer.GetDataValue <decimal>(dr, "LENGTH");
p.WIDTH = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WIDTH");
p.HEIGHT = DBHelper_SqlServer.GetDataValue <decimal>(dr, "HEIGHT");
p.WEIGHT = DBHelper_SqlServer.GetDataValue <decimal>(dr, "WEIGHT");
p.SAVEQTY = DBHelper_SqlServer.GetDataValue <decimal>(dr, "SAVEQTY");
p.STORGELIFE = DBHelper_SqlServer.GetDataValue <string>(dr, "STORGELIFE");
p.VOID = DBHelper_SqlServer.GetDataValue <int>(dr, "VOID");
p.UPDATETIME = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATETIME");
p.UPDATEUSER = DBHelper_SqlServer.GetDataValue <string>(dr, "UPDATEUSER");
p.ITEM_BK1 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK1");
p.ITEM_BK2 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK2");
p.ITEM_BK3 = DBHelper_SqlServer.GetDataValue <string>(dr, "ITEM_BK3");
rtn.Add(p);
}
}
}
}
catch (Exception ex)
{
}
return(rtn);
}
/// <summary>
/// 更新一个物料信息
/// </summary>
/// <param name="t_new"></param>
/// <returns></returns>
public static bool UpdateOne(IM_Item t_new)
{
IM_Item tt = t_new;
StringBuilder sb = new StringBuilder();
sb.Append(" update IM_Item set ");
sb.Append("SKUDESC=@SKUDESC, ");
sb.Append("BARCODE=@BARCODE, ");
sb.Append("EANCODE=@EANCODE, ");
sb.Append("COMPATIBLECODE=@COMPATIBLECODE, ");
sb.Append("SPEC=@SPEC, ");
sb.Append("ITEMCLASS=@ITEMCLASS, ");
sb.Append("ABCCLASS=@ABCCLASS, ");
sb.Append("UOM=@UOM, ");
sb.Append("LENGTH=@LENGTH, ");
sb.Append("WIDTH=@WIDTH, ");
sb.Append("HEIGHT=@HEIGHT, ");
sb.Append("WEIGHT=@WEIGHT, ");
sb.Append("SAVEQTY=@SAVEQTY, ");
sb.Append("STORGELIFE=@STORGELIFE, ");
sb.Append("VOID=@VOID, ");
sb.Append("UPDATETIME=@UPDATETIME, ");
sb.Append("UPDATEUSER=@UPDATEUSER, ");
sb.Append("ITEM_BK1=@ITEM_BK1, ");
sb.Append("ITEM_BK2=@ITEM_BK2, ");
sb.Append("ITEM_BK3=@ITEM_BK3 ");
sb.Append(" where SKU=@SKU ");
DbCommand cmd = new SqlCommand();
cmd.CommandText = sb.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@SKUDESC", DbType.String)
{
Value = tt.SKUDESC
});
cmd.Parameters.Add(new SqlParameter("@BARCODE", DbType.String)
{
Value = tt.BARCODE
});
cmd.Parameters.Add(new SqlParameter("@EANCODE", DbType.String)
{
Value = tt.EANCODE
});
cmd.Parameters.Add(new SqlParameter("@COMPATIBLECODE", DbType.String)
{
Value = tt.COMPATIBLECODE
});
cmd.Parameters.Add(new SqlParameter("@SPEC", DbType.String)
{
Value = tt.SPEC
});
cmd.Parameters.Add(new SqlParameter("@ITEMCLASS", DbType.String)
{
Value = tt.ITEMCLASS
});
cmd.Parameters.Add(new SqlParameter("@ABCCLASS", DbType.String)
{
Value = tt.ABCCLASS
});
cmd.Parameters.Add(new SqlParameter("@UOM", DbType.String)
{
Value = tt.UOM
});
cmd.Parameters.Add(new SqlParameter("@LENGTH", DbType.Decimal)
{
Value = tt.LENGTH
});
cmd.Parameters.Add(new SqlParameter("@WIDTH", DbType.Decimal)
{
Value = tt.WIDTH
});
cmd.Parameters.Add(new SqlParameter("@HEIGHT", DbType.Decimal)
{
Value = tt.HEIGHT
});
cmd.Parameters.Add(new SqlParameter("@WEIGHT", DbType.Decimal)
{
Value = tt.WEIGHT
});
cmd.Parameters.Add(new SqlParameter("@SAVEQTY", DbType.Decimal)
{
Value = tt.SAVEQTY
});
cmd.Parameters.Add(new SqlParameter("@STORGELIFE", DbType.String)
{
Value = tt.STORGELIFE
});
cmd.Parameters.Add(new SqlParameter("@VOID", DbType.Int32)
{
Value = tt.VOID
});
cmd.Parameters.Add(new SqlParameter("@UPDATETIME", DbType.String)
{
Value = tt.UPDATETIME
});
cmd.Parameters.Add(new SqlParameter("@UPDATEUSER", DbType.String)
{
Value = tt.UPDATEUSER
});
cmd.Parameters.Add(new SqlParameter("@ITEM_BK1", DbType.String)
{
Value = tt.ITEM_BK1
});
cmd.Parameters.Add(new SqlParameter("@ITEM_BK2", DbType.String)
{
Value = tt.ITEM_BK2
});
cmd.Parameters.Add(new SqlParameter("@ITEM_BK3", DbType.String)
{
Value = tt.ITEM_BK3
});
cmd.Parameters.Add(new SqlParameter("@SKU", DbType.String)
{
Value = tt.SKU
});
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);
}
}
public bool IM_Item_UpdateOne(IM_Item t_new)
{
return(SQL_da_IM_Item.UpdateOne(t_new));
}
public bool IM_Item_InsertOne(IM_Item t_new)
{
return(SQL_da_IM_Item.InsertNew(t_new));
}
public FormAddItem(IM_Item Item)
{
InitializeComponent();
item = Item;
}
