///<sumary>
///修改
///</sumary>
/// <param name="DATA0002">model对象</param>
///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns>
public int Update(DATA0002 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DATA0002 set ");
strSql.Append("UNIT_CODE=@UNIT_CODE,");
strSql.Append("UNIT_NAME=@UNIT_NAME,");
strSql.Append("PROD=@PROD,");
strSql.Append("PURCH=@PURCH,");
strSql.Append("STOCK=@STOCK,");
strSql.Append("QUOTE=@QUOTE,");
strSql.Append("SELL=@SELL,");
strSql.Append("UNIT_BASE=@UNIT_BASE,");
strSql.Append("DERIVED=@DERIVED,");
strSql.Append("INT_CHECK=@INT_CHECK,");
strSql.Append("EXPRESSION=@EXPRESSION,");
strSql.Append("MIN_UNIT_VALUE=@MIN_UNIT_VALUE,");
strSql.Append("MAX_UNIT_VALUE=@MAX_UNIT_VALUE,");
strSql.Append("UNIT_TYPE=@UNIT_TYPE,");
strSql.Append("POT_OUTER_LAYER=@POT_OUTER_LAYER,");
strSql.Append("POT_INNER_LAYER=@POT_INNER_LAYER,");
strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,");
strSql.Append("ECN_FLAG=@ECN_FLAG");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Decimal, 9),
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5),
new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@PROD", SqlDbType.Char, 1),
new SqlParameter("@PURCH", SqlDbType.Char, 1),
new SqlParameter("@STOCK", SqlDbType.Char, 1),
new SqlParameter("@QUOTE", SqlDbType.Char, 1),
new SqlParameter("@SELL", SqlDbType.Char, 1),
new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1),
new SqlParameter("@DERIVED", SqlDbType.Char, 1),
new SqlParameter("@INT_CHECK", SqlDbType.Char, 1),
new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50),
new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1),
new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9),
new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.RKEY;
parameters[1].Value = model.UNIT_CODE;
parameters[2].Value = model.UNIT_NAME;
parameters[3].Value = model.PROD;
parameters[4].Value = model.PURCH;
parameters[5].Value = model.STOCK;
parameters[6].Value = model.QUOTE;
parameters[7].Value = model.SELL;
parameters[8].Value = model.UNIT_BASE;
parameters[9].Value = model.DERIVED;
parameters[10].Value = model.INT_CHECK;
parameters[11].Value = model.EXPRESSION;
parameters[12].Value = model.MIN_UNIT_VALUE;
parameters[13].Value = model.MAX_UNIT_VALUE;
parameters[14].Value = model.UNIT_TYPE;
parameters[15].Value = model.POT_OUTER_LAYER;
parameters[16].Value = model.POT_INNER_LAYER;
parameters[17].Value = model.ACTIVE_FLAG;
parameters[18].Value = model.ECN_FLAG;
return(dbHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
