/// <summary> /// 增加一条数据 /// </summary> public bool Add(FishEntity.OutboundOrderEntity 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_outboundorder("); strSql.Append("seNumber,code,unit,type,shipName,weight,pileNum,codeNum,codeNumContract,date,waseHouse,speci,billName,pageNum,remark,notice,ware,receive,FishMealId,Country,Brands)"); strSql.Append(" values ("); strSql.Append("@seNumber,@code,@unit,@type,@shipName,@weight,@pileNum,@codeNum,@codeNumContract,@date,@waseHouse,@speci,@billName,@pageNum,@remark,@notice,@ware,@receive,@FishMealId,@Country,@Brands)"); MySqlParameter [] parameters = { new MySqlParameter("@seNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@unit", MySqlDbType.VarChar, 45), new MySqlParameter("@type", MySqlDbType.VarChar, 45), new MySqlParameter("@shipName", MySqlDbType.VarChar, 45), new MySqlParameter("@weight", MySqlDbType.Decimal, 10), new MySqlParameter("@pileNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45), new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@waseHouse", MySqlDbType.VarChar, 45), new MySqlParameter("@speci", MySqlDbType.VarChar, 45), new MySqlParameter("@billName", MySqlDbType.VarChar, 45), new MySqlParameter("@pageNum", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 225), new MySqlParameter("@notice", MySqlDbType.VarChar, 45), new MySqlParameter("@ware", MySqlDbType.Decimal, 10), new MySqlParameter("@receive", MySqlDbType.VarChar, 45), new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50), new MySqlParameter("@Country", MySqlDbType.VarChar, 50), new MySqlParameter("@Brands", MySqlDbType.VarChar, 50) }; parameters [0].Value = model.seNumber; parameters [1].Value = model.code; parameters [2].Value = model.unit; parameters [3].Value = model.type; parameters [4].Value = model.shipName; parameters [5].Value = model.weight; parameters [6].Value = model.pileNum; parameters [7].Value = model.codeNum; parameters [8].Value = model.codeNumContract; parameters [9].Value = model.date; parameters [10].Value = model.waseHouse; parameters [11].Value = model.speci; parameters [12].Value = model.billName; parameters [13].Value = model.pageNum; parameters [14].Value = model.remark; parameters [15].Value = model.notice; parameters [16].Value = model.ware; parameters [17].Value = model.receive; parameters [18].Value = model.FishMealId; parameters [19].Value = model.Country; parameters [20].Value = model.Brands; SQLString.Add(strSql, parameters); return(MySqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.OutboundOrderEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FishEntity.OutboundOrderEntity model, string name) { return(dal.Add(model, name)); }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.OutboundOrderEntity DataRowToModel(DataRow row) { FishEntity.OutboundOrderEntity model = new FishEntity.OutboundOrderEntity( ); if (row != null) { if (row ["id"] != null && row ["id"].ToString( ) != "") { model.id = int.Parse(row ["id"].ToString( )); } if (row ["seNumber"] != null) { model.seNumber = row ["seNumber"].ToString( ); } if (row ["code"] != null) { model.code = row ["code"].ToString( ); } if (row ["unit"] != null) { model.unit = row ["unit"].ToString( ); } if (row ["type"] != null) { model.type = row ["type"].ToString( ); } if (row ["shipName"] != null) { model.shipName = row ["shipName"].ToString( ); } if (row ["weight"] != null && row ["weight"].ToString( ) != "") { model.weight = decimal.Parse(row ["weight"].ToString( )); } if (row ["pileNum"] != null) { model.pileNum = row ["pileNum"].ToString( ); } if (row ["codeNum"] != null) { model.codeNum = row ["codeNum"].ToString( ); } if (row ["codeNumContract"] != null) { model.codeNumContract = row ["codeNumContract"].ToString( ); } if (row ["date"] != null && row ["date"].ToString( ) != "") { model.date = DateTime.Parse(row ["date"].ToString( )); } if (row ["waseHouse"] != null) { model.waseHouse = row ["waseHouse"].ToString( ); } if (row ["speci"] != null) { model.speci = row ["speci"].ToString( ); } if (row ["billName"] != null) { model.billName = row ["billName"].ToString( ); } if (row ["pageNum"] != null && row ["pageNum"].ToString( ) != "") { model.pageNum = int.Parse(row ["pageNum"].ToString( )); } if (row ["remark"] != null) { model.remark = row ["remark"].ToString( ); } if (row ["notice"] != null) { model.notice = row ["notice"].ToString( ); } if (row ["ware"] != null && row ["ware"].ToString( ) != "") { model.ware = decimal.Parse(row ["ware"].ToString( )); } if (row ["receive"] != null) { model.receive = row ["receive"].ToString( ); } if (row["FishMealId"] != null) { model.FishMealId = row["FishMealId"].ToString(); } if (row["Country"] != null) { model.Country = row["Country"].ToString(); } if (row["Brands"] != null) { model.Brands = row["Brands"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.OutboundOrderEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update t_outboundorder set "); strSql.Append("seNumber=@seNumber,"); strSql.Append("unit=@unit,"); strSql.Append("type=@type,"); strSql.Append("shipName=@shipName,"); strSql.Append("weight=@weight,"); strSql.Append("pileNum=@pileNum,"); strSql.Append("codeNum=@codeNum,"); strSql.Append("codeNumContract=@codeNumContract,"); strSql.Append("date=@date,"); strSql.Append("waseHouse=@waseHouse,"); strSql.Append("speci=@speci,"); strSql.Append("billName=@billName,"); strSql.Append("pageNum=@pageNum,"); strSql.Append("remark=@remark,"); strSql.Append("notice=@notice,"); strSql.Append("ware=@ware,"); strSql.Append("FishMealId=@FishMealId,"); strSql.Append("Country=@Country,"); strSql.Append("Brands=@Brands,"); strSql.Append("receive=@receive"); strSql.Append(" where code=@code "); MySqlParameter [] parameters = { new MySqlParameter("@seNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@unit", MySqlDbType.VarChar, 45), new MySqlParameter("@type", MySqlDbType.VarChar, 45), new MySqlParameter("@shipName", MySqlDbType.VarChar, 45), new MySqlParameter("@weight", MySqlDbType.Decimal, 10), new MySqlParameter("@pileNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNum", MySqlDbType.VarChar, 45), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45), new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@waseHouse", MySqlDbType.VarChar, 45), new MySqlParameter("@speci", MySqlDbType.VarChar, 45), new MySqlParameter("@billName", MySqlDbType.VarChar, 45), new MySqlParameter("@pageNum", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 225), new MySqlParameter("@notice", MySqlDbType.VarChar, 45), new MySqlParameter("@ware", MySqlDbType.Decimal, 10), new MySqlParameter("@receive", MySqlDbType.VarChar, 45), new MySqlParameter("@FishMealId", MySqlDbType.VarChar, 50), new MySqlParameter("@Country", MySqlDbType.VarChar, 50), new MySqlParameter("@Brands", MySqlDbType.VarChar, 50) }; parameters [0].Value = model.seNumber; parameters [1].Value = model.code; parameters [2].Value = model.unit; parameters [3].Value = model.type; parameters [4].Value = model.shipName; parameters [5].Value = model.weight; parameters [6].Value = model.pileNum; parameters [7].Value = model.codeNum; parameters [8].Value = model.codeNumContract; parameters [9].Value = model.date; parameters [10].Value = model.waseHouse; parameters [11].Value = model.speci; parameters [12].Value = model.billName; parameters [13].Value = model.pageNum; parameters [14].Value = model.remark; parameters [15].Value = model.notice; parameters [16].Value = model.ware; parameters [17].Value = model.receive; parameters[18].Value = model.FishMealId; parameters[19].Value = model.Country; parameters[20].Value = model.Brands; int rows = MySqlHelper.ExecuteSql(strSql.ToString( ), parameters); if (rows > 0) { return(true); } else { return(false); } }