/// <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);
}
}
