string prepareDelete(DbOperator dbOperator, Bunk value) { dbOperator.AddParameter("DELETEBUNKID", value.Id); return("DELETE FROM [T_ExtendedBunk] WHERE [BUNKID]=@DELETEBUNKID;DELETE FROM [T_Bunk] WHERE [ID]=@DELETEBUNKID;"); }
public int Save(CompanyUpgrade companyUpgrade) { string sql = @"IF EXISTS(SELECT NULL FROM [dbo].[T_CompanyUpgradeApplication ] WHERE Company =@Company) UPDATE [dbo].[T_CompanyUpgradeApplication] SET [UserNo] = @UserNo,[Name] = @Name,[AbbreviateName] = @AbbreviateName,[OrginationCode] = @OrginationCode, [OfficePhones] = @OfficePhones,[ManagerName] = @ManagerName,[ManagerPhone] = @ManagerPhone,[EmergencyName] = @EmergencyName,[EmergencyPhone] = @EmergencyPhone, [Type] = @Type,[AccountType] = @AccountType,[Audited] =@Audited,[AuditTime]=@AuditTime,[ApplyTime] = @ApplyTime WHERE [Company] = @Company ELSE INSERT INTO [B3B].[dbo].[T_CompanyUpgradeApplication ]([Company],[UserNo],[Name],[AbbreviateName],[OrginationCode], [OfficePhones],[ManagerName],[ManagerPhone],[EmergencyName] ,[EmergencyPhone],[Type],[AccountType],[Audited],[AuditTime],[ApplyTime]) VALUES(@Company,@UserNo,@Name,@AbbreviateName,@OrginationCode,@OfficePhones,@ManagerName,@ManagerPhone,@EmergencyName,@EmergencyPhone, @Type,@AccountType,@Audited,@AuditTime,@ApplyTime)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", companyUpgrade.Company); dbOperator.AddParameter("UserNo", companyUpgrade.UserNo); if (string.IsNullOrWhiteSpace(companyUpgrade.Name)) { dbOperator.AddParameter("Name", DBNull.Value); } else { dbOperator.AddParameter("Name", companyUpgrade.Name); } if (string.IsNullOrWhiteSpace(companyUpgrade.AbbreviateName)) { dbOperator.AddParameter("AbbreviateName", DBNull.Value); } else { dbOperator.AddParameter("AbbreviateName", companyUpgrade.AbbreviateName); } if (string.IsNullOrWhiteSpace(companyUpgrade.OrginationCode)) { dbOperator.AddParameter("OrginationCode", DBNull.Value); } else { dbOperator.AddParameter("OrginationCode", companyUpgrade.OrginationCode); } if (string.IsNullOrWhiteSpace(companyUpgrade.OfficePhones)) { dbOperator.AddParameter("OfficePhones", DBNull.Value); } else { dbOperator.AddParameter("OfficePhones", companyUpgrade.OfficePhones); } if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerName)) { dbOperator.AddParameter("ManagerName", DBNull.Value); } else { dbOperator.AddParameter("ManagerName", companyUpgrade.ManagerName); } if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerPhone)) { dbOperator.AddParameter("ManagerPhone", DBNull.Value); } else { dbOperator.AddParameter("ManagerPhone", companyUpgrade.ManagerPhone); } if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyName)) { dbOperator.AddParameter("EmergencyName", DBNull.Value); } else { dbOperator.AddParameter("EmergencyName", companyUpgrade.EmergencyName); } if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyPhone)) { dbOperator.AddParameter("EmergencyPhone", DBNull.Value); } else { dbOperator.AddParameter("EmergencyPhone", companyUpgrade.EmergencyPhone); } dbOperator.AddParameter("Type", (int)companyUpgrade.Type); dbOperator.AddParameter("AccountType", (int)companyUpgrade.AccountType); dbOperator.AddParameter("Audited", companyUpgrade.Audited); if (companyUpgrade.AuditTime.HasValue) { dbOperator.AddParameter("AuditTime", companyUpgrade.AuditTime); } else { dbOperator.AddParameter("AuditTime", DBNull.Value); } dbOperator.AddParameter("ApplyTime", companyUpgrade.ApplyTime); return(dbOperator.ExecuteNonQuery(sql)); } }
public IEnumerable <DataTransferObject.Organization.CompanyAuditInfo> QueryNeedAuditCompanies(CompanyAuditQueryCondition condition, Pagination pagination) { var result = new List <DataTransferObject.Organization.CompanyAuditInfo>(); using (var dbOperator = new DbOperator(Provider, ConnectionString)) { if (!string.IsNullOrWhiteSpace(condition.UserNo)) { dbOperator.AddParameter("@i_UserNo", condition.UserNo); } if (condition.CompanyType.HasValue) { dbOperator.AddParameter("@i_CompanyType", (byte)condition.CompanyType); } if (condition.AccountType.HasValue) { dbOperator.AddParameter("@i_AccountType", (byte)condition.AccountType); } if (condition.ApplyTimeStart.HasValue) { dbOperator.AddParameter("@i_ApplyTimeStart", condition.ApplyTimeStart); } if (condition.ApplyTimeEnd.HasValue) { dbOperator.AddParameter("@i_ApplyTimeEnd", condition.ApplyTimeEnd); } if (!string.IsNullOrWhiteSpace(condition.CompanyName)) { dbOperator.AddParameter("@i_CompanyName", condition.CompanyName); } if (!string.IsNullOrWhiteSpace(condition.AuditType)) { dbOperator.AddParameter("@i_AuditType", condition.AuditType); } if (!string.IsNullOrWhiteSpace(condition.SourceType)) { dbOperator.AddParameter("@i_SourceType", condition.SourceType); } dbOperator.AddParameter("@i_Pagesize", pagination.PageSize); dbOperator.AddParameter("@i_PageIndex", pagination.PageIndex); var totalCount = dbOperator.AddParameter("@o_RowCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = dbOperator.ExecuteReader("dbo.P_CompanyAuditPagination", System.Data.CommandType.StoredProcedure)) { while (reader.Read()) { result.Add(new CompanyAuditInfo() { CompanyId = reader.GetGuid(0), UserNo = reader.GetString(1), AbbreviateName = reader.GetString(2), CompanyType = (CompanyType)reader.GetByte(3), AccountType = (AccountBaseType)reader.GetByte(4), ApplyTime = reader.GetDateTime(5), AuditType = reader.GetString(6), SourceType = reader.GetString(7), SpreadId = reader.GetGuid(8) }); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } } return(result); }
public bool AddWXInfo(WX_Info model, DbOperator dbOperator) { string strsql = "insert into WX_Info(OpenID,AccountID,UserType,FollowState,NickName,Language,Province,City,Country,Sex,Headimgurl,SubscribeTimes,LastSubscribeDate,LastUnsubscribeDate,LastVisitDate,CompanyID)"; strsql += "values(@OpenID,@AccountID,@UserType,@FollowState,@NickName,@Language,@Province,@City,@Country,@Sex,@Headimgurl,@SubscribeTimes,@LastSubscribeDate,@LastUnsubscribeDate,@LastVisitDate,@CompanyID)"; dbOperator.ClearParameters(); dbOperator.AddParameter("OpenID", model.OpenID); dbOperator.AddParameter("AccountID", model.AccountID); dbOperator.AddParameter("UserType", model.UserType); dbOperator.AddParameter("FollowState", 1); dbOperator.AddParameter("NickName", model.NickName); dbOperator.AddParameter("Language", model.Language); dbOperator.AddParameter("Province", model.Province); dbOperator.AddParameter("City", model.City); dbOperator.AddParameter("Country", model.Country); dbOperator.AddParameter("Sex", model.Sex); dbOperator.AddParameter("Headimgurl", model.Headimgurl); dbOperator.AddParameter("SubscribeTimes", 1); dbOperator.AddParameter("LastSubscribeDate", DateTime.Now); dbOperator.AddParameter("LastUnsubscribeDate", DateTime.Now); dbOperator.AddParameter("LastVisitDate", DateTime.Now); dbOperator.AddParameter("CompanyID", model.CompanyID); return(dbOperator.ExecuteNonQuery(strsql) > 0); }
public bool Update(BaseCard model, DbOperator dbOperator) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append(@"update BaseCard set Balance=@Balance,CardNo=@CardNo, CardNumb=@CardNumb,CardSystem=@CardSystem,CardType=@CardType, Deposit=@Deposit,EmployeeID=@EmployeeID,HaveUpdate=@HaveUpdate,LastUpdateTime=@LastUpdateTime, OperatorID=@OperatorID,RegisterTime=@RegisterTime,State=@State,VID=@VID"); strSql.Append(" where CardID=@CardID"); dbOperator.ClearParameters(); dbOperator.AddParameter("CardID", model.CardID); dbOperator.AddParameter("Balance", model.Balance); dbOperator.AddParameter("CardNo", model.CardNo); dbOperator.AddParameter("CardNumb", model.CardNumb); dbOperator.AddParameter("CardSystem", (int)model.CardSystem); dbOperator.AddParameter("CardType", (int)model.CardType); dbOperator.AddParameter("Deposit", model.Deposit); dbOperator.AddParameter("EmployeeID", model.EmployeeID); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("OperatorID", model.OperatorID); dbOperator.AddParameter("RegisterTime", model.RegisterTime); dbOperator.AddParameter("State", (int)model.State); dbOperator.AddParameter("VID", model.VID); return dbOperator.ExecuteNonQuery(strSql.ToString()) > 0; }
public IEnumerable <DataTransferObject.Foundation.BasicPriceView> QueryBasicPrice(string airline, string departure, string arrival, Core.Pagination pagination) { IList <DataTransferObject.Foundation.BasicPriceView> result = new List <DataTransferObject.Foundation.BasicPriceView>(); string fields = "[Id],[Airline],[Departure],[Arrival],[FlightDate],[ETDZDate],[Price],[Mileage],ModifyTime"; string catelog = "[dbo].[T_BasicPrice]"; string orderbyFiled = "[Airline] DESC,[FlightDate] DESC,[Departure],[Arrival],ModifyTime desc"; string where = ""; if (!string.IsNullOrWhiteSpace(airline)) { where += "([Airline] IS NULL OR [Airline] = '" + airline + "') AND "; } if (!string.IsNullOrWhiteSpace(departure) || !string.IsNullOrWhiteSpace(arrival)) { if (!string.IsNullOrWhiteSpace(departure) && string.IsNullOrWhiteSpace(arrival)) { where += "([Departure] = '" + departure + "' OR [Arrival] = '" + departure + "') AND "; } if (!string.IsNullOrWhiteSpace(arrival) && string.IsNullOrWhiteSpace(departure)) { where += "([Departure] = '" + arrival + "' OR [Arrival] = '" + arrival + "') AND "; } if (!string.IsNullOrWhiteSpace(arrival) && !string.IsNullOrWhiteSpace(departure)) { where += "(([Departure] = '" + arrival + "' AND [Arrival] = '" + departure + "') OR ([Departure] = '" + departure + "' AND [Arrival] = '" + arrival + "')) AND "; } } if (where.Length > 0) { where = where.Remove(where.Length - 5, 5); } using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("@iField", fields); dbOperator.AddParameter("@iCatelog", catelog); dbOperator.AddParameter("@iCondition", where); dbOperator.AddParameter("@iOrderBy", orderbyFiled); dbOperator.AddParameter("@iPagesize", pagination.PageSize); dbOperator.AddParameter("@iPageIndex", pagination.PageIndex); dbOperator.AddParameter("@iGetCount", pagination.GetRowCount); System.Data.Common.DbParameter totalCount = dbOperator.AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (System.Data.Common.DbDataReader reader = dbOperator.ExecuteReader("dbo.P_Pagination", System.Data.CommandType.StoredProcedure)) { while (reader.Read()) { DataTransferObject.Foundation.BasicPriceView basicPriceView = new DataTransferObject.Foundation.BasicPriceView(); basicPriceView.Id = reader.GetGuid(0); basicPriceView.Airline = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); basicPriceView.Departure = reader.GetString(2); basicPriceView.Arrival = reader.GetString(3); basicPriceView.FlightDate = reader.GetDateTime(4); basicPriceView.ETDZDate = reader.GetDateTime(5); basicPriceView.Price = reader.GetDecimal(6); basicPriceView.Mileage = reader.GetDecimal(7); basicPriceView.ModifyTime = reader.IsDBNull(8) ? new DateTime(2013, 10, 26, 0, 0, 0) : reader.GetDateTime(8); result.Add(basicPriceView); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } } return(result); }
public bool Add(List <ParkCarModel> models, DbOperator dbOperator) { dbOperator.ClearParameters(); if (models == null || models.Count == 0) { return(false); } StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO ParkCarModel(CarModelID,CarModelName,PKID,IsDefault,LastUpdateTime,HaveUpdate,DataStatus,MaxUseMoney,IsNaturalDay,PlateColor,DayMaxMoney,NightMaxMoney,DayStartTime,DayEndTime,NightStartTime,NightEndTime)"); bool hasData = false; int index = 1; foreach (var p in models) { p.DataStatus = DataStatus.Normal; p.LastUpdateTime = DateTime.Now; p.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; strSql.AppendFormat(" SELECT @CarModelID{0},@CarModelName{0},@PKID{0},@IsDefault{0},@LastUpdateTime{0},@HaveUpdate{0},@DataStatus{0},@MaxUseMoney{0},@IsNaturalDay{0},@PlateColor{0},@DayMaxMoney{0},@NightMaxMoney{0},@DayStartTime{0},@DayEndTime{0},@NightStartTime{0},@NightEndTime{0} UNION ALL", index); dbOperator.AddParameter("CarModelID" + index, p.CarModelID); dbOperator.AddParameter("CarModelName" + index, p.CarModelName); dbOperator.AddParameter("PKID" + index, p.PKID); dbOperator.AddParameter("IsDefault" + index, (int)p.IsDefault); dbOperator.AddParameter("LastUpdateTime" + index, p.LastUpdateTime); dbOperator.AddParameter("HaveUpdate" + index, p.HaveUpdate); dbOperator.AddParameter("DataStatus" + index, (int)p.DataStatus); dbOperator.AddParameter("MaxUseMoney" + index, p.MaxUseMoney); dbOperator.AddParameter("IsNaturalDay" + index, p.IsNaturalDay); dbOperator.AddParameter("PlateColor" + index, p.PlateColor); dbOperator.AddParameter("DayMaxMoney" + index, p.DayMaxMoney); dbOperator.AddParameter("NightMaxMoney" + index, p.NightMaxMoney); dbOperator.AddParameter("DayStartTime" + index, p.DayStartTime); dbOperator.AddParameter("DayEndTime" + index, p.DayEndTime); dbOperator.AddParameter("NightStartTime" + index, p.NightStartTime); dbOperator.AddParameter("NightEndTime" + index, p.NightEndTime); hasData = true; index++; } if (hasData) { return(dbOperator.ExecuteNonQuery(strSql.Remove(strSql.Length - 10, 10).ToString()) > 0); } return(false); }
public bool Update(BaseParkinfo model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update BaseParkinfo set PKNo=@PKNo,PKName=@PKName"); strSql.Append(",CenterTime=@CenterTime,AllowLoseDisplay=@AllowLoseDisplay,LinkMan=@LinkMan,Mobile=@Mobile,Address=@Address,Coordinate=@Coordinate,MobilePay=@MobilePay"); strSql.Append(",MobileLock=@MobileLock,IsParkingSpace=@IsParkingSpace,IsReverseSeekingVehicle=@IsReverseSeekingVehicle,FeeRemark=@FeeRemark,OnLine=@OnLine,Remark=@Remark"); strSql.Append(",LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,CityID=@CityID,VID=@VID,DataSaveDays=@DataSaveDays,PictureSaveDays=@PictureSaveDays,PoliceFree=@PoliceFree"); strSql.Append(",IsOnLineGathe=@IsOnLineGathe,IsLine=@IsLine,NeedFee=@NeedFee,ExpiredAdvanceRemindDay=@ExpiredAdvanceRemindDay,DefaultPlate=@DefaultPlate,SpaceBitNum=@SpaceBitNum"); strSql.Append(",CarBitNumFixed=@CarBitNumFixed,CarBitNumLeft=@CarBitNumLeft,OnlineDiscount=@OnlineDiscount,IsOnlineDiscount=@IsOnlineDiscount,UnconfirmedCalculation=@UnconfirmedCalculation,IsNoPlateConfirm=@IsNoPlateConfirm,SupportAutoRefund=@SupportAutoRefund,OuterringCharge=@OuterringCharge,SupportNoSense=@SupportNoSense where PKID=@PKID"); dbOperator.ClearParameters(); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("PKNo", model.PKNo); dbOperator.AddParameter("PKName", model.PKName); dbOperator.AddParameter("CenterTime", model.CenterTime); dbOperator.AddParameter("AllowLoseDisplay", (int)model.AllowLoseDisplay); dbOperator.AddParameter("LinkMan", model.LinkMan); dbOperator.AddParameter("Mobile", model.Mobile); dbOperator.AddParameter("Address", model.Address); dbOperator.AddParameter("Coordinate", model.Coordinate); dbOperator.AddParameter("MobilePay", (int)model.MobilePay); dbOperator.AddParameter("MobileLock", (int)model.MobileLock); dbOperator.AddParameter("IsParkingSpace", (int)model.IsParkingSpace); dbOperator.AddParameter("IsReverseSeekingVehicle", (int)model.IsReverseSeekingVehicle); dbOperator.AddParameter("FeeRemark", model.FeeRemark); dbOperator.AddParameter("OnLine", (int)model.OnLine); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("CityID", model.CityID); dbOperator.AddParameter("VID", model.VID); dbOperator.AddParameter("DataSaveDays", model.DataSaveDays); dbOperator.AddParameter("PictureSaveDays", model.PictureSaveDays); dbOperator.AddParameter("IsOnLineGathe", (int)model.IsOnLineGathe); dbOperator.AddParameter("IsLine", (int)model.IsLine); dbOperator.AddParameter("NeedFee", (int)model.NeedFee); dbOperator.AddParameter("ExpiredAdvanceRemindDay", model.ExpiredAdvanceRemindDay); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DefaultPlate", model.DefaultPlate); dbOperator.AddParameter("SpaceBitNum", model.SpaceBitNum); dbOperator.AddParameter("CarBitNumFixed", model.CarBitNumFixed); dbOperator.AddParameter("CarBitNumLeft", model.CarBitNumLeft); dbOperator.AddParameter("PoliceFree", model.PoliceFree); dbOperator.AddParameter("OnlineDiscount", model.OnlineDiscount); dbOperator.AddParameter("IsOnlineDiscount", model.IsOnlineDiscount); dbOperator.AddParameter("UnconfirmedCalculation", model.UnconfirmedCalculation); dbOperator.AddParameter("IsNoPlateConfirm", model.IsNoPlateConfirm); dbOperator.AddParameter("SupportAutoRefund", model.SupportAutoRefund); dbOperator.AddParameter("OuterringCharge", model.OuterringCharge); dbOperator.AddParameter("SupportNoSense", model.SupportNoSense); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool ModifyOrderStatusAndAmount(string recordID, decimal amount, decimal payAmount, decimal unPayamount, int status, decimal Discountamount, string Carderateid, int payWay, out string ErrorMessage) { ErrorMessage = ""; try { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { string strSql = ""; strSql = @"update ParkOrder set Carderateid=@Carderateid,Discountamount=@Discountamount,Amount=@Amount,Status=@Status,HaveUpdate=@HaveUpdate,PayAmount=@PayAmount,UnPayamount=@UnPayamount,LastUpdateTime=@LastUpdateTime,PayWay=@PayWay where RecordID=@RecordID"; dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", recordID); dbOperator.AddParameter("Discountamount", Discountamount); dbOperator.AddParameter("Carderateid", Carderateid); dbOperator.AddParameter("Amount", amount); dbOperator.AddParameter("Status", status); dbOperator.AddParameter("PayAmount", payAmount); dbOperator.AddParameter("UnPayamount", unPayamount); dbOperator.AddParameter("PayWay", payWay); dbOperator.AddParameter("HaveUpdate", 1); dbOperator.AddParameter("LastUpdateTime", DateTime.Now); dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } } catch (Exception e) { ErrorMessage = e.Message; } return(false); }
public bool Add(List <ParkCarType> models, DbOperator dbOperator) { dbOperator.ClearParameters(); if (models == null || models.Count == 0) { return(false); } StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO ParkCarType(CarTypeID,CarTypeName,PKID,BaseTypeID,RepeatIn,RepeatOut"); strSql.Append(",AffirmIn,AffirmOut,InBeginTime,InEdnTime,MaxUseMoney,AllowLose,LpDistinguish,InOutEditCar"); strSql.Append(",InOutTime,CarNoLike,LastUpdateTime,HaveUpdate,IsAllowOnlIne,Amount,MaxMonth,MaxValue,DataStatus"); strSql.Append(",OverdueToTemp,LotOccupy,Deposit,MonthCardExpiredEnterDay,AffirmBegin,AffirmEnd,IsNeedCapturePaper,IsNeedAuthentication,IsDispatch,OnlineUnit,IsIgnoreHZ)"); bool hasData = false; int index = 1; foreach (var p in models) { p.DataStatus = DataStatus.Normal; p.LastUpdateTime = DateTime.Now; p.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; strSql.AppendFormat(" SELECT @CarTypeID{0},@CarTypeName{0},@PKID{0},@BaseTypeID{0},@RepeatIn{0},@RepeatOut{0}", index); strSql.AppendFormat(",@AffirmIn{0},@AffirmOut{0},@InBeginTime{0},@InEdnTime{0},@MaxUseMoney{0},@AllowLose{0},@LpDistinguish{0},@InOutEditCar{0}", index); strSql.AppendFormat(",@InOutTime{0},@CarNoLike{0},@LastUpdateTime{0},@HaveUpdate{0},@IsAllowOnlIne{0},@Amount{0},@MaxMonth{0},@MaxValue{0},@DataStatus{0}", index); strSql.AppendFormat(",@OverdueToTemp{0},@LotOccupy{0},@Deposit{0},@MonthCardExpiredEnterDay{0},@AffirmBegin{0},@AffirmEnd{0},@IsNeedCapturePaper{0},@IsNeedAuthentication{0},@IsDispatch{0},@OnlineUnit{0},@IsIgnoreHZ{0} UNION ALL", index); dbOperator.AddParameter("CarTypeID" + index, p.CarTypeID); dbOperator.AddParameter("CarTypeName" + index, p.CarTypeName); dbOperator.AddParameter("PKID" + index, p.PKID); dbOperator.AddParameter("BaseTypeID" + index, (int)p.BaseTypeID); dbOperator.AddParameter("RepeatIn" + index, (int)p.RepeatIn); dbOperator.AddParameter("RepeatOut" + index, (int)p.RepeatOut); dbOperator.AddParameter("AffirmIn" + index, (int)p.AffirmIn); dbOperator.AddParameter("AffirmOut" + index, (int)p.AffirmOut); dbOperator.AddParameter("InBeginTime" + index, p.InBeginTime); dbOperator.AddParameter("InEdnTime" + index, p.InEdnTime); dbOperator.AddParameter("MaxUseMoney" + index, p.MaxUseMoney); dbOperator.AddParameter("AllowLose" + index, (int)p.AllowLose); dbOperator.AddParameter("LpDistinguish" + index, (int)p.LpDistinguish); dbOperator.AddParameter("InOutEditCar" + index, (int)p.InOutEditCar); dbOperator.AddParameter("InOutTime" + index, p.InOutTime); dbOperator.AddParameter("CarNoLike" + index, (int)p.CarNoLike); dbOperator.AddParameter("LastUpdateTime" + index, p.LastUpdateTime); dbOperator.AddParameter("HaveUpdate" + index, p.HaveUpdate); dbOperator.AddParameter("IsAllowOnlIne" + index, (int)p.IsAllowOnlIne); dbOperator.AddParameter("Amount" + index, p.Amount); dbOperator.AddParameter("MaxMonth" + index, p.MaxMonth); dbOperator.AddParameter("MaxValue" + index, p.MaxValue); dbOperator.AddParameter("DataStatus" + index, (int)p.DataStatus); dbOperator.AddParameter("OverdueToTemp" + index, (int)p.OverdueToTemp); dbOperator.AddParameter("LotOccupy" + index, (int)p.LotOccupy); dbOperator.AddParameter("Deposit" + index, p.Deposit); dbOperator.AddParameter("MonthCardExpiredEnterDay" + index, p.MonthCardExpiredEnterDay); dbOperator.AddParameter("AffirmBegin" + index, p.AffirmBegin); dbOperator.AddParameter("AffirmEnd" + index, p.AffirmEnd); dbOperator.AddParameter("IsNeedCapturePaper" + index, p.IsNeedCapturePaper); dbOperator.AddParameter("IsNeedAuthentication" + index, p.IsNeedAuthentication); dbOperator.AddParameter("IsDispatch" + index, p.IsDispatch); dbOperator.AddParameter("OnlineUnit" + index, p.OnlineUnit); dbOperator.AddParameter("IsIgnoreHZ" + index, p.IsIgnoreHZ); hasData = true; index++; } if (hasData) { return(dbOperator.ExecuteNonQuery(strSql.Remove(strSql.Length - 10, 10).ToString()) > 0); } return(false); }
public bool Add(BaseParkinfo model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BaseParkinfo(PKID,PKNo,PKName,CarBitNum,CarBitNumLeft,CarBitNumFixed,SpaceBitNum"); strSql.Append(",CenterTime,AllowLoseDisplay,LinkMan,Mobile,Address,Coordinate,MobilePay"); strSql.Append(",MobileLock,IsParkingSpace,IsReverseSeekingVehicle,FeeRemark,OnLine,Remark"); strSql.Append(",LastUpdateTime,HaveUpdate,CityID,VID,DataStatus,DataSaveDays,PictureSaveDays,IsOnLineGathe,IsLine,NeedFee,ExpiredAdvanceRemindDay,DefaultPlate,PoliceFree,UnconfirmedCalculation,IsNoPlateConfirm,SupportAutoRefund,OuterringCharge,SupportNoSense)"); strSql.Append(" values(@PKID,@PKNo,@PKName,@CarBitNum,@CarBitNumLeft,@CarBitNumFixed,@SpaceBitNum"); strSql.Append(",@CenterTime,@AllowLoseDisplay,@LinkMan,@Mobile,@Address,@Coordinate,@MobilePay"); strSql.Append(",@MobileLock,@IsParkingSpace,@IsReverseSeekingVehicle,@FeeRemark,@OnLine,@Remark"); strSql.Append(",@LastUpdateTime,@HaveUpdate,@CityID,@VID,@DataStatus,@DataSaveDays,@PictureSaveDays"); strSql.Append(",@IsOnLineGathe,@IsLine,@NeedFee,@ExpiredAdvanceRemindDay,@DefaultPlate,@PoliceFree,@UnconfirmedCalculation,@IsNoPlateConfirm,@SupportAutoRefund,@OuterringCharge,@SupportNoSense)"); dbOperator.ClearParameters(); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("PKNo", model.PKNo); dbOperator.AddParameter("PKName", model.PKName); dbOperator.AddParameter("CarBitNum", model.CarBitNum); dbOperator.AddParameter("CarBitNumLeft", model.CarBitNumLeft); dbOperator.AddParameter("CarBitNumFixed", model.CarBitNumFixed); dbOperator.AddParameter("SpaceBitNum", model.SpaceBitNum); dbOperator.AddParameter("CenterTime", model.CenterTime); dbOperator.AddParameter("AllowLoseDisplay", (int)model.AllowLoseDisplay); dbOperator.AddParameter("LinkMan", model.LinkMan); dbOperator.AddParameter("Mobile", model.Mobile); dbOperator.AddParameter("Address", model.Address); dbOperator.AddParameter("Coordinate", model.Coordinate); dbOperator.AddParameter("MobilePay", (int)model.MobilePay); dbOperator.AddParameter("MobileLock", (int)model.MobileLock); dbOperator.AddParameter("IsParkingSpace", (int)model.IsParkingSpace); dbOperator.AddParameter("IsReverseSeekingVehicle", (int)model.IsReverseSeekingVehicle); dbOperator.AddParameter("FeeRemark", model.FeeRemark); dbOperator.AddParameter("OnLine", (int)model.OnLine); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("CityID", model.CityID); dbOperator.AddParameter("VID", model.VID); dbOperator.AddParameter("DataSaveDays", model.DataSaveDays); dbOperator.AddParameter("PictureSaveDays", model.PictureSaveDays); dbOperator.AddParameter("IsOnLineGathe", (int)model.IsOnLineGathe); dbOperator.AddParameter("IsLine", (int)model.IsLine); dbOperator.AddParameter("NeedFee", (int)model.NeedFee); dbOperator.AddParameter("ExpiredAdvanceRemindDay", model.ExpiredAdvanceRemindDay); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("DefaultPlate", model.DefaultPlate); dbOperator.AddParameter("PoliceFree", model.PoliceFree); dbOperator.AddParameter("UnconfirmedCalculation", model.UnconfirmedCalculation); dbOperator.AddParameter("IsNoPlateConfirm", model.IsNoPlateConfirm); dbOperator.AddParameter("SupportAutoRefund", model.SupportAutoRefund); dbOperator.AddParameter("OuterringCharge", model.OuterringCharge); dbOperator.AddParameter("SupportNoSense", model.SupportNoSense); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool Update(ParkCarType model) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkCarType set CarTypeName=@CarTypeName,PKID=@PKID,BaseTypeID=@BaseTypeID,RepeatIn=@RepeatIn,RepeatOut"); strSql.Append("=@RepeatOut,AffirmIn=@AffirmIn,AffirmOut=@AffirmOut,InBeginTime=@InBeginTime,InEdnTime=@InEdnTime,MaxUseMoney=@MaxUseMoney,AllowLose=@AllowLose,LpDistinguish=@LpDistinguish,InOutEditCar"); strSql.Append("=@InOutEditCar,InOutTime=@InOutTime,CarNoLike=@CarNoLike,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,IsAllowOnlIne=@IsAllowOnlIne,Amount=@Amount,MaxMonth=@MaxMonth,MaxValue=@MaxValue"); strSql.Append(",OverdueToTemp=@OverdueToTemp,LotOccupy=@LotOccupy,Deposit=@Deposit,MonthCardExpiredEnterDay=@MonthCardExpiredEnterDay,AffirmBegin=@AffirmBegin,AffirmEnd=@AffirmEnd,IsNeedCapturePaper=@IsNeedCapturePaper,IsNeedAuthentication=@IsNeedAuthentication,IsDispatch=@IsDispatch,OnlineUnit=@OnlineUnit"); strSql.Append(",IsIgnoreHZ=@IsIgnoreHZ where CarTypeID=@CarTypeID"); using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { dbOperator.ClearParameters(); dbOperator.AddParameter("CarTypeID", model.CarTypeID); dbOperator.AddParameter("CarTypeName", model.CarTypeName); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("BaseTypeID", (int)model.BaseTypeID); dbOperator.AddParameter("RepeatIn", (int)model.RepeatIn); dbOperator.AddParameter("RepeatOut", (int)model.RepeatOut); dbOperator.AddParameter("AffirmIn", (int)model.AffirmIn); dbOperator.AddParameter("AffirmOut", (int)model.AffirmOut); dbOperator.AddParameter("InBeginTime", model.InBeginTime); dbOperator.AddParameter("InEdnTime", model.InEdnTime); dbOperator.AddParameter("MaxUseMoney", model.MaxUseMoney); dbOperator.AddParameter("AllowLose", (int)model.AllowLose); dbOperator.AddParameter("LpDistinguish", (int)model.LpDistinguish); dbOperator.AddParameter("InOutEditCar", (int)model.InOutEditCar); dbOperator.AddParameter("InOutTime", model.InOutTime); dbOperator.AddParameter("CarNoLike", (int)model.CarNoLike); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("IsAllowOnlIne", (int)model.IsAllowOnlIne); dbOperator.AddParameter("Amount", model.Amount); dbOperator.AddParameter("MaxMonth", model.MaxMonth); dbOperator.AddParameter("MaxValue", model.MaxValue); dbOperator.AddParameter("OverdueToTemp", (int)model.OverdueToTemp); dbOperator.AddParameter("LotOccupy", (int)model.LotOccupy); dbOperator.AddParameter("Deposit", model.Deposit); dbOperator.AddParameter("MonthCardExpiredEnterDay", model.MonthCardExpiredEnterDay); dbOperator.AddParameter("AffirmBegin", model.AffirmBegin); dbOperator.AddParameter("AffirmEnd", model.AffirmEnd); dbOperator.AddParameter("IsNeedCapturePaper", model.IsNeedCapturePaper); dbOperator.AddParameter("IsNeedAuthentication", model.IsNeedAuthentication); dbOperator.AddParameter("IsDispatch", model.IsDispatch); dbOperator.AddParameter("OnlineUnit", model.OnlineUnit); dbOperator.AddParameter("IsIgnoreHZ", model.IsIgnoreHZ); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public IEnumerable <Bunk> QueryBunkListView(DataTransferObject.Foundation.BunkQueryCondition condition, Core.Pagination pagination) { var result = new List <Bunk>(); using (var dbOperator = new DbOperator(Provider, ConnectionString)) { if (!string.IsNullOrWhiteSpace(condition.Airline)) { dbOperator.AddParameter("@iAirline", condition.Airline.Trim()); } if (!string.IsNullOrWhiteSpace(condition.Departure)) { dbOperator.AddParameter("@iDeparture", condition.Departure.Trim()); } if (!string.IsNullOrWhiteSpace(condition.Arrival)) { dbOperator.AddParameter("@iArrival", condition.Arrival.Trim()); } if (!string.IsNullOrWhiteSpace(condition.BunkCode)) { dbOperator.AddParameter("@iBunkCode", condition.BunkCode.Trim()); } if (condition.BunkType.HasValue) { dbOperator.AddParameter("@iBunkType", (int)condition.BunkType); } if (condition.VoyageType.HasValue) { dbOperator.AddParameter("@iVoyageType", (byte)condition.VoyageType); } if (condition.FlightBeginDate.HasValue) { dbOperator.AddParameter("@iFlightBeginDate", condition.FlightBeginDate.Value.Date); } if (condition.FlightEndDate.HasValue) { dbOperator.AddParameter("@iFlightEndDate", condition.FlightEndDate.Value.Date); } if (condition.Status.HasValue) { dbOperator.AddParameter("@iStatus", condition.Status); } if (pagination != null) { dbOperator.AddParameter("@iPageSize", pagination.PageSize); dbOperator.AddParameter("@iPageIndex", pagination.PageIndex); } System.Data.Common.DbParameter totalCount = dbOperator.AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (System.Data.Common.DbDataReader reader = dbOperator.ExecuteReader("dbo.P_QueryBunks", System.Data.CommandType.StoredProcedure)) { Guid?previousId = null; Bunk bunk = null; while (reader.Read()) { var currentId = reader.GetGuid(1); if (bunk == null || previousId.Value != currentId) { bunk = null; } var bunkType = (BunkType)reader.GetInt32(0); switch (bunkType) { case BunkType.Economic: bunk = loadEconomicBunk(bunk, reader); break; case BunkType.FirstOrBusiness: bunk = loadFirstBusinessBunk(bunk, reader); break; case BunkType.Promotion: bunk = loadPromotionBunk(bunk, reader); break; case BunkType.Production: bunk = loadProductionBunk(bunk, reader); break; case BunkType.Transfer: bunk = loadTransferBunk(bunk, reader); break; case BunkType.Free: bunk = loadFreeBunk(bunk, reader); break; case BunkType.Team: bunk = loadTeamBunk(bunk, reader); break; } bunk.VoyageType = (VoyageTypeValue)reader.GetByte(19); bunk.TravelType = (TravelTypeValue)reader.GetByte(20); bunk.PassengerType = (PassengerTypeValue)reader.GetByte(21); bunk.RefundRegulation = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); bunk.ChangeRegulation = reader.IsDBNull(16) ? string.Empty : reader.GetString(16); bunk.EndorseRegulation = reader.IsDBNull(17) ? string.Empty : reader.GetString(17); bunk.Remarks = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); if (!previousId.HasValue || previousId.Value != currentId) { result.Add(bunk); previousId = currentId; } } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } } return(result); }
string prepareInsert(DbOperator dbOperator, Bunk value) { string bunkSql = "INSERT INTO [T_Bunk]([Id],[Airline],[FlightBeginDate],[FlightEndDate],[ETDZDate],[Code],[Discount],[Valid],[Departure]," + "[Arrival],[Type],[Description],ModifyTime,[VoyageType],[TravelType],[PassengerType],[RefundRegulation],[ChangeRegulation],[EndorseRegulation],[Remarks]) " + "VALUES(@ID,@AIRLINE,@FLIGHTBEGINDATE,@FLIGHTENDDATE,@ETDZDATE,@CODE,@DISCOUNT,@VALID,@DEPARTURE,@ARRIVAL,@TYPE,@DESCRIPTION," + "@ModifyTime,@VoyageType,@TravelType,@PassengerType,@RefundRegulation,@ChangeRegulation,@EndorseRegulation,@Remarks)"; string extendedBunkInsertSql = "INSERT INTO [T_ExtendedBunk] ([BunkId],[Code],[Discount])"; string extendedBunkValueFormat = " SELECT @ID,@CODE{0},@DISCOUNT{0} UNION ALL"; var sbSql = new StringBuilder(bunkSql); dbOperator.AddParameter("ID", value.Id); dbOperator.AddParameter("VoyageType", value.VoyageType); dbOperator.AddParameter("TravelType", value.TravelType); dbOperator.AddParameter("PassengerType", value.PassengerType); dbOperator.AddParameter("RefundRegulation", value.RefundRegulation); dbOperator.AddParameter("ChangeRegulation", value.ChangeRegulation); dbOperator.AddParameter("EndorseRegulation", value.EndorseRegulation); if (string.IsNullOrEmpty(value.Remarks)) { dbOperator.AddParameter("Remarks", DBNull.Value); } else { dbOperator.AddParameter("Remarks", value.Remarks); } if (value.AirlineCode.IsNullOrEmpty()) { dbOperator.AddParameter("AIRLINE", DBNull.Value); } else { dbOperator.AddParameter("AIRLINE", value.AirlineCode.Value); } dbOperator.AddParameter("FLIGHTBEGINDATE", value.FlightBeginDate); if (value.FlightEndDate.HasValue) { dbOperator.AddParameter("FLIGHTENDDATE", value.FlightEndDate.Value); } else { dbOperator.AddParameter("FLIGHTENDDATE", DBNull.Value); } dbOperator.AddParameter("ETDZDATE", value.ETDZDate); dbOperator.AddParameter("CODE", value.Code.Value); dbOperator.AddParameter("VALID", value.Valid); if (value is GeneralBunk) { var generalBunk = value as GeneralBunk; if (generalBunk.DepartureCode.IsNullOrEmpty()) { dbOperator.AddParameter("DEPARTURE", DBNull.Value); } else { dbOperator.AddParameter("DEPARTURE", generalBunk.DepartureCode.Value); } if (generalBunk.ArrivalCode.IsNullOrEmpty()) { dbOperator.AddParameter("ARRIVAL", DBNull.Value); } else { dbOperator.AddParameter("ARRIVAL", generalBunk.ArrivalCode.Value); } dbOperator.AddParameter("DISCOUNT", generalBunk.Discount); if (value is EconomicBunk) { dbOperator.AddParameter("DESCRIPTION", DBNull.Value); } else if (value is FirstBusinessBunk) { dbOperator.AddParameter("DESCRIPTION", (value as FirstBusinessBunk).Description ?? string.Empty); } if (generalBunk.Extended.Any()) { sbSql.Append(extendedBunkInsertSql); int index = 0; foreach (var item in generalBunk.Extended) { sbSql.AppendFormat(extendedBunkValueFormat, index); dbOperator.AddParameter("CODE" + index.ToString(), item.Code.Value); dbOperator.AddParameter("DISCOUNT" + index.ToString(), item.Discount); index++; } sbSql.Remove(sbSql.Length - 10, 10); } } else if (value is PromotionBunk) { var promotionBunk = value as PromotionBunk; dbOperator.AddParameter("DEPARTURE", DBNull.Value); dbOperator.AddParameter("ARRIVAL", DBNull.Value); dbOperator.AddParameter("DISCOUNT", DBNull.Value); dbOperator.AddParameter("DESCRIPTION", promotionBunk.Description ?? string.Empty); if (promotionBunk.Extended.Any()) { sbSql.Append(extendedBunkInsertSql); int index = 0; foreach (var item in promotionBunk.Extended) { sbSql.AppendFormat(extendedBunkValueFormat, index); dbOperator.AddParameter("CODE" + index.ToString(), item); dbOperator.AddParameter("DISCOUNT" + index.ToString(), 0); index++; } sbSql.Remove(sbSql.Length - 10, 10); } } else if (value is ProductionBunk) { dbOperator.AddParameter("DEPARTURE", DBNull.Value); dbOperator.AddParameter("ARRIVAL", DBNull.Value); dbOperator.AddParameter("DISCOUNT", DBNull.Value); dbOperator.AddParameter("DESCRIPTION", DBNull.Value); } else if (value is TransferBunk) { dbOperator.AddParameter("DEPARTURE", DBNull.Value); dbOperator.AddParameter("ARRIVAL", DBNull.Value); dbOperator.AddParameter("DISCOUNT", DBNull.Value); dbOperator.AddParameter("DESCRIPTION", DBNull.Value); } else if (value is FreeBunk) { dbOperator.AddParameter("DEPARTURE", DBNull.Value); dbOperator.AddParameter("ARRIVAL", DBNull.Value); dbOperator.AddParameter("DISCOUNT", DBNull.Value); dbOperator.AddParameter("DESCRIPTION", (value as FreeBunk).Description ?? string.Empty); } else if (value is TeamBunk) { dbOperator.AddParameter("DEPARTURE", DBNull.Value); dbOperator.AddParameter("ARRIVAL", DBNull.Value); dbOperator.AddParameter("DISCOUNT", DBNull.Value); dbOperator.AddParameter("DESCRIPTION", DBNull.Value); } else { return(null); } dbOperator.AddParameter("TYPE", (int)value.Type); dbOperator.AddParameter("ModifyTime", value.ModifyTime); return(sbSql.ToString()); }
/// <summary> /// 修改设备参数 /// </summary> /// <param name="model"></param> /// <param name="dbOperator"></param> /// <returns></returns> public bool UpdateParam(ParkDeviceParam model, DbOperator dbOperator) { model.DataStatus = (int)DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkDeviceParam set DeviceID=@DeviceID,VipMode=@VipMode,TempMode=@TempMode,NetOffMode=@NetOffMode,VipDevMultIn=@VipDevMultIn,PloicFree=@PloicFree,VipDutyDay=@VipDutyDay,OverDutyYorN=@OverDutyYorN,OverDutyDay=@OverDutyDay,SysID=@SysID,"); strSql.Append(" DevID=@DevID,SysInDev=@SysInDev,SysOutDev=@SysOutDev,SysParkNumber=@SysParkNumber,DevInorOut=@DevInorOut,SwipeInterval=@SwipeInterval,UnKonwCardType=@UnKonwCardType,LEDNumber=@LEDNumber,DataStatus=@DataStatus,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate "); strSql.Append(" where RecordID=@RecordID"); dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", model.RecordID); dbOperator.AddParameter("DeviceID", model.DeviceID); dbOperator.AddParameter("VipMode", model.VipMode); dbOperator.AddParameter("TempMode", model.TempMode); dbOperator.AddParameter("NetOffMode", model.NetOffMode); dbOperator.AddParameter("VipDevMultIn", model.VipDevMultIn); dbOperator.AddParameter("PloicFree", model.PloicFree); dbOperator.AddParameter("VipDutyDay", model.VipDutyDay); dbOperator.AddParameter("OverDutyYorN", model.OverDutyYorN); dbOperator.AddParameter("OverDutyDay", model.OverDutyDay); dbOperator.AddParameter("SysID", model.SysID); dbOperator.AddParameter("DevID", model.DevID); dbOperator.AddParameter("SysInDev", model.SysInDev); dbOperator.AddParameter("SysOutDev", model.SysOutDev); dbOperator.AddParameter("SysParkNumber", model.SysParkNumber); dbOperator.AddParameter("DevInorOut", model.DevInorOut); dbOperator.AddParameter("SwipeInterval", (int)model.SwipeInterval); dbOperator.AddParameter("UnKonwCardType", model.UnKonwCardType); dbOperator.AddParameter("LEDNumber", model.LEDNumber); dbOperator.AddParameter("DataStatus", model.DataStatus); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public ParkOrder Add(ParkOrder model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; model.RecordID = GuidGenerator.GetGuidString(); StringBuilder strSql = new StringBuilder(); strSql.Append(@"insert into ParkOrder(RecordID,Amount,CarderateID,CashMoney,CashTime,DataStatus,DiscountAmount,HaveUpdate,LastUpdateTime,NewMoney,NewUsefulDate, NewUserBegin,OldMoney,OldUserBegin,OldUserulDate,OnlineOrderNo,OnlineUserID,OrderNo,OrderSource,OrderTime,OrderType,PayAmount, PayTime,PayWay,PKID,Remark,Status,TagID,UnPayAmount,UserID,FeeRuleID) "); strSql.Append(@" values(@RecordID,@Amount,@CarderateID,@CashMoney,@CashTime,@DataStatus,@DiscountAmount,@HaveUpdate,@LastUpdateTime,@NewMoney,@NewUsefulDate, @NewUserBegin,@OldMoney,@OldUserBegin,@OldUserulDate,@OnlineOrderNo,@OnlineUserID,@OrderNo,@OrderSource,@OrderTime,@OrderType,@PayAmount, @PayTime,@PayWay,@PKID,@Remark,@Status,@TagID,@UnPayAmount,@UserID,@FeeRuleID);"); strSql.Append(" select * from ParkOrder where RecordID=@RecordID "); dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", model.RecordID); dbOperator.AddParameter("Amount", model.Amount); dbOperator.AddParameter("CarderateID", model.CarderateID); dbOperator.AddParameter("CashMoney", model.CashMoney); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("DiscountAmount", model.DiscountAmount); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("NewMoney", model.NewMoney); if (model.CashTime == null) { dbOperator.AddParameter("CashTime", DBNull.Value); } else { dbOperator.AddParameter("CashTime", model.CashTime); } if (model.NewUsefulDate == null) { dbOperator.AddParameter("NewUsefulDate", DBNull.Value); } else { dbOperator.AddParameter("NewUsefulDate", model.NewUsefulDate); } if (model.OldUserulDate == null) { dbOperator.AddParameter("OldUserulDate", DBNull.Value); } else { dbOperator.AddParameter("OldUserulDate", model.OldUserulDate); } if (model.OldUserBegin == null) { dbOperator.AddParameter("OldUserBegin", DBNull.Value); } else { dbOperator.AddParameter("OldUserBegin", model.OldUserBegin); } if (model.NewUserBegin == null) { dbOperator.AddParameter("NewUserBegin", DBNull.Value); } else { dbOperator.AddParameter("NewUserBegin", model.NewUserBegin); } dbOperator.AddParameter("OldMoney", model.OldMoney); dbOperator.AddParameter("OnlineOrderNo", model.OnlineOrderNo); dbOperator.AddParameter("OnlineUserID", model.OnlineUserID); dbOperator.AddParameter("OrderNo", model.OrderNo); dbOperator.AddParameter("OrderSource", model.OrderSource); dbOperator.AddParameter("OrderTime", model.OrderTime); dbOperator.AddParameter("OrderType", model.OrderType); dbOperator.AddParameter("PayAmount", model.PayAmount); dbOperator.AddParameter("PayTime", model.PayTime); dbOperator.AddParameter("PayWay", model.PayWay); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("FeeRuleID", model.FeeRuleID); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("Status", model.Status); dbOperator.AddParameter("TagID", model.TagID); dbOperator.AddParameter("UnPayAmount", model.UnPayAmount); dbOperator.AddParameter("UserID", model.UserID); using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString())) { if (reader.Read()) { return(DataReaderToModel <ParkOrder> .ToModel(reader)); } return(null); } }
public bool Update(ParkDevice model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkDevice set DeviceID=@DeviceID,GateID=@GateID,DeviceType=@DeviceType,PortType=@PortType,Baudrate=@Baudrate,SerialPort=@SerialPort,IpAddr=@IpAddr,IpPort=@IpPort,UserName=@UserName,UserPwd=@UserPwd,NetID=@NetID,LedNum=@LedNum,IsMonitor=@IsMonitor"); strSql.Append(",DeviceNo=@DeviceNo,OfflinePort=@OfflinePort,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,IsCapture=@IsCapture,IsSVoice=@IsSVoice,IsCarBit=@IsCarBit,IsContestDev=@IsContestDev,ControllerType=@ControllerType,DisplayMode=@DisplayMode where DeviceID=@DeviceID"); dbOperator.ClearParameters(); dbOperator.AddParameter("DeviceID", model.DeviceID); dbOperator.AddParameter("GateID", model.GateID); dbOperator.AddParameter("DeviceType", model.DeviceType); dbOperator.AddParameter("PortType", model.PortType); dbOperator.AddParameter("Baudrate", model.Baudrate); dbOperator.AddParameter("SerialPort", model.SerialPort); dbOperator.AddParameter("IpAddr", model.IpAddr); dbOperator.AddParameter("IpPort", model.IpPort); dbOperator.AddParameter("UserName", model.UserName); dbOperator.AddParameter("UserPwd", model.UserPwd); dbOperator.AddParameter("NetID", model.NetID); dbOperator.AddParameter("LedNum", model.LedNum); dbOperator.AddParameter("DeviceNo", model.DeviceNo); dbOperator.AddParameter("OfflinePort", model.OfflinePort); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("IsCapture", model.IsCapture); dbOperator.AddParameter("IsSVoice", model.IsSVoice); dbOperator.AddParameter("IsCarBit", model.IsCarBit); dbOperator.AddParameter("IsContestDev", model.IsContestDev); dbOperator.AddParameter("ControllerType", model.ControllerType); dbOperator.AddParameter("DisplayMode", model.DisplayMode); dbOperator.AddParameter("IsMonitor", model.IsMonitor); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool Create(OnlineOrder model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { dbOperator.ClearParameters(); StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO OnlineOrder(OrderID,PKID,PKName,InOutID,PlateNo,EntranceTime,ExitTime,Amount,PaymentChannel,PayBank"); strSql.Append(",PayAccount,Payer,PayeeChannel,PayeeBank,PayeeAccount,PayeeUser,PayDetailID,SerialNumber,PrepayId,MonthNum,AccountID"); strSql.Append(",CardId,SyncResultTimes,LastSyncResultTime,ParkCardNo,Balance,RefundOrderId,Remark,OrderType,Status,OrderTime,RealPayTime"); strSql.Append(",BookingStartTime,BookingEndTime,BookingAreaID,BookingBitNo,CompanyID,OrderSource,ExternalPKID,TagID)"); strSql.Append(" values(@OrderID,@PKID,@PKName,@InOutID,@PlateNo,@EntranceTime,@ExitTime,@Amount,@PaymentChannel,@PayBank"); strSql.Append(",@PayAccount,@Payer,@PayeeChannel,@PayeeBank,@PayeeAccount,@PayeeUser,@PayDetailID,@SerialNumber,@PrepayId,@MonthNum,@AccountID"); strSql.Append(",@CardId,@SyncResultTimes,@LastSyncResultTime,@ParkCardNo,@Balance,@RefundOrderId,@Remark,@OrderType,@Status,@OrderTime,@RealPayTime"); strSql.Append(",@BookingStartTime,@BookingEndTime,@BookingAreaID,@BookingBitNo,@CompanyID,@OrderSource,@ExternalPKID,@TagID)"); dbOperator.AddParameter("OrderID", model.OrderID); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("PKName", model.PKName); dbOperator.AddParameter("InOutID", model.InOutID); dbOperator.AddParameter("PlateNo", model.PlateNo); dbOperator.AddParameter("EntranceTime", model.EntranceTime); dbOperator.AddParameter("ExitTime", model.ExitTime); dbOperator.AddParameter("Amount", model.Amount); dbOperator.AddParameter("PaymentChannel", (int)model.PaymentChannel); dbOperator.AddParameter("PayBank", model.PayBank); dbOperator.AddParameter("PayAccount", model.PayAccount); dbOperator.AddParameter("Payer", model.Payer); dbOperator.AddParameter("PayeeChannel", (int)model.PayeeChannel); dbOperator.AddParameter("PayeeBank", model.PayeeBank); dbOperator.AddParameter("PayeeAccount", model.PayeeAccount); dbOperator.AddParameter("PayeeUser", model.PayeeUser); dbOperator.AddParameter("PayDetailID", model.PayDetailID); dbOperator.AddParameter("SerialNumber", model.SerialNumber); dbOperator.AddParameter("PrepayId", model.PrepayId); dbOperator.AddParameter("MonthNum", model.MonthNum); dbOperator.AddParameter("AccountID", model.AccountID); dbOperator.AddParameter("CardId", model.CardId); dbOperator.AddParameter("SyncResultTimes", model.SyncResultTimes); dbOperator.AddParameter("LastSyncResultTime", model.LastSyncResultTime); dbOperator.AddParameter("ParkCardNo", model.ParkCardNo); dbOperator.AddParameter("Balance", model.Balance); dbOperator.AddParameter("RefundOrderId", model.RefundOrderId); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("OrderType", model.OrderType); dbOperator.AddParameter("Status", model.Status); dbOperator.AddParameter("OrderTime", model.OrderTime); dbOperator.AddParameter("RealPayTime", model.RealPayTime); dbOperator.AddParameter("BookingStartTime", model.BookingStartTime); dbOperator.AddParameter("BookingEndTime", model.BookingEndTime); dbOperator.AddParameter("BookingAreaID", model.BookingAreaID); dbOperator.AddParameter("BookingBitNo", model.BookingBitNo); dbOperator.AddParameter("CompanyID", model.CompanyID); dbOperator.AddParameter("OrderSource", model.OrderSource); dbOperator.AddParameter("ExternalPKID", model.ExternalPKID); dbOperator.AddParameter("TagID", model.TagID); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Add(ParkArea model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkArea(AreaID,AreaName,MasterID,PKID,CarbitNum,NeedToll,CameraWaitTime,TwoCameraWait,Remark,LastUpdateTime,HaveUpdate,DataStatus)"); strSql.Append(" values(@AreaID,@AreaName,@MasterID,@PKID,@CarbitNum,@NeedToll,@CameraWaitTime,@TwoCameraWait,@Remark,@LastUpdateTime,@HaveUpdate,@DataStatus)"); dbOperator.ClearParameters(); dbOperator.AddParameter("AreaID", model.AreaID); dbOperator.AddParameter("AreaName", model.AreaName); dbOperator.AddParameter("MasterID", model.MasterID); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("CarbitNum", model.CarbitNum); dbOperator.AddParameter("NeedToll", (int)model.NeedToll); dbOperator.AddParameter("CameraWaitTime", (int)model.CameraWaitTime); dbOperator.AddParameter("TwoCameraWait", (int)model.TwoCameraWait); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Add(BaseVillage model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BaseVillage(VID,VNo,VName,CPID,LinkMan,Mobile,Address,Coordinate,ProxyNo,LastUpdateTime,HaveUpdate,DataStatus,IsBoxWatch)"); strSql.Append(" values(@VID,@VNo,@VName,@CPID,@LinkMan,@Mobile,@Address,@Coordinate,@ProxyNo,@LastUpdateTime,@HaveUpdate,@DataStatus,@IsBoxWatch)"); dbOperator.ClearParameters(); dbOperator.AddParameter("VID", model.VID); dbOperator.AddParameter("VNo", model.VNo); dbOperator.AddParameter("VName", model.VName); dbOperator.AddParameter("CPID", model.CPID); dbOperator.AddParameter("LinkMan", model.LinkMan); dbOperator.AddParameter("Mobile", model.Mobile); dbOperator.AddParameter("Address", model.Address); dbOperator.AddParameter("Coordinate", model.Coordinate); dbOperator.AddParameter("ProxyNo", model.ProxyNo); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("IsBoxWatch", model.IsBoxWatch); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool Update(ParkCarModel model) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update ParkCarModel set CarModelName=@CarModelName,IsDefault=@IsDefault,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,MaxUseMoney=@MaxUseMoney,IsNaturalDay=@IsNaturalDay,PlateColor=@PlateColor "); strSql.Append(",DayMaxMoney=@DayMaxMoney,NightMaxMoney=@NightMaxMoney,DayStartTime=@DayStartTime,DayEndTime=@DayEndTime,NightStartTime=@NightStartTime,NightEndTime=@NightEndTime where CarModelID=@CarModelID"); using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { UpdateDefault(model, dbOperator); dbOperator.ClearParameters(); dbOperator.AddParameter("CarModelName", model.CarModelName); dbOperator.AddParameter("IsDefault", (int)model.IsDefault); dbOperator.AddParameter("CarModelID", model.CarModelID); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("MaxUseMoney", model.MaxUseMoney); dbOperator.AddParameter("IsNaturalDay", model.IsNaturalDay); dbOperator.AddParameter("PlateColor", model.PlateColor); dbOperator.AddParameter("DayMaxMoney", model.DayMaxMoney); dbOperator.AddParameter("NightMaxMoney", model.NightMaxMoney); dbOperator.AddParameter("DayStartTime", model.DayStartTime); dbOperator.AddParameter("DayEndTime", model.DayEndTime); dbOperator.AddParameter("NightStartTime", model.NightStartTime); dbOperator.AddParameter("NightEndTime", model.NightEndTime); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Update(BaseVillage model) { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("update BaseVillage set VNo=@VNo,VName=@VName,CPID=@CPID,LinkMan=@LinkMan,Mobile=@Mobile,Address=@Address,Coordinate=@Coordinate,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate"); strSql.Append(" ,IsBoxWatch=@IsBoxWatch where VID=@VID"); dbOperator.ClearParameters(); dbOperator.AddParameter("VID", model.VID); dbOperator.AddParameter("VNo", model.VNo); dbOperator.AddParameter("VName", model.VName); dbOperator.AddParameter("CPID", model.CPID); dbOperator.AddParameter("LinkMan", model.LinkMan); dbOperator.AddParameter("Mobile", model.Mobile); dbOperator.AddParameter("Address", model.Address); dbOperator.AddParameter("Coordinate", model.Coordinate); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("IsBoxWatch", model.IsBoxWatch); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
public bool Add(BaseCard model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BaseCard(CardID,EmployeeID,CardNo,CardNumb,CardType,Balance,State,Deposit,RegisterTime ,OperatorID,CardSystem,VID,LastUpdateTime,HaveUpdate,DataStatus)"); strSql.Append(" values(@CardID,@EmployeeID,@CardNo,@CardNumb,@CardType,@Balance,@State,@Deposit,@RegisterTime ,@OperatorID,@CardSystem,@VID,@LastUpdateTime,@HaveUpdate,@DataStatus)"); dbOperator.ClearParameters(); dbOperator.AddParameter("CardID", model.CardID); dbOperator.AddParameter("EmployeeID", model.EmployeeID); dbOperator.AddParameter("CardNo", model.CardNo); dbOperator.AddParameter("CardNumb", model.CardNumb); dbOperator.AddParameter("CardType", (int)model.CardType); dbOperator.AddParameter("Balance", model.Balance); dbOperator.AddParameter("State", (int)model.State); dbOperator.AddParameter("Deposit", model.Deposit); dbOperator.AddParameter("RegisterTime", model.RegisterTime); dbOperator.AddParameter("OperatorID",model.OperatorID); dbOperator.AddParameter("CardSystem", (int)model.CardSystem); dbOperator.AddParameter("VID",model.VID); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); return dbOperator.ExecuteNonQuery(strSql.ToString()) > 0; }
private bool AddFeeRule(ParkFeeRule model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkFeeRule(FeeRuleID,RuleName,FeeType,CarTypeID,CarModelID,AreaID,LastUpdateTime,HaveUpdate,DataStatus,RuleText,IsOffline)"); strSql.Append(" values(@FeeRuleID,@RuleName,@FeeType,@CarTypeID,@CarModelID,@AreaID,@LastUpdateTime,@HaveUpdate,@DataStatus,@RuleText,@IsOffline)"); dbOperator.ClearParameters(); dbOperator.AddParameter("FeeRuleID", model.FeeRuleID); dbOperator.AddParameter("RuleName", model.RuleName); dbOperator.AddParameter("FeeType", (int)model.FeeType); dbOperator.AddParameter("CarTypeID", model.CarTypeID); dbOperator.AddParameter("CarModelID", model.CarModelID); dbOperator.AddParameter("AreaID", model.AreaID); dbOperator.AddParameter("RuleText", model.RuleText); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("IsOffline", model.IsOffline); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool ModifyBaseCard(BaseCard model, out string ErrorMessage) { ErrorMessage = ""; try { using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append(@"update BaseCard set Balance=@Balance,CardID=@CardID,CardNo=@CardNo, CardNumb=@CardNumb,CardSystem=@CardSystem,CardType=@CardType, Deposit=@Deposit,EmployeeID=@EmployeeID,HaveUpdate=@HaveUpdate,LastUpdateTime=@LastUpdateTime, OperatorID=@OperatorID,State=@State,VID=@VID"); strSql.Append(" where CardID=@CardID"); dbOperator.ClearParameters(); dbOperator.AddParameter("Balance", model.Balance); dbOperator.AddParameter("CardID", model.CardID); dbOperator.AddParameter("CardNo", model.CardNo); dbOperator.AddParameter("CardNumb", model.CardNumb); dbOperator.AddParameter("CardSystem", (int)model.CardSystem); dbOperator.AddParameter("CardType", (int)model.CardType); dbOperator.AddParameter("Deposit", model.Deposit); dbOperator.AddParameter("EmployeeID", model.EmployeeID); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("OperatorID", model.OperatorID); dbOperator.AddParameter("State", (int)model.State); dbOperator.AddParameter("VID", model.VID); return dbOperator.ExecuteNonQuery(strSql.ToString()) > 0; } } catch (Exception e) { ErrorMessage = e.Message; } return false; }
private bool AddFeeRuleDetails(List <ParkFeeRuleDetail> parkFeeRuleDetails, DbOperator dbOperator) { if (parkFeeRuleDetails == null || parkFeeRuleDetails.Count == 0) { throw new ArgumentNullException("parkFeeRuleDetails"); } StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkFeeRuleDetail(RuleDetailID,RuleID,StartTime,EndTime,Supplement,LoopType,Limit"); strSql.Append(",FreeTime,FirstTime,FirstFee,Loop1PerTime,Loop1PerFee,Loop2Start,Loop2PerTime,Loop2PerFee,LastUpdateTime,HaveUpdate,DataStatus)"); strSql.Append(" values(@RuleDetailID,@RuleID,@StartTime,@EndTime,@Supplement,@LoopType,@Limit"); strSql.Append(",@FreeTime,@FirstTime,@FirstFee,@Loop1PerTime,@Loop1PerFee,@Loop2Start,@Loop2PerTime,@Loop2PerFee,@LastUpdateTime,@HaveUpdate,@DataStatus)"); foreach (var model in parkFeeRuleDetails) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; dbOperator.ClearParameters(); dbOperator.AddParameter("RuleDetailID", model.RuleDetailID); dbOperator.AddParameter("RuleID", model.RuleID); dbOperator.AddParameter("StartTime", model.StartTime); dbOperator.AddParameter("EndTime", model.EndTime); dbOperator.AddParameter("Supplement", model.Supplement); dbOperator.AddParameter("LoopType", (int)model.LoopType); dbOperator.AddParameter("Limit", model.Limit); dbOperator.AddParameter("FreeTime", model.FreeTime); dbOperator.AddParameter("FirstTime", model.FirstTime); dbOperator.AddParameter("FirstFee", model.FirstFee); dbOperator.AddParameter("Loop1PerTime", model.Loop1PerTime); dbOperator.AddParameter("Loop1PerFee", model.Loop1PerFee); dbOperator.AddParameter("Loop2Start", model.Loop2Start); dbOperator.AddParameter("Loop2PerTime", model.Loop2PerTime); dbOperator.AddParameter("Loop2PerFee", model.Loop2PerFee); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); bool result = dbOperator.ExecuteNonQuery(strSql.ToString()) > 0; if (!result) { return(false); } } return(true); }
// public int Update(Domain.CompanyUpgrade companyUpgrade) { // string sql = @"UPDATE [dbo].[T_CompanyUpgradeApplication] SET [UserNo] = @UserNo,[Name] = @Name,[AbbreviateName] = @AbbreviateName,[OrginationCode] = @OrginationCode, // [OfficePhones] = @OfficePhones,[ManagerName] = @ManagerName,[ManagerPhone] = @ManagerPhone,[EmergencyName] = @EmergencyName,[EmergencyPhone] = @EmergencyPhone, // [Type] = @Type,[AccountType] = @AccountType,[Audited] =@Audited,[AuditTime]=@AuditTime,[ApplyTime] = @ApplyTime WHERE [Company] = @Company"; // using (var dbOperator = new DbOperator(Provider, ConnectionString)) { // dbOperator.AddParameter("Company", companyUpgrade.CompanyId); // dbOperator.AddParameter("UserNo", companyUpgrade.UserNo); // if (string.IsNullOrWhiteSpace(companyUpgrade.CompanyName)) { // dbOperator.AddParameter("Name", DBNull.Value); // } else { // dbOperator.AddParameter("Name", companyUpgrade.CompanyName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.AbbreviateName)) { // dbOperator.AddParameter("AbbreviateName", DBNull.Value); // } else { // dbOperator.AddParameter("AbbreviateName", companyUpgrade.AbbreviateName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.OrginationCode)) { // dbOperator.AddParameter("OrginationCode", DBNull.Value); // } else { // dbOperator.AddParameter("OrginationCode", companyUpgrade.OrginationCode); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.CompanyPhone)) { // dbOperator.AddParameter("OfficePhones", DBNull.Value); // } else { // dbOperator.AddParameter("OfficePhones", companyUpgrade.CompanyPhone); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerName)) { // dbOperator.AddParameter("ManagerName", DBNull.Value); // } else { // dbOperator.AddParameter("ManagerName", companyUpgrade.ManagerName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerPhone)) { // dbOperator.AddParameter("ManagerPhone", DBNull.Value); // } else { // dbOperator.AddParameter("ManagerPhone", companyUpgrade.ManagerPhone); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyName)) { // dbOperator.AddParameter("EmergencyName", DBNull.Value); // } else { // dbOperator.AddParameter("EmergencyName", companyUpgrade.EmergencyName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyPhone)) { // dbOperator.AddParameter("EmergencyPhone", DBNull.Value); // } else { // dbOperator.AddParameter("EmergencyPhone", companyUpgrade.EmergencyPhone); // } // dbOperator.AddParameter("Type", (int)companyUpgrade.CompanyType); // dbOperator.AddParameter("AccountType", (int)companyUpgrade.AccountType); // dbOperator.AddParameter("Audited",companyUpgrade.Audited); // if (companyUpgrade.AuditTime.HasValue) { // dbOperator.AddParameter("AuditTime", companyUpgrade.AuditTime); // } else { // dbOperator.AddParameter("AuditTime",DBNull.Value); // } // dbOperator.AddParameter("ApplyTime", companyUpgrade.ApplyTime); // return dbOperator.ExecuteNonQuery(sql); // } // } public CompanyUpgrade Query(Guid companyId) { CompanyUpgrade companyUpgrade = null; string sql = @"SELECT [UserNo],[Name],[AbbreviateName],[OrginationCode],[OfficePhones],[ManagerName],[ManagerPhone], [EmergencyName],[EmergencyPhone],[Type],[AccountType],[Audited],[AuditTime],[ApplyTime] FROM [dbo].[T_CompanyUpgradeApplication] WHERE [Company] = @Company"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", companyId); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { companyUpgrade = new CompanyUpgrade(); companyUpgrade.Company = companyId; companyUpgrade.UserNo = reader.GetString(0); if (!reader.IsDBNull(1)) { companyUpgrade.Name = reader.GetString(1); } if (!reader.IsDBNull(2)) { companyUpgrade.AbbreviateName = reader.GetString(2); } if (!reader.IsDBNull(3)) { companyUpgrade.OrginationCode = reader.GetString(3); } if (!reader.IsDBNull(4)) { companyUpgrade.OfficePhones = reader.GetString(4); } if (!reader.IsDBNull(5)) { companyUpgrade.ManagerName = reader.GetString(5); } if (!reader.IsDBNull(6)) { companyUpgrade.ManagerPhone = reader.GetString(6); } if (!reader.IsDBNull(7)) { companyUpgrade.EmergencyName = reader.GetString(7); } if (!reader.IsDBNull(8)) { companyUpgrade.EmergencyPhone = reader.GetString(8); } companyUpgrade.Type = (Common.Enums.CompanyType)reader.GetByte(9); companyUpgrade.AccountType = (Common.Enums.AccountBaseType)reader.GetByte(10); companyUpgrade.Audited = reader.GetBoolean(11); if (!reader.IsDBNull(12)) { companyUpgrade.AuditTime = reader.GetDateTime(12); } companyUpgrade.ApplyTime = reader.GetDateTime(13); } } } return(companyUpgrade); }
public bool Add(ParkDevice model, DbOperator dbOperator) { model.DataStatus = DataStatus.Normal; model.LastUpdateTime = DateTime.Now; model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ParkDevice(DeviceID,GateID,DeviceType,PortType,Baudrate,SerialPort,IpAddr,IpPort,UserName,UserPwd,NetID,LedNum,DeviceNo,OfflinePort,DataStatus,LastUpdateTime,HaveUpdate,IsCapture,IsSVoice,IsCarBit,IsContestDev,ControllerType,DisplayMode,IsMonitor)"); strSql.Append(" values(@DeviceID,@GateID,@DeviceType,@PortType,@Baudrate,@SerialPort,@IpAddr,@IpPort,@UserName,@UserPwd,@NetID,@LedNum,@DeviceNo,@OfflinePort,@DataStatus,@LastUpdateTime,@HaveUpdate,@IsCapture,@IsSVoice,@IsCarBit,@IsContestDev,@ControllerType,@DisplayMode,@IsMonitor)"); dbOperator.ClearParameters(); dbOperator.AddParameter("DeviceID", model.DeviceID); dbOperator.AddParameter("GateID", model.GateID); dbOperator.AddParameter("DeviceType", model.DeviceType); dbOperator.AddParameter("PortType", model.PortType); dbOperator.AddParameter("Baudrate", model.Baudrate); dbOperator.AddParameter("SerialPort", model.SerialPort); dbOperator.AddParameter("IpAddr", model.IpAddr); dbOperator.AddParameter("IpPort", model.IpPort); dbOperator.AddParameter("UserName", model.UserName); dbOperator.AddParameter("UserPwd", model.UserPwd); dbOperator.AddParameter("NetID", model.NetID); dbOperator.AddParameter("LedNum", model.LedNum); dbOperator.AddParameter("DeviceNo", model.DeviceNo); dbOperator.AddParameter("OfflinePort", model.OfflinePort); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("IsCapture", model.IsCapture); dbOperator.AddParameter("IsSVoice", model.IsSVoice); dbOperator.AddParameter("IsCarBit", model.IsCarBit); dbOperator.AddParameter("IsContestDev", model.IsContestDev); dbOperator.AddParameter("ControllerType", model.ControllerType); dbOperator.AddParameter("DisplayMode", model.DisplayMode); dbOperator.AddParameter("IsMonitor", model.IsMonitor); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool Create(WX_Menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WX_Menu(MenuName,Url,KeywordId,MenuType,Sort,MasterID,DataStatus,CreateTime,CompanyID,MinIprogramAppId,MinIprogramPagePath)"); strSql.Append(" values(@MenuName,@Url,@KeywordId,@MenuType,@Sort,@MasterID,@DataStatus,@CreateTime,@CompanyID,@MinIprogramAppId,@MinIprogramPagePath)"); using (DbOperator dbOperator = ConnectionManager.CreateConnection()) { dbOperator.ClearParameters(); dbOperator.AddParameter("MenuName", model.MenuName); dbOperator.AddParameter("Url", model.Url); dbOperator.AddParameter("KeywordId", model.KeywordId); dbOperator.AddParameter("MenuType", (int)model.MenuType); dbOperator.AddParameter("Sort", model.Sort); dbOperator.AddParameter("MasterID", model.MasterID); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("CreateTime", DateTime.Now); dbOperator.AddParameter("CompanyID", model.CompanyID); dbOperator.AddParameter("MinIprogramAppId", model.MinIprogramAppId); dbOperator.AddParameter("MinIprogramPagePath", model.MinIprogramPagePath); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); } }
/// <summary> /// 退款操作 /// </summary> /// <param name="GID"></param> /// <param name="Amout"></param> /// <param name="EndTime"></param> /// <returns></returns> public bool RefundCardAmout(List <ParkGrant> grantlist, DateTime EndTime, ParkOrder model) { try { using (DbOperator dbOperator = ConnectionManager.CreateReadConnection()) { dbOperator.BeginTransaction(); foreach (var obj in grantlist) { string strsql = "update ParkGrant set EndDate=@EndDate,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate where GID=@GID"; dbOperator.ClearParameters(); dbOperator.AddParameter("EndDate", EndTime); dbOperator.AddParameter("LastUpdateTime", DateTime.Now); dbOperator.AddParameter("HaveUpdate", SystemDefaultConfig.DataUpdateFlag); dbOperator.AddParameter("GID", obj.GID); if (dbOperator.ExecuteNonQuery(strsql) < 0) { dbOperator.RollbackTransaction(); return(false); } } StringBuilder strSql = new StringBuilder(); strSql.Append(@"insert into ParkOrder(RecordID,Amount,CarderateID,CashMoney,CashTime,DataStatus,DiscountAmount,HaveUpdate,LastUpdateTime,NewMoney,NewUsefulDate, NewUserBegin,OldMoney,OldUserBegin,OldUserulDate,OnlineOrderNo,OnlineUserID,OrderNo,OrderSource,OrderTime,OrderType,PayAmount, PayTime,PayWay,PKID,Remark,Status,TagID,UnPayAmount,UserID,FeeRuleID) "); strSql.Append(@" values(@RecordID,@Amount,@CarderateID,@CashMoney,@CashTime,@DataStatus,@DiscountAmount,@HaveUpdate,@LastUpdateTime,@NewMoney,@NewUsefulDate, @NewUserBegin,@OldMoney,@OldUserBegin,@OldUserulDate,@OnlineOrderNo,@OnlineUserID,@OrderNo,@OrderSource,@OrderTime,@OrderType,@PayAmount, @PayTime,@PayWay,@PKID,@Remark,@Status,@TagID,@UnPayAmount,@UserID,@FeeRuleID);"); dbOperator.ClearParameters(); dbOperator.AddParameter("RecordID", model.RecordID); dbOperator.AddParameter("Amount", model.Amount); dbOperator.AddParameter("CarderateID", model.CarderateID); dbOperator.AddParameter("CashMoney", model.CashMoney); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("DiscountAmount", model.DiscountAmount); dbOperator.AddParameter("HaveUpdate", model.HaveUpdate); dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime); dbOperator.AddParameter("NewMoney", model.NewMoney); dbOperator.AddParameter("CashTime", DBNull.Value); dbOperator.AddParameter("NewUsefulDate", model.NewUsefulDate); dbOperator.AddParameter("OldUserulDate", model.OldUserulDate); dbOperator.AddParameter("OldUserBegin", model.OldUserBegin); dbOperator.AddParameter("NewUserBegin", model.NewUserBegin); dbOperator.AddParameter("OldMoney", model.OldMoney); dbOperator.AddParameter("OnlineOrderNo", model.OnlineOrderNo); dbOperator.AddParameter("OnlineUserID", model.OnlineUserID); dbOperator.AddParameter("OrderNo", model.OrderNo); dbOperator.AddParameter("OrderSource", model.OrderSource); dbOperator.AddParameter("OrderTime", model.OrderTime); dbOperator.AddParameter("OrderType", model.OrderType); dbOperator.AddParameter("PayAmount", model.PayAmount); dbOperator.AddParameter("PayTime", model.PayTime); dbOperator.AddParameter("PayWay", model.PayWay); dbOperator.AddParameter("PKID", model.PKID); dbOperator.AddParameter("FeeRuleID", model.FeeRuleID); dbOperator.AddParameter("Remark", model.Remark); dbOperator.AddParameter("Status", model.Status); dbOperator.AddParameter("TagID", model.TagID); dbOperator.AddParameter("UnPayAmount", model.UnPayAmount); dbOperator.AddParameter("UserID", model.UserID); if (dbOperator.ExecuteNonQuery(strSql.ToString()) < 0) { dbOperator.RollbackTransaction(); return(false); } dbOperator.CommitTransaction(); return(true); } } catch (Exception ex) { return(false); } }