protected void QueryOne(string operate, string orderBy)
{
string whereEx = string.Empty;
if (string.IsNullOrEmpty(_where))
{
whereEx = " 1=1 ";
}
else
{
whereEx = _where;
}
if (_entity != null)
{
whereEx += " and code " + operate + "'" + _entity.code + "'";
}
List <FishEntity.FoodOutEntity> list = _bll.GetModelList(whereEx + orderBy);
if (list == null || list.Count < 1)
{
MessageBox.Show("已经没有记录了!");
return;
}
_entity = list[0];
SetEntity();
SetDetail();
}
public override int Query()
{
//TODO
_entity = null;
QueryOne(">", " order by id asc limit 1");
return(1);
}
public override void Save()
{
_entity = new FishEntity.FoodOutEntity();
_entity.createman = FishEntity.Variable.User.username;
_entity.createtime = DateTime.Now;
_entity.modifyman = FishEntity.Variable.User.username;
_entity.modifytime = _entity.createtime;
_entity.indate = DateTime.Now;
_entity.productdate = dtpProductionDate.Value;
_entity.outdate = dtpOutoftime.Value;
_entity.Brand = cmbBrand.SelectedValue == null ? string.Empty : cmbBrand.SelectedValue.ToString();
_entity.productlabel = txtFishLabel.Text;
_entity.Quality = cmbSpecification.SelectedValue == null ? string.Empty : cmbSpecification.SelectedValue.ToString();
_entity.remark = txtRemark.Text;
_entity.code = FishBll.Bll.SequenceUtil.GetFoodOutSequence();
bool isok = _bll.Exists(_entity.code);
while (isok)
{
_entity.code = FishBll.Bll.SequenceUtil.GetFoodOutSequence();
isok = _bll.Exists(_entity.code);
}
int id = _bll.Add(_entity);
if (id > 0)
{
_entity.id = id;
decimal cost_hj = 0;
txtcode.Text = _entity.code;
AddDetails(id, true, out cost_hj, _entity.solutionid, 0);
tmiQuery.Visible = false;
tmiDelete.Visible = false;
tmiModify.Visible = false;
tmiAdd.Visible = false;
tmiSave.Visible = true;
tmiCancel.Visible = true;
ControlButtomRoles();
MessageBox.Show("添加成功。");
}
else
{
MessageBox.Show("添加失败。");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FishEntity.FoodOutEntity GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,code,productdate,outdate,productid,productcode,productlabel,weight,package,remark,createman,createtime,modifyman,modifytime,cost,deliverymanid,deliveryman,solutionid,salemanid,saleman,indate,companyid,companycode,companyname from t_foodout ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
FishEntity.FoodOutEntity model = new FishEntity.FoodOutEntity();
DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.FoodOutEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FishEntity.FoodOutEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FishEntity.FoodOutEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_foodout(");
strSql.Append("code,productdate,outdate,productid,productcode,productlabel,weight,package,remark,createman,createtime,modifyman,modifytime,cost,deliverymanid,deliveryman,solutionid,salemanid,saleman,indate,companyid,companycode,companyname,Brand,quality)");
strSql.Append(" values (");
strSql.Append("@code,@productdate,@outdate,@productid,@productcode,@productlabel,@weight,@package,@remark,@createman,@createtime,@modifyman,@modifytime,@cost,@deliverymanid,@deliveryman,@solutionid,@salemanid,@saleman,@indate,@companyid,@companycode,@companyname,@Brand,@quality);");
strSql.Append("select LAST_INSERT_ID();");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 20),
new MySqlParameter("@productdate", MySqlDbType.Timestamp),
new MySqlParameter("@outdate", MySqlDbType.Timestamp),
new MySqlParameter("@productid", MySqlDbType.Int32, 11),
new MySqlParameter("@productcode", MySqlDbType.VarChar, 45),
new MySqlParameter("@productlabel", MySqlDbType.VarChar, 45),
new MySqlParameter("@weight", MySqlDbType.Decimal, 12),
new MySqlParameter("@package", MySqlDbType.Int32, 8),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@cost", MySqlDbType.Decimal, 12),
new MySqlParameter("@deliverymanid", MySqlDbType.Int32, 11),
new MySqlParameter("@deliveryman", MySqlDbType.VarChar, 255),
new MySqlParameter("@solutionid", MySqlDbType.Int32, 11),
new MySqlParameter("@salemanid", MySqlDbType.Int32, 45),
new MySqlParameter("@saleman", MySqlDbType.VarChar, 255),
new MySqlParameter("@indate", MySqlDbType.Timestamp),
new MySqlParameter("@companyid", MySqlDbType.Int32, 6),
new MySqlParameter("@companycode", MySqlDbType.VarChar, 45),
new MySqlParameter("@companyname", MySqlDbType.VarChar, 225),
new MySqlParameter("@Brand", MySqlDbType.VarChar, 45),
new MySqlParameter("@quality", MySqlDbType.VarChar, 45)
};
parameters[0].Value = model.code;
parameters[1].Value = model.productdate;
parameters[2].Value = model.outdate;
parameters[3].Value = model.productid;
parameters[4].Value = model.productcode;
parameters[5].Value = model.productlabel;
parameters[6].Value = model.weight;
parameters[7].Value = model.package;
parameters[8].Value = model.remark;
parameters[9].Value = model.createman;
parameters[10].Value = model.createtime;
parameters[11].Value = model.modifyman;
parameters[12].Value = model.modifytime;
parameters[13].Value = model.cost;
parameters[14].Value = model.deliverymanid;
parameters[15].Value = model.deliveryman;
parameters[16].Value = model.solutionid;
parameters[17].Value = model.salemanid;
parameters[18].Value = model.saleman;
parameters[19].Value = model.indate;
parameters[20].Value = model.companyid;
parameters[21].Value = model.companycode;
parameters[22].Value = model.companyname;
parameters[23].Value = model.Brand;
parameters[24].Value = model.Quality;
int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters);
return(id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FishEntity.FoodOutEntity DataRowToModel(DataRow row)
{
FishEntity.FoodOutEntity model = new FishEntity.FoodOutEntity();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["code"] != null)
{
model.code = row["code"].ToString();
}
if (row["productdate"] != null && row["productdate"].ToString() != "")
{
model.productdate = DateTime.Parse(row["productdate"].ToString());
}
if (row["outdate"] != null && row["outdate"].ToString() != "")
{
model.outdate = DateTime.Parse(row["outdate"].ToString());
}
if (row["productid"] != null && row["productid"].ToString() != "")
{
model.productid = int.Parse(row["productid"].ToString());
}
if (row["productcode"] != null)
{
model.productcode = row["productcode"].ToString();
}
if (row["productlabel"] != null)
{
model.productlabel = row["productlabel"].ToString();
}
if (row["weight"] != null && row["weight"].ToString() != "")
{
model.weight = decimal.Parse(row["weight"].ToString());
}
if (row["package"] != null && row["package"].ToString() != "")
{
model.package = int.Parse(row["package"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["createman"] != null)
{
model.createman = row["createman"].ToString();
}
if (row["createtime"] != null && row["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(row["createtime"].ToString());
}
if (row["modifyman"] != null)
{
model.modifyman = row["modifyman"].ToString();
}
if (row["modifytime"] != null && row["modifytime"].ToString() != "")
{
model.modifytime = DateTime.Parse(row["modifytime"].ToString());
}
if (row["cost"] != null && row["cost"].ToString() != "")
{
model.cost = decimal.Parse(row["cost"].ToString());
}
if (row["deliverymanid"] != null && row["deliverymanid"].ToString() != "")
{
model.deliverymanid = int.Parse(row["deliverymanid"].ToString());
}
if (row["deliveryman"] != null)
{
model.deliveryman = row["deliveryman"].ToString();
}
if (row["solutionid"] != null && row["solutionid"].ToString() != "")
{
model.solutionid = int.Parse(row["solutionid"].ToString());
}
if (row["salemanid"] != null && row["salemanid"].ToString() != "")
{
model.salemanid = int.Parse(row["salemanid"].ToString());
}
if (row["saleman"] != null)
{
model.saleman = row["saleman"].ToString();
}
if (row["indate"] != null && row["indate"].ToString() != "")
{
model.indate = DateTime.Parse(row["indate"].ToString());
}
if (row["companyid"] != null && row["companyid"].ToString() != "")
{
model.companyid = int.Parse(row["companyid"].ToString());
}
if (row["companycode"] != null)
{
model.companycode = row["companycode"].ToString();
}
if (row["companyname"] != null)
{
model.companyname = row["companyname"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FishEntity.FoodOutEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_foodout set ");
strSql.Append("code=@code,");
strSql.Append("productid=@productid,");
strSql.Append("productcode=@productcode,");
strSql.Append("productlabel=@productlabel,");
strSql.Append("weight=@weight,");
strSql.Append("package=@package,");
strSql.Append("remark=@remark,");
strSql.Append("createman=@createman,");
strSql.Append("modifyman=@modifyman,");
strSql.Append("cost=@cost,");
strSql.Append("deliverymanid=@deliverymanid,");
strSql.Append("deliveryman=@deliveryman,");
strSql.Append("solutionid=@solutionid,");
strSql.Append("salemanid=@salemanid,");
strSql.Append("saleman=@saleman,");
strSql.Append("indate=@indate,");
strSql.Append("outdate=@outdate,");
strSql.Append("companyid=@companyid,");
strSql.Append("companycode=@companycode,");
strSql.Append("companyname=@companyname");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 20),
new MySqlParameter("@productid", MySqlDbType.Int32, 11),
new MySqlParameter("@productcode", MySqlDbType.VarChar, 45),
new MySqlParameter("@productlabel", MySqlDbType.VarChar, 45),
new MySqlParameter("@weight", MySqlDbType.Decimal, 12),
new MySqlParameter("@package", MySqlDbType.Int32, 8),
new MySqlParameter("@remark", MySqlDbType.VarChar, 255),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@cost", MySqlDbType.Decimal, 12),
new MySqlParameter("@deliverymanid", MySqlDbType.Int32, 11),
new MySqlParameter("@deliveryman", MySqlDbType.VarChar, 255),
new MySqlParameter("@solutionid", MySqlDbType.Int32, 11),
new MySqlParameter("@salemanid", MySqlDbType.Int32, 45),
new MySqlParameter("@saleman", MySqlDbType.VarChar, 255),
new MySqlParameter("@indate", MySqlDbType.Timestamp),
new MySqlParameter("@outdate", MySqlDbType.Timestamp),
new MySqlParameter("@companyid", MySqlDbType.Int32, 6),
new MySqlParameter("@companycode", MySqlDbType.VarChar, 45),
new MySqlParameter("@companyname", MySqlDbType.VarChar, 225),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.code;
parameters[1].Value = model.productid;
parameters[2].Value = model.productcode;
parameters[3].Value = model.productlabel;
parameters[4].Value = model.weight;
parameters[5].Value = model.package;
parameters[6].Value = model.remark;
parameters[7].Value = model.createman;
parameters[8].Value = model.modifyman;
parameters[9].Value = model.cost;
parameters[10].Value = model.deliverymanid;
parameters[11].Value = model.deliveryman;
parameters[12].Value = model.solutionid;
parameters[13].Value = model.salemanid;
parameters[14].Value = model.saleman;
parameters[15].Value = model.indate;
parameters[16].Value = model.outdate;
parameters[17].Value = model.companyid;
parameters[18].Value = model.companycode;
parameters[19].Value = model.companyname;
parameters[20].Value = model.id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
