void edit(FishEntity.PackingWeightListEntity list, Hashtable SQLString, StringBuilder strSql)
{
strSql = new StringBuilder();
strSql.Append("update t_PackingWeightList set ");
strSql.Append("CONTANERNO=@CONTANERNO, ");
strSql.Append("QUANTITYOFBAGS=@QUANTITYOFBAGS, ");
strSql.Append("GROSSWEIGHT=@GROSSWEIGHT, ");
strSql.Append("NETWEIGHT=@NETWEIGHT, ");
strSql.Append("modifyman=@modifyman, ");
strSql.Append("modifytime=@modifytime ");
strSql.Append("where WarehouseCode=@WarehouseCode and ");
strSql.Append("FishId=@FishId");
MySqlParameter[] parameter =
{
new MySqlParameter("@CONTANERNO", list.CNOTANERNO),
new MySqlParameter("@QUANTITYOFBAGS", list.QUANTITYOFBAGS),
new MySqlParameter("@GROSSWEIGHT", list.GROSSWEIGHT),
new MySqlParameter("@NETWEIGHT", list.NETWEIGHT),
new MySqlParameter("@modifyman", list.Modifyman),
new MySqlParameter("@modifytime", list.Modifytime),
new MySqlParameter("@createman", list.Createman),
new MySqlParameter("@createtime", list.Createtime),
new MySqlParameter("@WarehouseCode", list.WarehouseCode),
new MySqlParameter("@FishId", list.FishId)
};
SQLString.Add(strSql, parameter);
}
public override void Save()
{
dataGridView1.EndEdit();
List <FishEntity.PackingWeightListEntity> ModelList = new List <FishEntity.PackingWeightListEntity>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.IsNewRow)
{
continue;
}
_List = new FishEntity.PackingWeightListEntity();
_List.WarehouseCode = num1; //row.Cells["WarehouseCode"].Value == null ? string.Empty : row.Cells["WarehouseCode"].Value.ToString();
_List.FishId = num2; //row.Cells["FishId"].Value == null ? string.Empty : row.Cells["FishId"].Value.ToString();
_List.CNOTANERNO = row.Cells["CONTANERNO"].Value == null ? string.Empty : row.Cells["CONTANERNO"].Value.ToString();
_List.QUANTITYOFBAGS = row.Cells["QUANTITYOFBAGS"].Value == null ? string.Empty : row.Cells["QUANTITYOFBAGS"].Value.ToString();
_List.GROSSWEIGHT = row.Cells["GROSSWEIGHT"].Value == null ? string.Empty : row.Cells["GROSSWEIGHT"].Value.ToString();
_List.NETWEIGHT = row.Cells["NETWEIGHT"].Value == null ? string.Empty : row.Cells["NETWEIGHT"].Value.ToString();
//_List.Createman=_List.Modifyman = FishEntity.Variable.User.username;
//_List.Createtime = _List.Createtime =DateTime.Now;
ModelList.Add(_List);
}
if (ModelList == null)
{
return;
}
bool result = _bll.add(ModelList);
if (result == true)
{
MessageBox.Show("保存成功");
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AllowUserToDeleteRows = false;
dataGridView1.ReadOnly = true;
tmiAdd.Visible = true;
tmiQuery.Visible = true;
tmiModify.Visible = false;
tmiDelete.Visible = false;
tmiReview.Visible = false;
tmiSave.Visible = false;
tmiCancel.Visible = false;
tmiExport.Visible = false;
tmiNext.Visible = false;
tmiPrevious.Visible = false;
tmiClose.Visible = true;
}
else
{
MessageBox.Show("保存失败,请重试");
}
base.Save();
}
public bool add(List <FishEntity.PackingWeightListEntity> modelList)
{
Hashtable SQLString = new Hashtable();
StringBuilder strSql = new StringBuilder();
foreach (FishEntity.PackingWeightListEntity list in modelList)
{
list.Createtime = list.Modifytime = dt();
list.Createman = list.Modifyman = FishEntity.Variable.User.username;
if (Exists(list.WarehouseCode, list.FishId) == true)
{
edit(list, SQLString, strSql);
}
else
{
insert(list, SQLString, strSql);
}
}
DataTable tab = table();
if (tab != null && tab.Rows.Count > 0)
{
FishEntity.PackingWeightListEntity list = new FishEntity.PackingWeightListEntity();
string person = string.Empty, proId = string.Empty;
for (int i = 0; i < tab.Rows.Count; i++)
{
person = tab.Rows[i]["WarehouseCode"].ToString();
proId = tab.Rows[i]["FishId"].ToString();
list = modelList.Find((k) =>
{
return(k.WarehouseCode.Equals(person) && k.FishId.Equals(proId));
});
if (list == null)
{
del(person, proId, SQLString, strSql);
}
}
}
return(MySqlHelper.ExecuteSqlTran(SQLString));
}
void insert(FishEntity.PackingWeightListEntity list, Hashtable SQLString, StringBuilder strSql)
{
strSql = new StringBuilder();
strSql.Append("insert into t_PackingWeightList (");
strSql.Append("WarehouseCode,FishId,CONTANERNO,QUANTITYOFBAGS,GROSSWEIGHT,NETWEIGHT,modifytime,modifyman,createman,createtime)");
strSql.Append("values (");
strSql.Append("@WarehouseCode,@FishId,@CONTANERNO,@QUANTITYOFBAGS,@GROSSWEIGHT,@NETWEIGHT,@modifytime,@modifyman,@createman,@createtime)");
MySqlParameter[] parameter =
{
new MySqlParameter("@WarehouseCode", list.WarehouseCode),
new MySqlParameter("@FishId", list.FishId),
new MySqlParameter("@CONTANERNO", list.CNOTANERNO),
new MySqlParameter("@QUANTITYOFBAGS", list.QUANTITYOFBAGS),
new MySqlParameter("@GROSSWEIGHT", list.GROSSWEIGHT),
new MySqlParameter("@NETWEIGHT", list.NETWEIGHT),
new MySqlParameter("@modifyman", list.Modifyman),
new MySqlParameter("@modifytime", list.Modifytime),
new MySqlParameter("@createman", list.Createman),
new MySqlParameter("@createtime", list.Createtime)
};
SQLString.Add(strSql, parameter);
}
public FishEntity.PackingWeightListEntity getModel(DataRow row)
{
FishEntity.PackingWeightListEntity model = new FishEntity.PackingWeightListEntity();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.Id = int.Parse(row["id"].ToString());
}
if (row["WarehouseCode"] != null)
{
model.WarehouseCode = row["WarehouseCode"].ToString();
}
if (row["FishId"] != null)
{
model.FishId = row["FishId"].ToString();
}
if (row["QUANTITYOFBAGS"] != null)
{
model.QUANTITYOFBAGS = row["QUANTITYOFBAGS"].ToString();
}
if (row["GROSSWEIGHT"] != null)
{
model.GROSSWEIGHT = row["GROSSWEIGHT"].ToString();
}
if (row["CONTANERNO"] != null)
{
model.CNOTANERNO = row["CONTANERNO"].ToString();
}
if (row["NETWEIGHT"] != null)
{
model.NETWEIGHT = row["NETWEIGHT"].ToString();
}
}
return(model);
}
