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