public override int Query()
{
if (_FormThe == null)
{
_FormThe = new UIForms.FormTheproblemsheetCodition();
_FormThe.StartPosition = FormStartPosition.CenterParent;
_FormThe.ShowInTaskbar = false;
}
if (_FormThe.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return(0);
}
_where = _FormThe.GetWhereCondition;
List <FishEntity.TheproblemsheetEntityVo> list = _TheBll.GetModelListVo(_where + _rolewhere + _orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
return(1);
}
else
{
_fish = list[0];
SetTheproblemsheet();
panel1.Enabled = true;
return(1);
}
}
private void FormTheproblemsheet_Load(object sender, EventArgs e)
{
MenuCode = "M309"; ControlButtomRoles();
if (Megres.oddNum != null && Megres.oddNum != "")
{
_rolewhere = " and code='" + Megres.oddNum + "'";
List <FishEntity.TheproblemsheetEntityVo> list = _TheBll.GetModelListVo(_rolewhere);
getname = Megres.oddNum;
Megres.oddNum = string.Empty;
if (list == null || list.Count < 1)
{
_fish = null;
}
else
{
_fish = list[0];
SetTheproblemsheet();
this.panel1.Enabled = true;
menuStrip1.Visible = true;
tmiQuery.Visible = true;
tmiPrevious.Visible = false;
tmiExport.Visible = false;
tmiReview.Visible = true;
tmiAdd.Visible = false;
tmiModify.Visible = true;
tmiDelete.Visible = false;
tmiClose.Visible = true;
tmiCancel.Visible = false;
tmiSave.Visible = false;
tmiNext.Visible = false;
tmiprint.Visible = false;
}
}
}
public bool Update(FishEntity.TheproblemsheetEntity model, string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_theproblemsheet set ");
strSql.Append(" ContractNo = @ContractNo,");
strSql.Append(" occurDate = @occurDate,");
strSql.Append(" EventName = @EventName,");
strSql.Append(" SolvTtheProblem = @SolvTtheProblem,");
strSql.Append(" Remarks = @Remarks,");
strSql.Append(" modifytime = @modifytime,");
strSql.Append(" modifyman = @modifyman,");
strSql.Append("codeContract=@codeContract,");
strSql.Append("FishMealId=@FishMealId,");
strSql.Append("Chargeback=@Chargeback");
strSql.Append(" where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45),
new MySqlParameter("@occurDate", MySqlDbType.DateTime),
new MySqlParameter("@EventName", MySqlDbType.VarChar, 500),
new MySqlParameter("@SolvTtheProblem", MySqlDbType.VarChar, 500),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@Chargeback", MySqlDbType.Decimal, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.ContractNo;
parameters[1].Value = model.OccurDate;
parameters[2].Value = model.EventName;
parameters[3].Value = model.SolvTtheProblem;
parameters[4].Value = model.Remarks;
parameters[5].Value = model.Modifytime;
parameters[6].Value = model.Modifyman;
parameters [7].Value = model.codeContract;
parameters [8].Value = model.Id;
parameters[9].Value = model.Chargeback;
parameters[10].Value = model.FishMealId;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
if (model.Chargeback == 0 && 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);
MySqlHelper.ExecuteSqlReturnId(strSql1.ToString(), null);
}
return(true);
}
else
{
return(false);
}
}
public override void Save()
{
decimal temp = 0;
FishEntity.TheproblemsheetEntity _The = new FishEntity.TheproblemsheetEntity();
_The.Code = FishBll.Bll.SequenceUtil.GetTheproblemsheet();
_The.ContractNo = txtContractNo.Text;
decimal.TryParse(txtChargeback.Text, out temp);
_The.Chargeback = temp;
_The.OccurDate = dtpoccurDate.Value;
_The.EventName = txtEventName.Text;
_The.SolvTtheProblem = txtSolvTtheProblem.Text;
_The.Remarks = txtRemarks.Text;
_The.Createtime = DateTime.Now;
_The.Createman = FishEntity.Variable.User.username;
_The.Modifytime = DateTime.Now;
_The.Modifyman = _The.Createman;
_The.codeContract = txtCodeOdd.Text;
_The.Numbering = txtNumbering.Text;
FishBll.Bll.TheproblemsheetBll bll = new FishBll.Bll.TheproblemsheetBll();
bool isok = bll.Exists(_The.Code);
while (isok)
{
_The.Code = FishBll.Bll.SequenceUtil.GetTheproblemsheet();
isok = bll.Exists(_The.Code);
}
int id = bll.Add(_The);
if (id > 0)
{
_The.Id = id;
if (txtNumbering.Text != "")
{
_Refreshbll = new FishBll.Bll.ProcessStateBll();
_Refreshbll.GetFormTheproblemsheet(txtNumbering.Text);
}
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = false;
tmiSave.Visible = false;
tmiAdd.Visible = false;
tmiCancel.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _The.Code;
}
else
{
txtcode.Text = _The.Code;
MessageBox.Show("添加失败。");
}
}
public bool Update(FishEntity.TheproblemsheetEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_theproblemsheet set ");
strSql.Append(" ContractNo = @ContractNo,");
strSql.Append(" occurDate = @occurDate,");
strSql.Append(" EventName = @EventName,");
strSql.Append(" SolvTtheProblem = @SolvTtheProblem,");
strSql.Append(" Remarks = @Remarks,");
strSql.Append(" modifytime = @modifytime,");
strSql.Append(" modifyman = @modifyman,");
strSql.Append("codeContract=@codeContract,");
strSql.Append("Chargeback=@Chargeback");
strSql.Append(" where id = @id");
MySqlParameter[] parameters =
{
new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45),
new MySqlParameter("@occurDate", MySqlDbType.DateTime),
new MySqlParameter("@EventName", MySqlDbType.VarChar, 500),
new MySqlParameter("@SolvTtheProblem", MySqlDbType.VarChar, 500),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@Chargeback", MySqlDbType.Decimal, 45)
};
parameters[0].Value = model.ContractNo;
parameters[1].Value = model.OccurDate;
parameters[2].Value = model.EventName;
parameters[3].Value = model.SolvTtheProblem;
parameters[4].Value = model.Remarks;
parameters[5].Value = model.Modifytime;
parameters[6].Value = model.Modifyman;
parameters [7].Value = model.codeContract;
parameters [8].Value = model.Id;
parameters[9].Value = model.Chargeback;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(FishEntity.TheproblemsheetEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_theproblemsheet(Numbering,code, ContractNo, occurDate, EventName, SolvTtheProblem, Remarks, createtime, createman, modifytime, modifyman,codeContract,Chargeback,FishMealId) ");
strSql.Append("values(@Numbering,@code, @ContractNo, @occurDate, @EventName, @SolvTtheProblem, @Remarks, @createtime, @createman, @modifytime, @modifyman,@codeContract,@Chargeback,@FishMealId); select last_insert_id();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45),
new MySqlParameter("@occurDate", MySqlDbType.DateTime),
new MySqlParameter("@EventName", MySqlDbType.VarChar, 500),
new MySqlParameter("@SolvTtheProblem", MySqlDbType.VarChar, 500),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Chargeback", MySqlDbType.Decimal, 45),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.ContractNo;
parameters[2].Value = model.OccurDate;
parameters[3].Value = model.EventName;
parameters[4].Value = model.SolvTtheProblem;
parameters[5].Value = model.Remarks;
parameters[6].Value = model.Createtime;
parameters[7].Value = model.Createman;
parameters[8].Value = model.Modifytime;
parameters[9].Value = model.Modifyman;
parameters [10].Value = model.codeContract;
parameters[11].Value = model.Chargeback;
parameters[12].Value = model.Numbering;
parameters[13].Value = model.FishMealId;
int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters);
return(id);
}
public int Add(FishEntity.TheproblemsheetEntity model, string name)
{
Hashtable SQLString = new Hashtable( );
SQLString = ReviewInfo.getSQLString(name, model.Code, string.Empty, SQLString);
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into t_theproblemsheet(Numbering,code, ContractNo, occurDate, EventName, SolvTtheProblem, Remarks, createtime, createman, modifytime, modifyman,codeContract,Chargeback,FishMealId) ");
strSql.Append("values(@Numbering,@code, @ContractNo, @occurDate, @EventName, @SolvTtheProblem, @Remarks, @createtime, @createman, @modifytime, @modifyman,@codeContract,@Chargeback,@FishMealId); "); //select last_insert_id();
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45),
new MySqlParameter("@occurDate", MySqlDbType.DateTime),
new MySqlParameter("@EventName", MySqlDbType.VarChar, 500),
new MySqlParameter("@SolvTtheProblem", MySqlDbType.VarChar, 500),
new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeContract", MySqlDbType.VarChar, 200),
new MySqlParameter("@Chargeback", MySqlDbType.Decimal, 45),
new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50)
};
parameters [0].Value = model.Code;
parameters [1].Value = model.ContractNo;
parameters [2].Value = model.OccurDate;
parameters [3].Value = model.EventName;
parameters [4].Value = model.SolvTtheProblem;
parameters [5].Value = model.Remarks;
parameters [6].Value = model.Createtime;
parameters [7].Value = model.Createman;
parameters [8].Value = model.Modifytime;
parameters [9].Value = model.Modifyman;
parameters [10].Value = model.codeContract;
parameters [11].Value = model.Chargeback;
parameters [12].Value = model.Numbering;
parameters [13].Value = model.FishMealId;
SQLString.Add(strSql, parameters);
if (MySqlHelper.ExecuteSqlTran(SQLString))
{
strSql = new StringBuilder( );
strSql.AppendFormat("select id,code from t_theproblemsheet where code='{0}'", model.Code);
DataTable dt = MySqlHelper.Query(strSql.ToString( )).Tables [0];
if (model.Chargeback == 0 && dt.Rows[0]["code"].ToString() != "")
{
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, dt.Rows[0]["code"].ToString(), DateTime.Now, "自动审核", "审核", "自动审核", model.Numbering);
MySqlHelper.ExecuteSqlReturnId(strSql1.ToString(), null);
}
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.TheproblemsheetEntity model)
{
return(dal.Update(model));
}
public int Add(FishEntity.TheproblemsheetEntity model)
{
return(dal.Add(model));
}
public bool Update(FishEntity.TheproblemsheetEntity model, string name)
{
return(dal.Update(model, name));
}
public int Add(FishEntity.TheproblemsheetEntity model, string name)
{
return(dal.Add(model, name));
}