public override int Query()
{
panel1.Enabled = true;
if (_Form == null)
{
_Form = new UIForms.FormContractProcessingSheetConditicon();
_Form.StartPosition = FormStartPosition.CenterParent;
_Form.ShowInTaskbar = false;
}
if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return(0);
}
_where = _Form.GetWhereCondition;
List <FishEntity.ContractProcessingSheetEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy);
if (list == null || list.Count < 1)
{
_fish = null;
return(1);
}
else
{
_fish = list[0];
Set();
}
return(1);
}
public int Add(FishEntity.ContractProcessingSheetEntity model)
{
StringBuilder Strsql = new StringBuilder();
Strsql.Append("insert into t_ContractProcessingSheet(code,contractcode,tdate,TheReason,Processing,createtime,createman,modifytime,modifyman)");
Strsql.Append("values(@code,@contractcode,@tdate,@TheReason,@Processing,@createtime,@createman,@modifytime,@modifyman);");
Strsql.Append("select last_insert_id();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@contractcode", MySqlDbType.VarChar, 45),
new MySqlParameter("@tdate", MySqlDbType.DateTime),
new MySqlParameter("@TheReason", MySqlDbType.VarChar, 200),
new MySqlParameter("@Processing", MySqlDbType.VarChar, 200),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Contractcode;
parameters[2].Value = model.Tdate;
parameters[3].Value = model.TheReason;
parameters[4].Value = model.Processing;
parameters[5].Value = model.Createtime;
parameters[6].Value = model.Createman;
parameters[7].Value = model.Modifytime;
parameters[8].Value = model.Modifyman;
int id = MySqlHelper.ExecuteSqlReturnId(Strsql.ToString(), parameters);
return(id);
}
private void FormContractProcessingSheet_Load(object sender, EventArgs e)
{
_rolewhere = " and code='" + Megres.oddNum + "'";
List <FishEntity.ContractProcessingSheetEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy);
Megres.oddNum = string.Empty;
if (list == null || list.Count < 1)
{
_fish = null;
}
else
{
_fish = list [0];
Set( );
this.panel1.Enabled = true;
menuStrip1.Visible = true;
tmiQuery.Visible = true;
tmiPrevious.Visible = false;
tmiExport.Visible = false;
tmiReview.Visible = true;
tmiAdd.Visible = false;
tmiModify.Visible = false;
tmiDelete.Visible = false;
tmiClose.Visible = true;
tmiCancel.Visible = false;
tmiSave.Visible = false;
tmiNext.Visible = false;
tmiprint.Visible = false;
}
}
public List <FishEntity.ContractProcessingSheetEntity> GetModelListVo(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from t_ContractProcessingSheet ");
if (strWhere.Trim() != "")
{
strSql.Append(" where 1=1 " + strWhere);
}
DataSet ds = MySqlHelper.Query(strSql.ToString());
List <FishEntity.ContractProcessingSheetEntity> modelList = new List <FishEntity.ContractProcessingSheetEntity>();
int rowsCount = ds.Tables[0].Rows.Count;
FishEntity.ContractProcessingSheetEntity model;
for (int n = 0; n < rowsCount; n++)
{
DataRow row = ds.Tables[0].Rows[n];
model = new FishEntity.ContractProcessingSheetEntity();
if (row["id"].ToString() != "")
{
model.Id = int.Parse(row["id"].ToString());
}
if (row["contractcode"] != null && row["contractcode"].ToString() != "")
{
model.Contractcode = row["contractcode"].ToString();
}
if (row["code"] != null && row["code"].ToString() != "")
{
model.Code = row["code"].ToString();
}
if (row["tdate"] != null && row["tdate"].ToString() != "")
{
model.Tdate = DateTime.Parse(row["tdate"].ToString());
}
if (row["TheReason"] != null && row["TheReason"].ToString() != "")
{
model.TheReason = row["TheReason"].ToString();
}
if (row["Processing"] != null && row["Processing"].ToString() != "")
{
model.Processing = row["Processing"].ToString();
}
modelList.Add(model);
}
return(modelList);
}
public bool Update(FishEntity.ContractProcessingSheetEntity model)
{
StringBuilder Strsql = new StringBuilder();
Strsql.Append("update t_ContractProcessingSheet set ");
Strsql.Append("code=@code,");
Strsql.Append("contractcode=@contractcode,");
Strsql.Append("tdate=@tdate,");
Strsql.Append("TheReason=@TheReason,");
Strsql.Append("Processing=@Processing,");
Strsql.Append("modifytime=@modifytime,");
Strsql.Append("modifyman=@modifyman ");
Strsql.Append("where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@contractcode", MySqlDbType.VarChar, 45),
new MySqlParameter("@tdate", MySqlDbType.DateTime),
new MySqlParameter("@TheReason", MySqlDbType.VarChar, 200),
new MySqlParameter("@Processing", MySqlDbType.VarChar, 200),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Contractcode;
parameters[2].Value = model.Tdate;
parameters[3].Value = model.TheReason;
parameters[4].Value = model.Processing;
parameters[5].Value = model.Modifytime;
parameters[6].Value = model.Modifyman;
parameters[7].Value = model.Id;
int rows = MySqlHelper.ExecuteSql(Strsql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public override void Save()
{
FishEntity.ContractProcessingSheetEntity _fish = new FishEntity.ContractProcessingSheetEntity();
_fish.Code = FishBll.Bll.SequenceUtil.GetContractProcessingSheetquence();
_fish.Contractcode = txtcontractcode.Text.Trim();
_fish.Tdate = dtptdate.Value;
_fish.TheReason = txtTheReason.Text.Trim();
_fish.Processing = txtProcessing.Text.Trim();
_fish.Createtime = DateTime.Now;
_fish.Createman = FishEntity.Variable.User.username;
_fish.Modifytime = DateTime.Now;
_fish.Modifyman = FishEntity.Variable.User.username;
FishBll.Bll.FormContractProcessingSheetBll bll = new FishBll.Bll.FormContractProcessingSheetBll();
bool isok = bll.Exists(_fish.Code);
while (isok)
{
_fish.Code = FishBll.Bll.SequenceUtil.GetContractProcessingSheetquence();
isok = bll.Exists(_fish.Code);
}
int id = bll.Add(_fish);
if (id > 0)
{
_fish.Id = id;
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = false;
tmiAdd.Visible = false;
tmiSave.Visible = true;
tmiCancel.Visible = true;
MessageBox.Show("添加成功。");
txtcode.Text = _fish.Code.ToString();
}
else
{
// txtCode.Text = _fish.Code;
MessageBox.Show("添加失败。");
}
}
public bool Update(FishEntity.ContractProcessingSheetEntity model)
{
return(dal.Update(model));
}
public int Add(FishEntity.ContractProcessingSheetEntity model)
{
return(dal.Add(model));
}
