| | |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_PRODUCT SET IS_ENABLE=:IS_ENABLE where ID=:ID", OracleHelper.Connection, new OracleParameter(":IS_ENABLE", (object)isEnable), new OracleParameter(":ID", (object)id)) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //更新分配个性产品客户 |
|---|
| | | public bool UpdateClientIds(string clientIds, string id) |
|---|
| | | { |
|---|
| | | if (string.IsNullOrEmpty(id)) |
|---|
| | | return false; |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_PRODUCT SET CLIENT_IDS=:CLIENT_IDS where ID=:ID", OracleHelper.Connection, new OracleParameter(":CLIENT_IDS", (object)clientIds), new OracleParameter(":ID", (object)id)) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //更新关联的产品路径PATH |
|---|
| | | public bool UpdatePath(string id, string path) |
|---|
| | | { |
|---|
| | |
|---|
| | | o.CtExtParams = oracleReaderWrapper.GetString("CT_EXT_PARAMS", ""); |
|---|
| | | o.Price = oracleReaderWrapper.GetInt("PRICE", 0); |
|---|
| | | o.GivingNum = oracleReaderWrapper.GetInt("GIVING_NUM", 0); |
|---|
| | | o.ClientIds = oracleReaderWrapper.GetString("CLIENT_IDS", ""); |
|---|
| | | o.Remark = oracleReaderWrapper.GetString("REMARK", ""); |
|---|
| | | o.CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME"); |
|---|
| | | o.Creator = oracleReaderWrapper.GetString("CREATOR", ""); |
|---|
