/// <summary>
/// 更新交易商品(根据2。0需求，只允许修改品种类型，其它字段不允许修改)
/// </summary>
/// <param name="model">交易商品实体</param>
/// <returns></returns>
public bool Update(ManagementCenter.Model.CM_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CM_Commodity set ");
//strSql.Append("CommodityName=@CommodityName,");
strSql.Append("BreedClassID=@BreedClassID,");
// strSql.Append("LabelCommodityCode=@LabelCommodityCode,");
//strSql.Append("GoerScale=@GoerScale,");
strSql.Append("MarketDate=@MarketDate,");
//strSql.Append("StockPinYin=@StockPinYin,");
//strSql.Append("turnovervolume=@turnovervolume,");
strSql.Append("IsExpired=@IsExpired,");
strSql.Append("ISSysDefaultCode=@ISSysDefaultCode");
strSql.Append(" where CommodityCode=@CommodityCode ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, model.CommodityCode);
//db.AddInParameter(dbCommand, "CommodityName", DbType.String, model.CommodityName);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
if (model.MarketDate == AppGlobalVariable.INIT_DATETIME)
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, model.MarketDate);
}
//db.AddInParameter(dbCommand, "StockPinYin", DbType.String, model.StockPinYin);
//db.AddInParameter(dbCommand, "turnovervolume", DbType.Double, model.turnovervolume);
if (model.IsExpired == AppGlobalVariable.INIT_INT)
{
model.IsExpired = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "IsExpired", DbType.Int32, model.IsExpired);
}
else
{
db.AddInParameter(dbCommand, "IsExpired", DbType.Int32, model.IsExpired);
}
if (model.ISSysDefaultCode == AppGlobalVariable.INIT_INT)
{
model.ISSysDefaultCode = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
else
{
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
db.ExecuteNonQuery(dbCommand);
return(true);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.CM_Commodity GetModel(string CommodityCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CommodityCode,CommodityName,BreedClassID,LabelCommodityCode,GoerScale,MarketDate,StockPinYin,turnovervolume,IsExpired,ISSysDefaultCode from CM_Commodity ");
strSql.Append(" where CommodityCode=@CommodityCode ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, CommodityCode);
ManagementCenter.Model.CM_Commodity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.CM_Commodity ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.CM_Commodity model = new ManagementCenter.Model.CM_Commodity();
object ojb;
model.CommodityCode = dataReader["CommodityCode"].ToString();
model.CommodityName = dataReader["CommodityName"].ToString();
model.StockPinYin = dataReader["StockPinYin"].ToString();
ojb = dataReader["BreedClassID"];
if (ojb != null && ojb != DBNull.Value)
{
model.BreedClassID = (int)ojb;
}
model.LabelCommodityCode = dataReader["LabelCommodityCode"].ToString();
ojb = dataReader["GoerScale"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoerScale = (decimal)ojb;
}
ojb = dataReader["MarketDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.MarketDate = (DateTime)ojb;
}
ojb = dataReader["turnovervolume"];
if (ojb != null && ojb != DBNull.Value)
{
model.turnovervolume = (double)ojb;
}
ojb = dataReader["IsExpired"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsExpired = (int)ojb;
}
ojb = dataReader["ISSysDefaultCode"];
if (ojb != null && ojb != DBNull.Value)
{
model.ISSysDefaultCode = (int)ojb;
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ManagementCenter.Model.CM_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CM_Commodity(");
strSql.Append("CommodityCode,CommodityName,BreedClassID,LabelCommodityCode,GoerScale,MarketDate,StockPinYin,turnovervolume,IsExpired,ISSysDefaultCode)");
strSql.Append(" values (");
strSql.Append("@CommodityCode,@CommodityName,@BreedClassID,@LabelCommodityCode,@GoerScale,@MarketDate,@StockPinYin,@turnovervolume,@IsExpired,@ISSysDefaultCode)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CommodityCode", DbType.String, model.CommodityCode);
db.AddInParameter(dbCommand, "CommodityName", DbType.String, model.CommodityName);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
if (string.IsNullOrEmpty(model.LabelCommodityCode) || model.LabelCommodityCode == AppGlobalVariable.INIT_STRING)
{
db.AddInParameter(dbCommand, "LabelCommodityCode", DbType.String, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "LabelCommodityCode", DbType.String, model.LabelCommodityCode);
}
if (model.GoerScale == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "GoerScale", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "GoerScale", DbType.Decimal, model.GoerScale);
}
if (model.MarketDate == AppGlobalVariable.INIT_DATETIME)
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, model.MarketDate);
}
db.AddInParameter(dbCommand, "StockPinYin", DbType.String, model.StockPinYin);
db.AddInParameter(dbCommand, "turnovervolume", DbType.Double, model.turnovervolume);
if (model.IsExpired == AppGlobalVariable.INIT_INT)
{
model.IsExpired = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "IsExpired", DbType.Int32, model.IsExpired);
}
else
{
db.AddInParameter(dbCommand, "IsExpired", DbType.Int32, model.IsExpired);
}
if (model.ISSysDefaultCode == AppGlobalVariable.INIT_INT)
{
model.ISSysDefaultCode = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
else
{
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
db.ExecuteNonQuery(dbCommand);
return(true);
}
