public int InsertShipPay(ShipPayInfo oParam) { string sql = @"INSERT INTO ShipType_PayType_Un ( ShipTypeSysNo, PayTypeSysNo ) VALUES ( @ShipTypeSysNo, @PayTypeSysNo ); set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramShipTypeSysNo = new SqlParameter("@ShipTypeSysNo", SqlDbType.Int, 4); SqlParameter paramPayTypeSysNo = new SqlParameter("@PayTypeSysNo", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; paramShipTypeSysNo.Value = oParam.ShipTypeSysNo; paramPayTypeSysNo.Value = oParam.PayTypeSysNo; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramShipTypeSysNo); cmd.Parameters.Add(paramPayTypeSysNo); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
private void Map(ShipPayInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ShipTypeSysNo = Util.TrimIntNull(tempdr["ShipTypeSysNo"]); oParam.PayTypeSysNo = Util.TrimIntNull(tempdr["PayTypeSysNo"]); }
public void InitShipPayUn() { lock (shipPayLock) { shipPayHash.Clear(); string sql = "select * from shiptype_paytype_un"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return; foreach (DataRow dr in ds.Tables[0].Rows) { ShipPayInfo item = new ShipPayInfo(); Map(item, dr); shipPayHash.Add(item.SysNo, item); } } }
public int InsertShipPayUn(ShipPayInfo oParam) { string sql = "select * from shiptype_paytype_un where ShipTypeSysNo = " + oParam.ShipTypeSysNo + " and PayTypeSysNo = " + oParam.PayTypeSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("this shiptype_paytype_un record exists"); int result = new ASPDac().InsertShipPay(oParam); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP); if (shipPayHash == null) shipPayHash = new Hashtable(10); shipPayHash.Add(oParam.SysNo, oParam); return result; }
public void ImportShipPayUn() { if (!AppConfig.IsImportable) throw new BizException("Is Importable is false"); /* do not use the following code after Data Pour in */ string sql = @"select * from ShipType_PayType_Un"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) throw new BizException("the table ShipType_PayType_Un is not empty"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sql1 = @"select shiptype_convert.newsysno as ShipTypeSysNo, paytype_convert.newsysno as PayTypeSysNo from ipp2003..ship_pay as old, ippconvert..shiptype as shiptype_convert, ippconvert..paytype as paytype_convert where old.shiptypesysno = shiptype_convert.oldsysno and old.paytypesysno = paytype_convert.oldsysno"; DataSet ds1 = SqlHelper.ExecuteDataSet(sql1); foreach (DataRow dr1 in ds1.Tables[0].Rows) { ShipPayInfo oShipPay = new ShipPayInfo(); oShipPay.ShipTypeSysNo = Util.TrimIntNull(dr1["ShipTypeSysNo"]); oShipPay.PayTypeSysNo = Util.TrimIntNull(dr1["PayTypeSysNo"]); this.InsertShipPayUn(oShipPay); } scope.Complete(); } }