public FishEntity.DeliveredManagementEntity getModel(DataRow row)
{
FishEntity.DeliveredManagementEntity model = new FishEntity.DeliveredManagementEntity( );
if (row != null)
{
if (row ["tablePro"] != null)
{
model.TablePro = row ["tablePro"].ToString( );
}
if (row ["reviewDepart"] != null)
{
model.ReviewDepart = row ["reviewDepart"].ToString( );
}
if (row ["reviewUser"] != null)
{
model.ReviewUser = row ["reviewUser"].ToString( );
}
if (row ["examinDepart"] != null)
{
model.ExaminDepart = row ["examinDepart"].ToString( );
}
if (row ["examinUser"] != null)
{
model.ExaminUser = row ["examinUser"].ToString( );
}
}
return(model);
}
public void getvalue()
{
_model = new FishEntity.DeliveredManagementEntity();
_model.id = int.Parse(txtid.Text.ToString());
_model.cmbTJxssqd = cmbTJxssqd.Text.ToString();
_model.txtTJxssqd = txtTJxssqd.Text.ToString();
_model.cmbSGxssqd = cmbSGxssqd.Text.ToString();
_model.txtSGxssqd = txtSGxssqd.Text.ToString();
_model.cmbTJxsht = cmbTJxsht.Text.ToString();
_model.txtTJxsht = txtTJxsht.Text.ToString();
_model.cmbSGxsht = cmbSGxsht.Text.ToString();
_model.txtSGxsht = txtSGxsht.Text.ToString();
_model.cmbTJfksqd = cmbTJfksqd.Text.ToString();
_model.txtTJfksqd = txtTJfksqd.Text.ToString();
_model.cmbSGfksqd = cmbSGfksqd.Text.ToString();
_model.txtSGfksqd = txtSGfksqd.Text.ToString();
_model.cmbTJbd = cmbTJbd.Text.ToString();
_model.txtTJbd = txtTJbd.Text.ToString();
_model.cmbSGbd = cmbSGbd.Text.ToString();
_model.txtSGbd = txtSGbd.Text.ToString();
_model.cmbTJhwfkd = cmbTJhwfkd.Text.ToString();
_model.txtTJhwfkd = txtTJhwfkd.Text.ToString();
_model.cmbSGhwfkd = cmbSGhwfkd.Text.ToString();
_model.txtSGhwfkd = txtSGhwfkd.Text.ToString();
_model.cmbTJgswtfkd = cmbTJgswtfkd.Text.ToString();
_model.txtTJgswtfkd = txtTJgswtfkd.Text.ToString();
_model.cmbSGgswtfkd = cmbSGgswtfkd.Text.ToString();
_model.txtSGgswtfkd = txtSGgswtfkd.Text.ToString();
_model.cmbTJskjld = cmbTJskjld.Text.ToString();
_model.txtTJskjld = txtTJskjld.Text.ToString();
_model.cmbSGskjld = cmbSGskjld.Text.ToString();
_model.txtSGskjld = txtSGskjld.Text.ToString();
_model.createman = FishEntity.Variable.User.username;
_model.modifyman = FishEntity.Variable.User.username;
}
public void setValue(FishEntity.DeliveredManagementEntity _model)
{
txtid.Text = _model.id.ToString();
cmbTJxssqd.Text = _model.cmbTJxssqd;
txtTJxssqd.Text = _model.txtTJxssqd;
cmbSGxssqd.Text = _model.cmbSGxssqd;
txtSGxssqd.Text = _model.txtSGxssqd;
cmbTJxsht.Text = _model.cmbTJxsht;
txtTJxsht.Text = _model.txtTJxsht;
cmbSGxsht.Text = _model.cmbSGxsht;
txtSGxsht.Text = _model.txtSGxsht;
cmbTJfksqd.Text = _model.cmbTJfksqd;
txtTJfksqd.Text = _model.txtTJfksqd;
cmbSGfksqd.Text = _model.cmbSGfksqd;
txtSGfksqd.Text = _model.txtSGfksqd;
cmbTJbd.Text = _model.cmbTJbd;
txtTJbd.Text = _model.txtTJbd;
cmbSGbd.Text = _model.cmbSGbd;
txtSGbd.Text = _model.txtSGbd;
cmbTJhwfkd.Text = _model.cmbTJhwfkd;
txtTJhwfkd.Text = _model.txtTJhwfkd;
cmbSGhwfkd.Text = _model.cmbSGhwfkd;
txtSGhwfkd.Text = _model.txtSGhwfkd;
cmbTJgswtfkd.Text = _model.cmbTJgswtfkd;
txtTJgswtfkd.Text = _model.txtTJgswtfkd;
cmbSGgswtfkd.Text = _model.cmbSGgswtfkd;
txtSGgswtfkd.Text = _model.txtSGgswtfkd;
cmbTJskjld.Text = _model.cmbTJskjld;
txtTJskjld.Text = _model.txtTJskjld;
cmbSGskjld.Text = _model.cmbSGskjld;
txtSGskjld.Text = _model.txtSGskjld;
tmiAdd.Visible = false;
tmiSave.Visible = false;
}
private void rabExamine_Click(object sender, System.EventArgs e)
{
if (rabExamine.Checked == true)
{
getBll = new FishBll.Bll.DeliveredManagementBll();
getModel = new FishEntity.DeliveredManagementEntity();
getModel = getBll.getList("");
switch (this.programId)
{
case "FormSalesRequisition": texReview.Text = getModel.txtSGxssqd; break;
case "FormSalesRContract": texReview.Text = getModel.txtSGxsht; break;
case "FormPaymentRequisition": texReview.Text = getModel.txtSGfksqd; break;
case "FormOnepound": texReview.Text = getModel.txtSGbd; break;
case "FormCargoFeedbackSheet": texReview.Text = getModel.txtSGhwfkd + "|" + getcreateman; break;
case "FormTheproblemsheet": texReview.Text = getModel.txtSGgswtfkd; break;
case "FormReceiptRecord": texReview.Text = getModel.txtSGskjld; break;
}
}
}
public void getQuery()
{
_bll = new FishBll.Bll.DeliveredManagementBll();
_model = new FishEntity.DeliveredManagementEntity();
_model = _bll.getList(strWhere);
if (_model != null)
{
setValue(_model);
}
else
{
tmiAdd.Visible = true;
}
}
public void getQuery()
{
_bll = new FishBll.Bll.DeliveredManagementBll();
_model = new FishEntity.DeliveredManagementEntity();
//_model = _bll.getList(strWhere);
List <FishEntity.DeliveredManagementEntity> modelList = _bll.getModelList( );
if (modelList != null && modelList.Count > 0)
{
setValue(modelList);
}
else
{
tmiAdd.Visible = true;
}
}
public bool Update(FishEntity.DeliveredManagementEntity _list)
{
return(dal.Update(_list));
}
public bool Add(FishEntity.DeliveredManagementEntity _list)
{
return(dal.Add(_list));
}
public bool Update(FishEntity.DeliveredManagementEntity _list)
{
StringBuilder Strsql = new StringBuilder();
_list.modifytime = getDate();
Strsql.Append("update t_deliveredmanagement set ");
Strsql.Append("cmbTJxssqd=@cmbTJxssqd,");
Strsql.Append("txtTJxssqd=@txtTJxssqd,");
Strsql.Append("cmbSGxssqd=@cmbSGxssqd,");
Strsql.Append("txtSGxssqd=@txtSGxssqd,");
Strsql.Append("cmbTJxsht=@cmbTJxsht,");
Strsql.Append("txtTJxsht=@txtTJxsht,");
Strsql.Append("cmbSGxsht=@cmbSGxsht,");
Strsql.Append("txtSGxsht=@txtSGxsht,");
Strsql.Append("cmbTJfksqd=@cmbTJfksqd,");
Strsql.Append("txtTJfksqd=@txtTJfksqd,");
Strsql.Append("cmbSGfksqd=@cmbSGfksqd,");
Strsql.Append("txtSGfksqd=@txtSGfksqd,");
Strsql.Append("cmbTJbd=@cmbTJbd,");
Strsql.Append("txtTJbd=@txtTJbd,");
Strsql.Append("cmbSGbd=@cmbSGbd,");
Strsql.Append("txtSGbd=@txtSGbd,");
Strsql.Append("cmbTJhwfkd=@cmbTJhwfkd,");
Strsql.Append("txtTJhwfkd=@txtTJhwfkd,");
Strsql.Append("cmbSGhwfkd=@cmbSGhwfkd,");
Strsql.Append("txtSGhwfkd=@txtSGhwfkd,");
Strsql.Append("cmbTJgswtfkd=@cmbTJgswtfkd,");
Strsql.Append("txtTJgswtfkd=@txtTJgswtfkd,");
Strsql.Append("cmbSGgswtfkd=@cmbSGgswtfkd,");
Strsql.Append("txtSGgswtfkd=@txtSGgswtfkd,");
Strsql.Append("cmbTJskjld=@cmbTJskjld,");
Strsql.Append("txtTJskjld=@txtTJskjld,");
Strsql.Append("cmbSGskjld=@cmbSGskjld,");
Strsql.Append("txtSGskjld=@txtSGskjld,");
Strsql.Append("modifyman=@modifyman,");
Strsql.Append("modifytime=@modifytime ");
Strsql.Append("where id=@id");
MySqlParameter[] parameter =
{
new MySqlParameter("@cmbTJxssqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJxssqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGxssqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGxssqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJxsht", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJxsht", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGxsht", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGxsht", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJfksqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJfksqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGfksqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGfksqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJbd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJbd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGbd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGbd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJhwfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJhwfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGhwfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGhwfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJgswtfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJgswtfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGgswtfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGgswtfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJskjld", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJskjld", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGskjld", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGskjld", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.DateTime),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
};
parameter[0].Value = _list.cmbTJxssqd;
parameter[1].Value = _list.txtTJxssqd;
parameter[2].Value = _list.cmbSGxssqd;
parameter[3].Value = _list.txtSGxssqd;
parameter[4].Value = _list.cmbTJxsht;
parameter[5].Value = _list.txtTJxsht;
parameter[6].Value = _list.cmbSGxsht;
parameter[7].Value = _list.txtSGxsht;
parameter[8].Value = _list.cmbTJfksqd;
parameter[9].Value = _list.txtTJfksqd;
parameter[10].Value = _list.cmbSGfksqd;
parameter[11].Value = _list.txtSGfksqd;
parameter[12].Value = _list.cmbTJbd;
parameter[13].Value = _list.txtTJbd;
parameter[14].Value = _list.cmbSGbd;
parameter[15].Value = _list.txtSGbd;
parameter[16].Value = _list.cmbTJhwfkd;
parameter[17].Value = _list.txtTJhwfkd;
parameter[18].Value = _list.cmbSGhwfkd;
parameter[19].Value = _list.txtSGhwfkd;
parameter[20].Value = _list.cmbTJgswtfkd;
parameter[21].Value = _list.txtTJgswtfkd;
parameter[22].Value = _list.cmbSGgswtfkd;
parameter[23].Value = _list.txtSGgswtfkd;
parameter[24].Value = _list.cmbTJskjld;
parameter[25].Value = _list.txtTJskjld;
parameter[26].Value = _list.cmbSGskjld;
parameter[27].Value = _list.txtSGskjld;
parameter[28].Value = _list.modifyman;
parameter[29].Value = _list.modifytime;
parameter[30].Value = _list.id;
int row = MySqlHelper.ExecuteSql(Strsql.ToString(), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public FishEntity.DeliveredManagementEntity GetDataRow(DataRow row)
{
FishEntity.DeliveredManagementEntity model = new FishEntity.DeliveredManagementEntity();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["cmbTJxssqd"] != null)
{
model.cmbTJxssqd = row["cmbTJxssqd"].ToString();
}
if (row["txtTJxssqd"] != null)
{
model.txtTJxssqd = row["txtTJxssqd"].ToString();
}
if (row["cmbSGxssqd"] != null)
{
model.cmbSGxssqd = row["cmbSGxssqd"].ToString();
}
if (row["txtSGxssqd"] != null)
{
model.txtSGxssqd = row["txtSGxssqd"].ToString();
}
if (row["cmbTJxsht"] != null)
{
model.cmbTJxsht = row["cmbTJxsht"].ToString();
}
if (row["txtTJxsht"] != null)
{
model.txtTJxsht = row["txtTJxsht"].ToString();
}
if (row["cmbSGxsht"] != null)
{
model.cmbSGxsht = row["cmbSGxsht"].ToString();
}
if (row["txtSGxsht"] != null)
{
model.txtSGxsht = row["txtSGxsht"].ToString();
}
if (row["cmbTJfksqd"] != null)
{
model.cmbTJfksqd = row["cmbTJfksqd"].ToString();
}
if (row["txtTJfksqd"] != null)
{
model.txtTJfksqd = row["txtTJfksqd"].ToString();
}
if (row["cmbSGfksqd"] != null)
{
model.cmbSGfksqd = row["cmbSGfksqd"].ToString();
}
if (row["txtSGfksqd"] != null)
{
model.txtSGfksqd = row["txtSGfksqd"].ToString();
}
if (row["cmbTJbd"] != null)
{
model.cmbTJbd = row["cmbTJbd"].ToString();
}
if (row["txtTJbd"] != null)
{
model.txtTJbd = row["txtTJbd"].ToString();
}
if (row["cmbSGbd"] != null)
{
model.cmbSGbd = row["cmbSGbd"].ToString();
}
if (row["txtSGbd"] != null)
{
model.txtSGbd = row["txtSGbd"].ToString();
}
if (row["cmbTJhwfkd"] != null)
{
model.cmbTJhwfkd = row["cmbTJhwfkd"].ToString();
}
if (row["txtTJhwfkd"] != null)
{
model.txtTJhwfkd = row["txtTJhwfkd"].ToString();
}
if (row["cmbSGhwfkd"] != null)
{
model.cmbSGhwfkd = row["cmbSGhwfkd"].ToString();
}
if (row["txtSGhwfkd"] != null)
{
model.txtSGhwfkd = row["txtSGhwfkd"].ToString();
}
if (row["cmbTJgswtfkd"] != null)
{
model.cmbTJgswtfkd = row["cmbTJgswtfkd"].ToString();
}
if (row["txtTJgswtfkd"] != null)
{
model.txtTJgswtfkd = row["txtTJgswtfkd"].ToString();
}
if (row["cmbSGgswtfkd"] != null)
{
model.cmbSGgswtfkd = row["cmbSGgswtfkd"].ToString();
}
if (row["txtSGgswtfkd"] != null)
{
model.txtSGgswtfkd = row["txtSGgswtfkd"].ToString();
}
if (row["cmbTJskjld"] != null)
{
model.cmbTJskjld = row["cmbTJskjld"].ToString();
}
if (row["txtTJskjld"] != null)
{
model.txtTJskjld = row["txtTJskjld"].ToString();
}
if (row["cmbSGskjld"] != null)
{
model.cmbSGskjld = row["cmbSGskjld"].ToString();
}
if (row["txtSGskjld"] != null)
{
model.txtSGskjld = row["txtSGskjld"].ToString();
}
if (row["createman"] != null)
{
model.createman = row["createman"].ToString();
}
if (row["createtime"] != null)
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["modifyman"] != null)
{
model.modifyman = row["modifyman"].ToString();
}
if (row["modifytime"] != null)
{
model.modifytime = DateTime.Parse(row["modifytime"].ToString());
}
}
return(model);
}
public bool Add(FishEntity.DeliveredManagementEntity _list)
{
StringBuilder Strsql = new StringBuilder();
_list.createtime = _list.modifytime = getDate();
Strsql.Append("insert into t_deliveredmanagement(cmbTJxssqd,txtTJxssqd,cmbSGxssqd,txtSGxssqd,cmbTJxsht,txtTJxsht,cmbSGxsht,txtSGxsht,cmbTJfksqd,txtTJfksqd,cmbSGfksqd,txtSGfksqd,cmbTJbd,txtTJbd,cmbSGbd,txtSGbd,cmbTJhwfkd,txtTJhwfkd,cmbSGhwfkd,txtSGhwfkd,cmbTJgswtfkd,txtTJgswtfkd,cmbSGgswtfkd,txtSGgswtfkd,cmbTJskjld,txtTJskjld,cmbSGskjld,txtSGskjld,createman,createtime,modifyman,modifytime)values");
Strsql.Append("(@cmbTJxssqd,@txtTJxssqd,@cmbSGxssqd,@txtSGxssqd,@cmbTJxsht,@txtTJxsht,@cmbSGxsht,@txtSGxsht,@cmbTJfksqd,@txtTJfksqd,@cmbSGfksqd,@txtSGfksqd,@cmbTJbd,@txtTJbd,@cmbSGbd,@txtSGbd,@cmbTJhwfkd,@txtTJhwfkd,@cmbSGhwfkd,@txtSGhwfkd,@cmbTJgswtfkd,@txtTJgswtfkd,@cmbSGgswtfkd,@txtSGgswtfkd,@cmbTJskjld,@txtTJskjld,@cmbSGskjld,@txtSGskjld,@createman,@createtime,@modifyman,@modifytime)");
MySqlParameter[] parameter =
{
new MySqlParameter("@cmbTJxssqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJxssqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGxssqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGxssqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJxsht", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJxsht", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGxsht", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGxsht", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJfksqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJfksqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGfksqd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGfksqd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJbd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJbd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGbd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGbd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJhwfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJhwfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGhwfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGhwfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJgswtfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJgswtfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGgswtfkd", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGgswtfkd", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbTJskjld", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtTJskjld", MySqlDbType.VarChar, 200),
new MySqlParameter("@cmbSGskjld", MySqlDbType.VarChar, 45),
new MySqlParameter("@txtSGskjld", MySqlDbType.VarChar, 200),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@createtime", MySqlDbType.DateTime),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.DateTime)
};
parameter[0].Value = _list.cmbTJxssqd;
parameter[1].Value = _list.txtTJxssqd;
parameter[2].Value = _list.cmbSGxssqd;
parameter[3].Value = _list.txtSGxssqd;
parameter[4].Value = _list.cmbTJxsht;
parameter[5].Value = _list.txtTJxsht;
parameter[6].Value = _list.cmbSGxsht;
parameter[7].Value = _list.txtSGxsht;
parameter[8].Value = _list.cmbTJfksqd;
parameter[9].Value = _list.txtTJfksqd;
parameter[10].Value = _list.cmbSGfksqd;
parameter[11].Value = _list.txtSGfksqd;
parameter[12].Value = _list.cmbTJbd;
parameter[13].Value = _list.txtTJbd;
parameter[14].Value = _list.cmbSGbd;
parameter[15].Value = _list.txtSGbd;
parameter[16].Value = _list.cmbTJhwfkd;
parameter[17].Value = _list.txtTJhwfkd;
parameter[18].Value = _list.cmbSGhwfkd;
parameter[19].Value = _list.txtSGhwfkd;
parameter[20].Value = _list.cmbTJgswtfkd;
parameter[21].Value = _list.txtTJgswtfkd;
parameter[22].Value = _list.cmbSGgswtfkd;
parameter[23].Value = _list.txtSGgswtfkd;
parameter[24].Value = _list.cmbTJskjld;
parameter[25].Value = _list.txtTJskjld;
parameter[26].Value = _list.cmbSGskjld;
parameter[27].Value = _list.txtSGskjld;
parameter[28].Value = _list.createman;
parameter[29].Value = _list.createtime;
parameter[30].Value = _list.modifyman;
parameter[31].Value = _list.modifytime;
int row = MySqlHelper.ExecuteSql(Strsql.ToString(), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
List <FishEntity.DeliveredManagementEntity> getValue( )
{
List <FishEntity.DeliveredManagementEntity> modelList = new List <FishEntity.DeliveredManagementEntity> ( );
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormSalesRequisition";
_model.ReviewDepart = cmbTJxssqd.Text;
_model.ReviewUser = txtTJxssqd.Text;
_model.ExaminDepart = cmbSGxssqd.Text;
_model.ExaminUser = txtSGxssqd.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormSalesRContract";
_model.ReviewDepart = cmbTJxsht.Text;
_model.ReviewUser = txtTJxsht.Text;
_model.ExaminDepart = cmbSGxsht.Text;
_model.ExaminUser = txtSGxsht.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormPaymentRequisition";
_model.ReviewDepart = cmbTJfksqd.Text;
_model.ReviewUser = txtTJfksqd.Text;
_model.ExaminDepart = cmbSGfksqd.Text;
_model.ExaminUser = txtSGfksqd.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormOnepound";
_model.ReviewDepart = cmbTJbd.Text;
_model.ReviewUser = txtTJbd.Text;
_model.ExaminDepart = cmbSGbd.Text;
_model.ExaminUser = txtSGbd.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormCargoFeedbackSheet";
_model.ReviewDepart = cmbTJhwfkd.Text;
_model.ReviewUser = txtTJhwfkd.Text;
_model.ExaminDepart = cmbSGhwfkd.Text;
_model.ExaminUser = txtSGhwfkd.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormTheproblemsheet";
_model.ReviewDepart = cmbTJgswtfkd.Text;
_model.ReviewUser = txtTJgswtfkd.Text;
_model.ExaminDepart = cmbSGgswtfkd.Text;
_model.ExaminUser = txtSGgswtfkd.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormReceiptRecord";
_model.ReviewDepart = cmbTJskjld.Text;
_model.ReviewUser = txtTJskjld.Text;
_model.ExaminDepart = cmbSGskjld.Text;
_model.ExaminUser = txtSGskjld.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormPurchaseApplication";
_model.ReviewDepart = cmbCgR.Text;
_model.ReviewUser = txtCgR.Text;
_model.ExaminDepart = cmbCgE.Text;
_model.ExaminUser = txtCgE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormPurcurementContract";
_model.ReviewDepart = cmbCgCR.Text;
_model.ReviewUser = txtCgCR.Text;
_model.ExaminDepart = cmbCgCE.Text;
_model.ExaminUser = txtCgCE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormWarehouseReceipt";
_model.ReviewDepart = cmJcR.Text;
_model.ReviewUser = txtJcR.Text;
_model.ExaminDepart = txtJcE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormStorageOfRequisition";
_model.ReviewDepart = cmbRkR.Text;
_model.ReviewUser = txtRkR.Text;
_model.ExaminDepart = cmbRkE.Text;
_model.ExaminUser = txtRkE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormBatchSheet";
_model.ReviewDepart = cmbPlR.Text;
_model.ReviewUser = txtPlR.Text;
_model.ExaminDepart = cmbPlE.Text;
_model.ExaminUser = txtPlE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormQuotationPriceList";
_model.ReviewDepart = cmbHqR.Text;
_model.ReviewUser = txtHqR.Text;
_model.ExaminDepart = cmbHqE.Text;
_model.ExaminUser = txtHqE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormFinishedProList";
_model.ReviewDepart = cmbCkR.Text;
_model.ReviewUser = txtCkR.Text;
_model.ExaminDepart = cmbCpE.Text;
_model.ExaminUser = txtCpE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormCustomStandardTable";
_model.ReviewDepart = cmbBzR.Text;
_model.ReviewUser = txtBzR.Text;
_model.ExaminDepart = cmbBzE.Text;
_model.ExaminUser = txtBzE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormBilloflading";
_model.ReviewDepart = cmbThR.Text;
_model.ReviewUser = txtThR.Text;
_model.ExaminDepart = cmbThE.Text;
_model.ExaminUser = txtThE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormOutboundOrder";
_model.ReviewDepart = cmbckdR.Text;
_model.ReviewUser = txtckdR.Text;
_model.ExaminDepart = cmbckdE.Text;
_model.ExaminUser = txtckdE.Text;
modelList.Add(_model);
_model = new FishEntity.DeliveredManagementEntity( );
_model.TablePro = "FormReturnReceipt";
_model.ReviewDepart = cmbThdR.Text;
_model.ReviewUser = txtThdR.Text;
_model.ExaminDepart = cmbThdE.Text;
_model.ExaminUser = txtThdE.Text;
modelList.Add(_model);
return(modelList);
}
