public override int Query()
{
panel1.Enabled = true;
if (_Form == null)
{
_Form = new UIForms.CargoFeedbackSheetCondition();
_Form.StartPosition = FormStartPosition.CenterParent;
_Form.ShowInTaskbar = false;
}
if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return(0);
}
_where = _Form.GetWhereCondition;
List <FishEntity.CargoFeedbackSheetEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
MessageBox.Show("查无数据！");
return(1);
}
else
{
_fish = list[0];
SetOnepound();
panel1.Enabled = true;
}
return(1);
}
public bool Update(FishEntity.CargoFeedbackSheetEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_CargoFeedbackSheet set ");
strSql.Append("code = @code,");
strSql.Append("sponsor=@sponsor,");
strSql.Append("acceptor=@acceptor,");
strSql.Append("processresult=@processresult,");
strSql.Append("evaluation=@evaluation,");
strSql.Append("attendance=@attendance,");
strSql.Append("review=@review,");
strSql.Append("remarks=@remarks,");
strSql.Append("modifytime = @modifytime,");
strSql.Append("modifyman = @modifyman, ");
strSql.Append("ConfirmTheWeight=@ConfirmTheWeight,");
strSql.Append("codeContract=@codeContract ");
strSql.Append(" where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@sponsor", MySqlDbType.VarChar, 45),
new MySqlParameter("@acceptor", MySqlDbType.VarChar, 45),
new MySqlParameter("@processresult", MySqlDbType.VarChar, 200),
new MySqlParameter("@evaluation", MySqlDbType.VarChar, 200),
new MySqlParameter("@attendance", MySqlDbType.VarChar, 120),
new MySqlParameter("@review", MySqlDbType.VarChar, 45),
new MySqlParameter("@remarks", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@ConfirmTheWeight", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Sponsor;
parameters[2].Value = model.Acceptor;
parameters[3].Value = model.Processresult;
parameters[4].Value = model.Evaluation;
parameters[5].Value = model.Attendance;
parameters[6].Value = model.Review;
parameters[7].Value = model.Remarks;
parameters[8].Value = model.Modifytime;
parameters[9].Value = model.Modifyman;
parameters[10].Value = model.ConfirmTheWeight;
parameters [11].Value = model.codeContract;
parameters [12].Value = model.Id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(FishEntity.CargoFeedbackSheetEntity model)
{
StringBuilder Strsql = new StringBuilder();
Strsql.Append("insert into t_CargoFeedbackSheet(Numbering,code,sponsor,acceptor,processresult,evaluation,attendance,review,remarks,modifytime,modifyman,createtime,createman,ConfirmTheWeight,FishMealId,PoundDifference,NetWeight,PoundBillNumber,codeContract)");
Strsql.Append("values(@Numbering,@code,@sponsor,@acceptor,@processresult,@evaluation,@attendance,@review,@remarks,@modifytime,@modifyman,@createtime,@createman,@ConfirmTheWeight,@FishMealId,@PoundDifference,@NetWeight,@PoundBillNumber,@codeContract);");
Strsql.Append("select last_insert_id();");
MySqlParameter[] parameter =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@sponsor", MySqlDbType.VarChar, 45),
new MySqlParameter("@acceptor", MySqlDbType.VarChar, 45),
new MySqlParameter("@processresult", MySqlDbType.VarChar, 200),
new MySqlParameter("@evaluation", MySqlDbType.VarChar, 200),
new MySqlParameter("@attendance", MySqlDbType.VarChar, 120),
new MySqlParameter("@review", MySqlDbType.VarChar, 45),
new MySqlParameter("@remarks", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@ConfirmTheWeight", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundDifference", MySqlDbType.VarChar, 50),
new MySqlParameter("@NetWeight", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundBillNumber", MySqlDbType.VarChar, 50)
};
parameter[0].Value = model.Code;
parameter[1].Value = model.Sponsor;
parameter[2].Value = model.Acceptor;
parameter[3].Value = model.Processresult;
parameter[4].Value = model.Evaluation;
parameter[5].Value = model.Attendance;
parameter[6].Value = model.Review;
parameter[7].Value = model.Remarks;
parameter[8].Value = model.Modifytime;
parameter[9].Value = model.Modifyman;
parameter[10].Value = model.Createtime;
parameter[11].Value = model.Createman;
parameter[12].Value = model.ConfirmTheWeight;
parameter [13].Value = model.codeContract;
parameter[14].Value = model.Numbering;
parameter[15].Value = model.FishMealId;
parameter[16].Value = model.PoundDifference;
parameter[17].Value = model.NetWeight;
parameter[18].Value = model.PoundBillNumber;
int id = MySqlHelper.ExecuteSqlReturnId(Strsql.ToString(), parameter);
return(id);
}
private void FormCargoFeedbackSheet_Load(object sender, EventArgs e)
{
MenuCode = "M411"; ControlButtomRoles();
//Megres.oddNum = getname;
if (Megres.oddNum != "" && Megres.oddNum.ToString() != "")
{
_rolewhere = " code='" + Megres.oddNum + "'";
List <FishEntity.CargoFeedbackSheetEntity> list = _bll.GetModelListVo(_rolewhere);
getname = Megres.oddNum;
Megres.oddNum = string.Empty;
if (list == null || list.Count < 1)
{
_fish = null;
}
else
{
_fish = list[0];
SetOnepound();
this.panel1.Enabled = true;
}
}
}
public override void Save()
{
if (string.IsNullOrEmpty(txtCodeOdd.Text))
{
MessageBox.Show("请选择销售合同号");
return;
}
FishEntity.CargoFeedbackSheetEntity _fish = new FishEntity.CargoFeedbackSheetEntity();
_fish.Code = FishBll.Bll.SequenceUtil.GetCargoFeedbackSheetSequence();
decimal temp;
_fish.Sponsor = txtsponsor.Text.Trim();
_fish.Acceptor = txtacceptor.Text.Trim();
_fish.Processresult = txtprocessresult.Text.Trim();
_fish.Evaluation = txtevaluation.Text.Trim();
_fish.Attendance = txtattendance.Text.Trim();
_fish.Review = txtreview.Text.Trim();
_fish.Remarks = txtremarks.Text.Trim();
_fish.ConfirmTheWeight = txtConfirmTheWeight.Text;
_fish.Createtime = DateTime.Now;
_fish.Createman = FishEntity.Variable.User.username;
_fish.Modifytime = DateTime.Now;
_fish.Modifyman = FishEntity.Variable.User.username;
_fish.codeContract = txtCodeOdd.Text;
_fish.Numbering = txtNumbering.Text;
FishBll.Bll.CargoFeedbackSheetBll bll = new FishBll.Bll.CargoFeedbackSheetBll();
bool isok = bll.Exists(_fish.Code);
while (isok)
{
_fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence();
isok = bll.Exists(_fish.Code);
}
int id = bll.Add(_fish);
if (id > 0)
{
_fish.Id = id;
if (txtNumbering.Text != "")
{
_Refreshbll = new FishBll.Bll.ProcessStateBll();
_Refreshbll.GetFormCargoFeedbackSheet(txtNumbering.Text);
}
tmiSave.Visible = false;
tmiClose.Visible = true;
tmiCancel.Visible = false;
tmiDelete.Visible = true;
tmiReview.Visible = true;
tmiAdd.Visible = true;
tmiModify.Visible = true;
tmiQuery.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _fish.Code.ToString();
txtcreateman.Text = _fish.Createman.ToString();
txtmodifyman.Text = _fish.Modifyman.ToString();
}
else
{
// txtCode.Text = _fish.Code;
MessageBox.Show("添加失败。");
}
}
public override void Save()
{
if (string.IsNullOrEmpty(txtCodeOdd.Text))
{
MessageBox.Show("请选择销售合同号");
return;
}
if (check() == false)
{
return;
}
_fish = new FishEntity.CargoFeedbackSheetEntity();
_fish.Code = FishBll.Bll.SequenceUtil.GetCargoFeedbackSheetSequence();
decimal temp;
_fish.Remarks = txtremarks.Text.Trim();
_fish.ConfirmTheWeight = txtConfirmTheWeight.Text;
_fish.Createtime = DateTime.Now;
_fish.Createman = FishEntity.Variable.User.username;
_fish.Modifytime = DateTime.Now;
_fish.Modifyman = FishEntity.Variable.User.username;
_fish.codeContract = txtCodeOdd.Text;
_fish.Numbering = txtNumbering.Text;
_fish.FishMealId = txtFishMealId.Text;
_fish.PoundBillNumber = txtPoundBillNumber.Text;
_fish.PoundDifference = txtPoundDifference.Text;
_fish.NetWeight = txtNetWeight.Text;
FishBll.Bll.CargoFeedbackSheetBll bll = new FishBll.Bll.CargoFeedbackSheetBll();
bool isok = bll.Exists(_fish.Code);
while (isok)
{
_fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence();
isok = bll.Exists(_fish.Code);
}
decimal dOne = 0M;
int id = 0;
if (!string.IsNullOrEmpty(_fish.PoundDifference) && decimal.TryParse(_fish.PoundDifference, out dOne) && dOne <= 0)
{
id = bll.Add(_fish, this.Name);
}
else
{
id = bll.Add(_fish);
}
if (id > 0)
{
_fish.Id = id;
//if ( txtNumbering . Text != "" )
//{
// _Refreshbll = new FishBll . Bll . ProcessStateBll ( );
// _Refreshbll . GetFormCargoFeedbackSheet ( txtNumbering . Text );
//}
tmiSave.Visible = false;
tmiClose.Visible = true;
tmiCancel.Visible = false;
tmiDelete.Visible = true;
tmiReview.Visible = true;
tmiAdd.Visible = true;
tmiModify.Visible = true;
tmiQuery.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _fish.Code.ToString( );
txtcreateman.Text = _fish.Createman.ToString( );
txtmodifyman.Text = _fish.Modifyman.ToString( );
}
else
{
// txtCode.Text = _fish.Code;
MessageBox.Show("添加失败。");
}
}
public List <FishEntity.CargoFeedbackSheetEntity> GetModelListVo(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from t_CargoFeedbackSheet ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataSet ds = MySqlHelper.Query(strSql.ToString());
List <FishEntity.CargoFeedbackSheetEntity> modelList = new List <FishEntity.CargoFeedbackSheetEntity>();
int rowsCount = ds.Tables[0].Rows.Count;
FishEntity.CargoFeedbackSheetEntity model;
for (int n = 0; n < rowsCount; n++)
{
DataRow row = ds.Tables[0].Rows[n];
model = new FishEntity.CargoFeedbackSheetEntity();
if (row["id"].ToString() != "")
{
model.Id = int.Parse(row["id"].ToString());
}
if (row["code"] != null && row["code"].ToString() != "")
{
model.Code = row["code"].ToString();
}
if (row["Numbering"] != null)
{
model.Numbering = row["Numbering"].ToString();
}
if (row["sponsor"] != null && row["sponsor"].ToString() != "")
{
model.Sponsor = row["sponsor"].ToString();
}
if (row["acceptor"] != null && row["acceptor"].ToString() != "")
{
model.Acceptor = row["acceptor"].ToString();
}
if (row["processresult"] != null && row["processresult"].ToString() != "")
{
model.Processresult = row["processresult"].ToString();
}
if (row["evaluation"] != null && row["evaluation"].ToString() != "")
{
model.Evaluation = row["evaluation"].ToString();
}
if (row["attendance"] != null && row["attendance"].ToString() != "")
{
model.Attendance = row["attendance"].ToString();
}
if (row["review"] != null && row["review"].ToString() != "")
{
model.Review = row["review"].ToString();
}
if (row["remarks"] != null && row["remarks"].ToString() != "")
{
model.Remarks = row["remarks"].ToString();
}
if (row ["codeContract"] != null && row ["codeContract"].ToString( ) != "")
{
model.codeContract = row ["codeContract"].ToString( );
}
if (row["ConfirmTheWeight"] != null)
{
model.ConfirmTheWeight = row["ConfirmTheWeight"].ToString();
}
if (row["createman"] != null)
{
model.Createman = row["createman"].ToString();
}
if (row["modifyman"] != null)
{
model.Modifyman = row["modifyman"].ToString();
}
if (row["FishMealId"] != null)
{
model.FishMealId = row["FishMealId"].ToString();
}
if (row["PoundDifference"] != null)
{
model.PoundDifference = row["PoundDifference"].ToString();
}
if (row["NetWeight"] != null)
{
model.NetWeight = row["NetWeight"].ToString();
}
if (row["PoundBillNumber"] != null)
{
model.PoundBillNumber = row["PoundBillNumber"].ToString();
}
modelList.Add(model);
}
return(modelList);
}
public bool Update(FishEntity.CargoFeedbackSheetEntity model, string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_CargoFeedbackSheet set ");
strSql.Append("code = @code,");
strSql.Append("sponsor=@sponsor,");
strSql.Append("acceptor=@acceptor,");
strSql.Append("processresult=@processresult,");
strSql.Append("evaluation=@evaluation,");
strSql.Append("attendance=@attendance,");
strSql.Append("review=@review,");
strSql.Append("remarks=@remarks,");
strSql.Append("modifytime = @modifytime,");
strSql.Append("modifyman = @modifyman, ");
strSql.Append("ConfirmTheWeight=@ConfirmTheWeight,");
strSql.Append("FishMealId=@FishMealId,");
strSql.Append("PoundDifference=@PoundDifference,");
strSql.Append("NetWeight=@NetWeight,");
strSql.Append("PoundBillNumber=@PoundBillNumber,");
strSql.Append("codeContract=@codeContract ");
strSql.Append(" where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@sponsor", MySqlDbType.VarChar, 45),
new MySqlParameter("@acceptor", MySqlDbType.VarChar, 45),
new MySqlParameter("@processresult", MySqlDbType.VarChar, 200),
new MySqlParameter("@evaluation", MySqlDbType.VarChar, 200),
new MySqlParameter("@attendance", MySqlDbType.VarChar, 120),
new MySqlParameter("@review", MySqlDbType.VarChar, 45),
new MySqlParameter("@remarks", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@ConfirmTheWeight", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundDifference", MySqlDbType.VarChar, 50),
new MySqlParameter("@NetWeight", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundBillNumber", MySqlDbType.VarChar, 50),
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Sponsor;
parameters[2].Value = model.Acceptor;
parameters[3].Value = model.Processresult;
parameters[4].Value = model.Evaluation;
parameters[5].Value = model.Attendance;
parameters[6].Value = model.Review;
parameters[7].Value = model.Remarks;
parameters[8].Value = model.Modifytime;
parameters[9].Value = model.Modifyman;
parameters[10].Value = model.ConfirmTheWeight;
parameters [11].Value = model.codeContract;
parameters [12].Value = model.Id;
parameters[13].Value = model.FishMealId;
parameters[14].Value = model.PoundDifference;
parameters[15].Value = model.NetWeight;
parameters[16].Value = model.PoundBillNumber;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
if (Convert.ToDecimal(model.NetWeight.ToString()) == Convert.ToDecimal(model.ConfirmTheWeight.ToString()) && model.Code != "")
{
StringBuilder strSql1 = new StringBuilder();
strSql1.AppendFormat("insert into t_review (userName,programId,SingleNumber,date,content,state,userNameReview,Numbering) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", FishEntity.Variable.User.username, name, model.Code, DateTime.Now, "自动审核", "审核", "自动审核", model.Numbering);
int qq = MySqlHelper.ExecuteSqlReturnId(strSql1.ToString(), null);
}
return(true);
}
else
{
return(false);
}
}
public int Add(FishEntity.CargoFeedbackSheetEntity model, string name)
{
Hashtable SQLString = new Hashtable( );
SQLString = ReviewInfo.getSQLString(name, model.codeContract, string.Empty, SQLString);
StringBuilder Strsql = new StringBuilder( );
Strsql.Append("insert into t_CargoFeedbackSheet(Numbering,code,sponsor,acceptor,processresult,evaluation,attendance,review,remarks,modifytime,modifyman,createtime,createman,ConfirmTheWeight,FishMealId,PoundDifference,NetWeight,PoundBillNumber,codeContract)");
Strsql.Append("values(@Numbering,@code,@sponsor,@acceptor,@processresult,@evaluation,@attendance,@review,@remarks,@modifytime,@modifyman,@createtime,@createman,@ConfirmTheWeight,@FishMealId,@PoundDifference,@NetWeight,@PoundBillNumber,@codeContract);");
//Strsql . Append ( "select last_insert_id();" );
MySqlParameter [] parameter =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@sponsor", MySqlDbType.VarChar, 45),
new MySqlParameter("@acceptor", MySqlDbType.VarChar, 45),
new MySqlParameter("@processresult", MySqlDbType.VarChar, 200),
new MySqlParameter("@evaluation", MySqlDbType.VarChar, 200),
new MySqlParameter("@attendance", MySqlDbType.VarChar, 120),
new MySqlParameter("@review", MySqlDbType.VarChar, 45),
new MySqlParameter("@remarks", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@ConfirmTheWeight", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundDifference", MySqlDbType.VarChar, 50),
new MySqlParameter("@NetWeight", MySqlDbType.VarChar, 50),
new MySqlParameter("@PoundBillNumber", MySqlDbType.VarChar, 50)
};
parameter [0].Value = model.Code;
parameter [1].Value = model.Sponsor;
parameter [2].Value = model.Acceptor;
parameter [3].Value = model.Processresult;
parameter [4].Value = model.Evaluation;
parameter [5].Value = model.Attendance;
parameter [6].Value = model.Review;
parameter [7].Value = model.Remarks;
parameter [8].Value = model.Modifytime;
parameter [9].Value = model.Modifyman;
parameter [10].Value = model.Createtime;
parameter [11].Value = model.Createman;
parameter [12].Value = model.ConfirmTheWeight;
parameter [13].Value = model.codeContract;
parameter [14].Value = model.Numbering;
parameter [15].Value = model.FishMealId;
parameter [16].Value = model.PoundDifference;
parameter [17].Value = model.NetWeight;
parameter [18].Value = model.PoundBillNumber;
SQLString.Add(Strsql, parameter);
if (MySqlHelper.ExecuteSqlTran(SQLString))
{
Strsql = new StringBuilder( );
Strsql.AppendFormat("select id from t_CargoFeedbackSheet where code='{0}'", model.Code);
if (Convert.ToDecimal(model.NetWeight.ToString()) == Convert.ToDecimal(model.ConfirmTheWeight.ToString()) && model.Code != "")
{
StringBuilder strSql1 = new StringBuilder();
strSql1.AppendFormat("insert into t_review (userName,programId,SingleNumber,date,content,state,userNameReview,Numbering) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", FishEntity.Variable.User.username, name, model.Code, DateTime.Now, "自动审核", "审核", "自动审核", model.Numbering);
int qq = MySqlHelper.ExecuteSqlReturnId(strSql1.ToString(), null);
}
DataTable dt = MySqlHelper.Query(Strsql.ToString( )).Tables [0];
if (dt != null && dt.Rows.Count > 0)
{
return(string.IsNullOrEmpty(dt.Rows [0] ["id"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Rows [0] ["id"].ToString( )));
}
else
{
return(0);
}
}
else
{
return(0);
}
}
public bool Update(FishEntity.CargoFeedbackSheetEntity model, string name)
{
return(dal.Update(model, name));
}
public int Add(FishEntity.CargoFeedbackSheetEntity model, string name)
{
return(dal.Add(model, name));
}
public int Add(FishEntity.CargoFeedbackSheetEntity model)
{
return(dal.Add(model));
}
public bool Update(FishEntity.CargoFeedbackSheetEntity model)
{
return(dal.Update(model));
}