public void DBItemBase_Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID, out t_String ItemCode, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { ItemCode = new t_String(); t_String MaxCode; _DALDBItemBase.GetMaxCode(args, out MaxCode); int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("S", "")); CodeIndex++; if (CodeIndex < 10) { ItemCode.SetValueWithObject("S00" + CodeIndex.ToString()); } else if (CodeIndex < 100) { ItemCode.SetValueWithObject("S0" + CodeIndex.ToString()); } else { ItemCode.SetValueWithObject("S" + CodeIndex.ToString()); } _DALDBItemBase.Insert(args, out ItemID, ItemTypeID, ItemCode, K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ItemPrice); }
public void Update(FactoryArgs args, t_BigID ReportTemplateID, t_String ReportTemplateName, t_DTSmall TemplateFileTime, t_ID TemplateSeq, t_String Description, t_Image TemplateData, t_BigID ReportTypeID, t_String PrinterName, t_String MachineName, t_Bool IsManualPaperType, t_String PaperType, t_Bool IsManualPaperSize, t_ID PaperSizeHeight, t_ID PaperSizeWidth, t_Bool IsPaperTransverse, t_ID PrintCount) { using (DataTable dtExistsName = _DALDbReportTemplate.ExistsTemplateName(args, ReportTemplateName, ReportTypeID)) { if (dtExistsName.Rows.Count > 0)//校验上级权限组是否存在 { dtExistsName.DefaultView.RowFilter = "ReportTemplateID<>" + ReportTemplateID.Value; if (dtExistsName.DefaultView.Count == 0) { _DALDbReportTemplate.Update(args, ReportTemplateID, ReportTemplateName, TemplateFileTime, TemplateSeq, Description, TemplateData, ReportTypeID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse, PrintCount); } else { throw new Exception("该报表名称已存在!"); } } else { _DALDbReportTemplate.Update(args, ReportTemplateID, ReportTemplateName, TemplateFileTime, TemplateSeq, Description, TemplateData, ReportTypeID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse, PrintCount); } } }
public void InsertInfraredDeviceConfig(FactoryArgs args, t_String MachineName, t_String SerialName, t_ID HeaderXType, t_ID TailXType, t_ID HeaderYType, t_ID TailYType, t_Bool IsHeaderEffect, t_Bool IsTailEffect) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("SerialName", SerialName)); parms.Add(new LBDbParameter("HeaderXType", HeaderXType)); parms.Add(new LBDbParameter("TailXType", TailXType)); parms.Add(new LBDbParameter("HeaderYType", HeaderYType)); parms.Add(new LBDbParameter("TailYType", TailYType)); parms.Add(new LBDbParameter("IsHeaderEffect", IsHeaderEffect)); parms.Add(new LBDbParameter("IsTailEffect", IsTailEffect)); string strSQL = @" insert into dbo.DbInfraredDeviceConfig( MachineName,SerialName, HeaderXType,TailXType,HeaderYType,TailYType,IsHeaderEffect,IsTailEffect ) values( @MachineName,@SerialName, @HeaderXType,@TailXType,@HeaderXType,@TailXType,@IsHeaderEffect,@IsTailEffect) "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void DBItemBase_Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { _DALDBItemBase.Update(args, ItemID, ItemTypeID, K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ItemPrice); }
public void Customer_UpdateFromService(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode, t_BigID CustomerTypeID) { DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { this.Customer_Update(argsInTrans, CustomerID, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID); _DALDbCustomer.UpdateAmount(argsInTrans, CustomerID, TotalReceivedAmount, SalesReceivedAmount); IsForbid.IsNullToZero(); if (IsForbid.Value == 1) { _DALDbCustomer.Forbid(args, CustomerID); } else { _DALDbCustomer.UnForbid(args, CustomerID); } }; DBHelper.ExecInTrans(args, exec); }
public void Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID, t_String ItemCode, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { ItemID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ItemID", ItemID, true)); parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID)); parms.Add(new LBDbParameter("ItemCode", ItemCode)); parms.Add(new LBDbParameter("K3ItemCode", K3ItemCode)); parms.Add(new LBDbParameter("ItemName", ItemName)); parms.Add(new LBDbParameter("ItemMode", ItemMode)); parms.Add(new LBDbParameter("ItemRate", ItemRate)); parms.Add(new LBDbParameter("UOMID", UOMID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("IsForbid", IsForbid)); parms.Add(new LBDbParameter("ItemPrice", ItemPrice)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" insert into dbo.DbItemBase( ItemTypeID, ItemCode,K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ChangeBy, ChangeTime,ItemPrice) values( @ItemTypeID, @ItemCode,@K3ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description, @IsForbid, @ChangeBy, @ChangeTime,@ItemPrice) set @ItemID = @@identity "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); ItemID.Value = Convert.ToInt64(parms["ItemID"].Value); }
public void UpdateInfraredDeviceConfig(FactoryArgs args, t_String MachineName, t_String SerialName, t_ID HeaderXType, t_ID TailXType, t_ID HeaderYType, t_ID TailYType, t_Bool IsHeaderEffect, t_Bool IsTailEffect) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("SerialName", SerialName)); parms.Add(new LBDbParameter("HeaderXType", HeaderXType)); parms.Add(new LBDbParameter("TailXType", TailXType)); parms.Add(new LBDbParameter("HeaderYType", HeaderYType)); parms.Add(new LBDbParameter("TailYType", TailYType)); parms.Add(new LBDbParameter("IsHeaderEffect", IsHeaderEffect)); parms.Add(new LBDbParameter("IsTailEffect", IsTailEffect)); string strSQL = @" update dbo.DbInfraredDeviceConfig set SerialName = @SerialName, HeaderXType = @HeaderXType, TailXType = @TailXType, HeaderYType = @HeaderYType, TailYType = @TailYType, IsHeaderEffect = @IsHeaderEffect, IsTailEffect = @IsTailEffect where MachineName = @MachineName "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Update(FactoryArgs args, t_BigID ReportTemplateID, t_String ReportTemplateName, t_DTSmall TemplateFileTime, t_ID TemplateSeq, t_String Description, t_Image TemplateData, t_BigID ReportTypeID, t_String PrinterName, t_String MachineName, t_Bool IsManualPaperType, t_String PaperType, t_Bool IsManualPaperSize, t_ID PaperSizeHeight, t_ID PaperSizeWidth, t_Bool IsPaperTransverse, t_ID PrintCount) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ReportTemplateID", ReportTemplateID)); parms.Add(new LBDbParameter("ReportTemplateName", ReportTemplateName)); parms.Add(new LBDbParameter("TemplateSeq", TemplateSeq)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("PrinterName", PrinterName)); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("IsManualPaperType", IsManualPaperType)); parms.Add(new LBDbParameter("PaperType", PaperType)); parms.Add(new LBDbParameter("IsManualPaperSize", IsManualPaperSize)); parms.Add(new LBDbParameter("PaperSizeHeight", PaperSizeHeight)); parms.Add(new LBDbParameter("PaperSizeWidth", PaperSizeWidth)); parms.Add(new LBDbParameter("IsPaperTransverse", IsPaperTransverse)); parms.Add(new LBDbParameter("PrintCount", PrintCount)); parms.Add(new LBDbParameter("TemplateData", TemplateData)); parms.Add(new LBDbParameter("TemplateFileTime", TemplateFileTime)); string strSQL = @" update dbo.DbReportTemplate set ReportTemplateName = @ReportTemplateName, TemplateSeq=@TemplateSeq, Description=@Description, TemplateData = isnull(@TemplateData,TemplateData), TemplateFileTime = (case when @TemplateData is null then TemplateFileTime else @TemplateFileTime end) where ReportTemplateID = @ReportTemplateID if not exists(select 1 from dbo.DbPrinterConfig where ReportTemplateID = @ReportTemplateID and MachineName = @MachineName) begin insert dbo.DbPrinterConfig( ReportTemplateID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse,PrintCount) values(@ReportTemplateID, @PrinterName, @MachineName, @IsManualPaperType, @PaperType, @IsManualPaperSize, @PaperSizeHeight, @PaperSizeWidth, @IsPaperTransverse,@PrintCount) end else begin update dbo.DbPrinterConfig set PrinterName = @PrinterName, IsManualPaperType = @IsManualPaperType, PaperType = @PaperType, IsManualPaperSize = @IsManualPaperSize, PaperSizeHeight = @PaperSizeHeight, PaperSizeWidth = @PaperSizeWidth, IsPaperTransverse = @IsPaperTransverse, PrintCount = @PrintCount where ReportTemplateID = @ReportTemplateID and MachineName = @MachineName end "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Customer_Insert(FactoryArgs args, out t_BigID CustomerID, t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_String K3CustomerCode, t_BigID CustomerTypeID) { CustomerTypeID.NullIfZero(); CarIsLimit.IsNullToZero(); IsDisplayPrice.IsNullToZero(); IsDisplayAmount.IsNullToZero(); IsPrintAmount.IsNullToZero(); IsAllowOverFul.IsNullToZero(); CreditAmount.IsNullToZero(); CreditAmount.IsNullToZero(); CustomerID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CustomerID", CustomerID, true)); parms.Add(new LBDbParameter("CustomerCode", CustomerCode)); parms.Add(new LBDbParameter("CustomerName", CustomerName)); parms.Add(new LBDbParameter("CustomerTypeID", CustomerTypeID)); parms.Add(new LBDbParameter("Contact", Contact)); parms.Add(new LBDbParameter("Phone", Phone)); parms.Add(new LBDbParameter("Address", Address)); parms.Add(new LBDbParameter("CarIsLimit", CarIsLimit)); parms.Add(new LBDbParameter("AmountType", AmountType)); parms.Add(new LBDbParameter("LicenceNum", LicenceNum)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("ReceiveType", ReceiveType)); parms.Add(new LBDbParameter("CreditAmount", CreditAmount)); parms.Add(new LBDbParameter("IsDisplayPrice", IsDisplayPrice)); parms.Add(new LBDbParameter("IsDisplayAmount", IsDisplayAmount)); parms.Add(new LBDbParameter("IsPrintAmount", IsPrintAmount)); parms.Add(new LBDbParameter("IsAllowOverFul", IsAllowOverFul)); parms.Add(new LBDbParameter("IsAllowEmptyIn", IsAllowEmptyIn)); parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("CreateTime", new t_DTSmall(DateTime.Now))); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); parms.Add(new LBDbParameter("AmountNotEnough", AmountNotEnough)); parms.Add(new LBDbParameter("K3CustomerCode", K3CustomerCode)); string strSQL = @" insert into dbo.DbCustomer(CustomerCode,CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, CreateBy, CreateTime, ChangeBy, ChangeTime,IsAllowEmptyIn,AmountNotEnough,K3CustomerCode, CustomerTypeID) values(@CustomerCode, @CustomerName, @Contact, @Phone, @Address, @CarIsLimit, @AmountType, @LicenceNum, @Description, @ReceiveType, @CreditAmount, @IsDisplayPrice, @IsDisplayAmount, @IsPrintAmount, @IsAllowOverFul, @CreateBy, @CreateTime, @ChangeBy, @ChangeTime,@IsAllowEmptyIn,@AmountNotEnough,@K3CustomerCode, @CustomerTypeID) set @CustomerID = @@identity "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); CustomerID.Value = Convert.ToInt64(parms["CustomerID"].Value); }
public void Insert(FactoryArgs args, out t_BigID ReportTemplateID, t_String ReportTemplateName, t_DTSmall TemplateFileTime, t_ID TemplateSeq, t_String Description, t_Image TemplateData, t_BigID ReportTypeID, t_String PrinterName, t_String MachineName, t_Bool IsManualPaperType, t_String PaperType, t_Bool IsManualPaperSize, t_ID PaperSizeHeight, t_ID PaperSizeWidth, t_Bool IsPaperTransverse) { ReportTemplateID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ReportTemplateID", ReportTemplateID, true)); parms.Add(new LBDbParameter("ReportTemplateName", ReportTemplateName)); parms.Add(new LBDbParameter("TemplateFileTime", TemplateFileTime)); parms.Add(new LBDbParameter("TemplateSeq", TemplateSeq)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("TemplateData", TemplateData)); parms.Add(new LBDbParameter("ReportTypeID", ReportTypeID)); parms.Add(new LBDbParameter("PrinterName", PrinterName)); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("IsManualPaperType", IsManualPaperType)); parms.Add(new LBDbParameter("PaperType", PaperType)); parms.Add(new LBDbParameter("IsManualPaperSize", IsManualPaperSize)); parms.Add(new LBDbParameter("PaperSizeHeight", PaperSizeHeight)); parms.Add(new LBDbParameter("PaperSizeWidth", PaperSizeWidth)); parms.Add(new LBDbParameter("IsPaperTransverse", IsPaperTransverse)); string strSQL = @" insert into dbo.DbReportTemplate( ReportTemplateName,ReportTemplateNameExt, TemplateFileTime,TemplateSeq,Description,TemplateData,ReportTypeID) values( @ReportTemplateName,'.frx', @TemplateFileTime,@TemplateSeq,@Description,@TemplateData,@ReportTypeID); select last_insert_rowid() as ReportTemplateID; insert into dbo.DbPrinterConfig( ReportTemplateID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse) values(@ReportTemplateID, @PrinterName, @MachineName, @IsManualPaperType, @PaperType, @IsManualPaperSize, @PaperSizeHeight, @PaperSizeWidth, @IsPaperTransverse); "; if (args.DBType == 1) { strSQL = @" insert into dbo.DbReportTemplate( ReportTemplateName,ReportTemplateNameExt, TemplateFileTime,TemplateSeq,Description,TemplateData,ReportTypeID) values( @ReportTemplateName,'.frx', @TemplateFileTime,@TemplateSeq,@Description,@TemplateData,@ReportTypeID) select @@identity as ReportTemplateID insert into dbo.DbPrinterConfig( ReportTemplateID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse) values(@ReportTemplateID, @PrinterName, @MachineName, @IsManualPaperType, @PaperType, @IsManualPaperSize, @PaperSizeHeight, @PaperSizeWidth, @IsPaperTransverse) "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); ReportTemplateID.SetValueWithObject(parms["ReportTemplateID"].Value); }
public void GetUserPermission(FactoryArgs args, t_BigID UserID, t_String PermissionCode, out t_String PermissionDataName, out t_String PermissionName, out t_Bool HasPermission) { PermissionDataName = new t_String(); PermissionName = new t_String(); bool bolIsAdmin = _DALPermission.VerifyIsAdmin(args, UserID); if (bolIsAdmin)//超级管理员 { HasPermission = new t_Bool(1); } else { _DALPermission.GetUserPermission(args, UserID, PermissionCode, out PermissionDataName, out PermissionName, out HasPermission); } }
public void Customer_Update(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn) { IsAllowEmptyIn.IsNullToZero(); using (DataTable dtCustomer = _DALDbCustomer.GetCustomerByName(args, CustomerID, CustomerName)) { if (dtCustomer.Rows.Count > 0) { throw new Exception("该客户名称已存在!"); } } _DALDbCustomer.Customer_Update(args, CustomerID, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, IsForbid, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn); }
public void Customer_Insert(FactoryArgs args, out t_BigID CustomerID, out t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_String K3CustomerCode, t_BigID CustomerTypeID) { CustomerTypeID.NullIfZero(); CustomerCode = new t_String(); CustomerID = new t_BigID(); IsAllowEmptyIn.IsNullToZero(); using (DataTable dtCustomer = _DALDbCustomer.GetCustomerByName(args, CustomerID, CustomerName)) { if (dtCustomer.Rows.Count > 0) { throw new Exception("该客户名称已存在!"); } } t_String MaxCode; _DALDbCustomer.GetMaxCode(args, out MaxCode); int CodeIndex = MaxCode.Value == null ? 0 : LBConverter.ToInt32(MaxCode.Value.Replace("K", "")); CodeIndex++; if (CodeIndex < 10) { CustomerCode.SetValueWithObject("K000" + CodeIndex.ToString()); } else if (CodeIndex < 100) { CustomerCode.SetValueWithObject("K00" + CodeIndex.ToString()); } else if (CodeIndex < 1000) { CustomerCode.SetValueWithObject("K0" + CodeIndex.ToString()); } else { CustomerCode.SetValueWithObject("K" + CodeIndex.ToString()); } _DALDbCustomer.Customer_Insert(args, out CustomerID, CustomerCode, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID); }
public void GetUserPermission(FactoryArgs args, t_BigID UserID, t_String PermissionCode, out t_String PermissionDataName, out t_String PermissionName, out t_Bool HasPermission) { PermissionDataName = new t_String(); PermissionName = new t_String(); HasPermission = new t_Bool(1); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("UserID", UserID)); parms.Add(new LBDbParameter("PermissionCode", PermissionCode)); parms.Add(new LBDbParameter("PermissionDataName", PermissionDataName, true)); parms.Add(new LBDbParameter("PermissionName", PermissionName, true)); parms.Add(new LBDbParameter("HasPermission", HasPermission, true)); string strSQL = @" declare @PermissionID bigint declare @PermissionDataID bigint set @HasPermission = 0 select top 1 @PermissionID = d.PermissionID,@PermissionDataName = d.PermissionDataName, @PermissionName = p.PermissionName,@PermissionDataID = d.PermissionDataID from dbo.DbPermissionData d inner join dbo.DbPermission p on p.PermissionID = d.PermissionID where PermissionCode= @PermissionCode select @HasPermission = isnull(HasPermission,0) from dbo.DbUserPermission p where PermissionID = @PermissionID and UserID = @UserID if @HasPermission = 0 begin select @HasPermission = isnull(HasPermission,0) from dbo.DbUserPermissionData where PermissionDataID=@PermissionDataID and UserID = @UserID end "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); PermissionDataName.SetValueWithObject(parms["PermissionDataName"].Value); PermissionName.SetValueWithObject(parms["PermissionName"].Value); HasPermission.SetValueWithObject(Convert.ToByte(parms["HasPermission"].Value)); }
public void Insert(FactoryArgs args, out t_BigID SessionID, t_String ClientIP, t_String ClientSerial, out t_Bool IsOverFlow) { SessionID = new t_BigID(0); IsOverFlow = new t_Bool(0); //判断是否超用户数 if (LBEncrypt.UseSessionLimit) { using (DataTable dtSession = _DALSysSession.GetAllSysSession(args)) { if (dtSession.Rows.Count >= LBEncrypt.SessionLimitCount)//在线用户数超过限定数 { IsOverFlow.Value = 1; return; } } } _DALSysSession.Insert(args, out SessionID, ClientIP, ClientSerial); }
public void InsertUpdateInfraredConfig(FactoryArgs args, t_String MachineName, t_String SerialName, t_ID HeaderXType, t_ID TailXType, t_ID HeaderYType, t_ID TailYType, t_Bool IsHeaderEffect, t_Bool IsTailEffect) { IsHeaderEffect.IsNullToZero(); IsTailEffect.IsNullToZero(); using (DataTable dtUserCofnig = _DbInfraredDeviceConfig.GetInfraredConfig(args, MachineName)) { if (dtUserCofnig.Rows.Count > 0) { DataRow drConfig = dtUserCofnig.Rows[0]; _DbInfraredDeviceConfig.UpdateInfraredDeviceConfig(args, MachineName, SerialName, HeaderXType, TailXType, HeaderYType, TailYType, IsHeaderEffect, IsTailEffect); } else { _DbInfraredDeviceConfig.InsertInfraredDeviceConfig(args, MachineName, SerialName, HeaderXType, TailXType, HeaderYType, TailYType, IsHeaderEffect, IsTailEffect); } } }
public void SynchronousK3OutBillStatus(FactoryArgs args, t_BigID SaleCarInBillID, t_Bool IsSynchronousToK3OutBill, t_String SynchronousK3OutBillResult) { IsSynchronousToK3OutBill.IsNullToZero(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID)); parms.Add(new LBDbParameter("IsSynchronousToK3OutBill", IsSynchronousToK3OutBill)); parms.Add(new LBDbParameter("SynchronousK3OutBillResult", SynchronousK3OutBillResult)); parms.Add(new LBDbParameter("SynchronousK3ByOutBill", new t_String(args.LoginName))); string strSQL = @" update dbo.SaleCarInBill set IsSynchronousToK3OutBill = @IsSynchronousToK3OutBill, SynchronousToTimeOutBill = getdate(), SynchronousK3ByOutBill= @SynchronousK3ByOutBill, SynchronousK3OutBillResult = @SynchronousK3OutBillResult where SaleCarInBillID = @SaleCarInBillID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Customer_InsertFromService(FactoryArgs args, out t_BigID CustomerID, out t_String CustomerCode, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_Bool IsForbid, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_Decimal TotalReceivedAmount, t_Decimal SalesReceivedAmount, t_String K3CustomerCode, t_BigID CustomerTypeID) { CustomerID = new t_BigID(); CustomerCode = new t_String(); t_BigID CustomerIDTemp = new t_BigID(); t_String CustomerCodeTemp = new t_String(); DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans) { this.Customer_Insert(argsInTrans, out CustomerIDTemp, out CustomerCodeTemp, CustomerName, Contact, Phone, Address, CarIsLimit, AmountType, LicenceNum, Description, ReceiveType, CreditAmount, IsDisplayPrice, IsDisplayAmount, IsPrintAmount, IsAllowOverFul, IsAllowEmptyIn, AmountNotEnough, K3CustomerCode, CustomerTypeID); _DALDbCustomer.UpdateAmount(argsInTrans, CustomerIDTemp, TotalReceivedAmount, SalesReceivedAmount); }; DBHelper.ExecInTrans(args, exec); CustomerID.Value = CustomerIDTemp.Value; CustomerCode.Value = CustomerCodeTemp.Value; }
public void Update(FactoryArgs args, t_BigID ItemID, t_BigID ItemTypeID, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ItemID", ItemID)); parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID)); parms.Add(new LBDbParameter("K3ItemCode", K3ItemCode)); parms.Add(new LBDbParameter("ItemName", ItemName)); parms.Add(new LBDbParameter("ItemMode", ItemMode)); parms.Add(new LBDbParameter("ItemRate", ItemRate)); parms.Add(new LBDbParameter("UOMID", UOMID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("IsForbid", IsForbid)); parms.Add(new LBDbParameter("ItemPrice", ItemPrice)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" update dbo.DbItemBase set ItemTypeID=@ItemTypeID, K3ItemCode = @K3ItemCode, ItemName=@ItemName, ItemMode=@ItemMode, ItemRate=@ItemRate, UOMID=@UOMID, Description=@Description, IsForbid=@IsForbid, ItemPrice = @ItemPrice, ChangeBy=@ChangeBy, ChangeTime=@ChangeTime where ItemID = @ItemID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Insert(FactoryArgs args, out t_BigID ReportTemplateID, t_String ReportTemplateName, t_DTSmall TemplateFileTime, t_ID TemplateSeq, t_String Description, t_Image TemplateData, t_BigID ReportTypeID, t_String PrinterName, t_String MachineName, t_Bool IsManualPaperType, t_String PaperType, t_Bool IsManualPaperSize, t_ID PaperSizeHeight, t_ID PaperSizeWidth, t_Bool IsPaperTransverse, t_ID PrintCount) { ReportTemplateID = new t_BigID(); using (DataTable dtExistsName = _DALDbReportTemplate.ExistsTemplateName(args, ReportTemplateName, ReportTypeID)) { if (dtExistsName.Rows.Count > 0)//校验上级权限组是否存在 { throw new Exception("该报表名称已存在!"); } else { _DALDbReportTemplate.Insert(args, out ReportTemplateID, ReportTemplateName, TemplateFileTime, TemplateSeq, Description, TemplateData, ReportTypeID, PrinterName, MachineName, IsManualPaperType, PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse, PrintCount); } } }
public void UpdatePermissionData(FactoryArgs args, t_BigID PermissionDataID, t_String PermissionCode, t_String PermissionDataName, t_SmallID PermissionType, t_ID PermissionSPType, t_ID PermissionViewType, t_String LogFieldName, t_ID DetailIndex, t_Bool Forbid) { using (DataTable dtExistsName = _DALPermission.GetPermissionDataByCode(args, PermissionCode)) { if (dtExistsName.Rows.Count == 0)//不存在,可添加 { _DALPermission.UpdatePermissionData(args, PermissionDataID, PermissionCode, PermissionDataName, PermissionType, PermissionSPType, PermissionViewType, LogFieldName, DetailIndex, Forbid); } else { dtExistsName.DefaultView.RowFilter = "PermissionDataID<>" + PermissionDataID.Value; if (dtExistsName.DefaultView.Count == 0) { _DALPermission.UpdatePermissionData(args, PermissionDataID, PermissionCode, PermissionDataName, PermissionType, PermissionSPType, PermissionViewType, LogFieldName, DetailIndex, Forbid); } else { throw new Exception("当前权限分类名称已存在!"); } } } }
public void Insert(FactoryArgs args, out t_BigID CameraConfigID, t_String MachineName, t_String IPAddress1, t_ID Port1, t_String Account1, t_String Password1, t_Bool UseCamera1, t_String IPAddress2, t_ID Port2, t_String Account2, t_String Password2, t_Bool UseCamera2, t_String IPAddress3, t_ID Port3, t_String Account3, t_String Password3, t_Bool UseCamera3, t_String IPAddress4, t_ID Port4, t_String Account4, t_String Password4, t_Bool UseCamera4) { CameraConfigID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CameraConfigID", CameraConfigID, true)); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("IPAddress1", IPAddress1)); parms.Add(new LBDbParameter("Port1", Port1)); parms.Add(new LBDbParameter("Account1", Account1)); parms.Add(new LBDbParameter("Password1", Password1)); parms.Add(new LBDbParameter("IPAddress2", IPAddress2)); parms.Add(new LBDbParameter("Port2", Port2)); parms.Add(new LBDbParameter("Account2", Account2)); parms.Add(new LBDbParameter("Password2", Password2)); parms.Add(new LBDbParameter("IPAddress3", IPAddress3)); parms.Add(new LBDbParameter("Port3", Port3)); parms.Add(new LBDbParameter("Account3", Account3)); parms.Add(new LBDbParameter("Password3", Password3)); parms.Add(new LBDbParameter("IPAddress4", IPAddress4)); parms.Add(new LBDbParameter("Port4", Port4)); parms.Add(new LBDbParameter("Account4", Account4)); parms.Add(new LBDbParameter("Password4", Password4)); parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("UseCamera1", UseCamera1)); parms.Add(new LBDbParameter("UseCamera2", UseCamera2)); parms.Add(new LBDbParameter("UseCamera3", UseCamera3)); parms.Add(new LBDbParameter("UseCamera4", UseCamera4)); string strSQL = @" insert into DbCameraConfig( MachineName, IPAddress1, Port1, Account1, Password1, IPAddress2, Port2, Account2, Password2, IPAddress3, Port3, Account3, Password3, IPAddress4, Port4, Account4, Password4, ChangedBy, ChangeTime, UseCamera1,UseCamera2,UseCamera3,UseCamera4) values( @MachineName, @IPAddress1, @Port1, @Account1, @Password1, @IPAddress2, @Port2, @Account2, @Password2, @IPAddress3, @Port3, @Account3, @Password3, @IPAddress4, @Port4, @Account4, @Password4, @ChangedBy, datetime('now','localtime'), @UseCamera1,@UseCamera2,@UseCamera3,@UseCamera4); select last_insert_rowid() as CameraConfigID; "; if (args.DBType == 1) { strSQL = @" insert into DbCameraConfig( MachineName, IPAddress1, Port1, Account1, Password1, IPAddress2, Port2, Account2, Password2, IPAddress3, Port3, Account3, Password3, IPAddress4, Port4, Account4, Password4, ChangedBy, ChangeTime, UseCamera1,UseCamera2,UseCamera3,UseCamera4) values( @MachineName, @IPAddress1, @Port1, @Account1, @Password1, @IPAddress2, @Port2, @Account2, @Password2, @IPAddress3, @Port3, @Account3, @Password3, @IPAddress4, @Port4, @Account4, @Password4, @ChangedBy, getdate(), @UseCamera1,@UseCamera2,@UseCamera3,@UseCamera4) select @@identity as CameraConfigID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); CameraConfigID.SetValueWithObject(parms["CameraConfigID"].Value); }
public void Update(FactoryArgs args, t_BigID CameraConfigID, t_String MachineName, t_String IPAddress1, t_ID Port1, t_String Account1, t_String Password1, t_Bool UseCamera1, t_String IPAddress2, t_ID Port2, t_String Account2, t_String Password2, t_Bool UseCamera2, t_String IPAddress3, t_ID Port3, t_String Account3, t_String Password3, t_Bool UseCamera3, t_String IPAddress4, t_ID Port4, t_String Account4, t_String Password4, t_Bool UseCamera4) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CameraConfigID", CameraConfigID)); parms.Add(new LBDbParameter("MachineName", MachineName)); parms.Add(new LBDbParameter("IPAddress1", IPAddress1)); parms.Add(new LBDbParameter("Port1", Port1)); parms.Add(new LBDbParameter("Account1", Account1)); parms.Add(new LBDbParameter("Password1", Password1)); parms.Add(new LBDbParameter("IPAddress2", IPAddress2)); parms.Add(new LBDbParameter("Port2", Port2)); parms.Add(new LBDbParameter("Account2", Account2)); parms.Add(new LBDbParameter("Password2", Password2)); parms.Add(new LBDbParameter("IPAddress3", IPAddress3)); parms.Add(new LBDbParameter("Port3", Port3)); parms.Add(new LBDbParameter("Account3", Account3)); parms.Add(new LBDbParameter("Password3", Password3)); parms.Add(new LBDbParameter("IPAddress4", IPAddress4)); parms.Add(new LBDbParameter("Port4", Port4)); parms.Add(new LBDbParameter("Account4", Account4)); parms.Add(new LBDbParameter("Password4", Password4)); parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("UseCamera1", UseCamera1)); parms.Add(new LBDbParameter("UseCamera2", UseCamera2)); parms.Add(new LBDbParameter("UseCamera3", UseCamera3)); parms.Add(new LBDbParameter("UseCamera4", UseCamera4)); string strSQL = @" update dbo.DbCameraConfig set MachineName=@MachineName, IPAddress1=@IPAddress1, Port1=@Port1, Account1=@Account1, Password1=@Password1, IPAddress2=@IPAddress2, Port2=@Port2, Account2=@Account2, Password2=@Password2, IPAddress3=@IPAddress3, Port3=@Port3, Account3=@Account3, Password3=@Password3, IPAddress4=@IPAddress4, Port4=@Port4, Account4=@Account4, Password4=@Password4, ChangedBy=@ChangedBy, ChangeTime=datetime('now','localtime'), UseCamera1 = @UseCamera1, UseCamera2 = @UseCamera2, UseCamera3 = @UseCamera3, UseCamera4 = @UseCamera4 where CameraConfigID = @CameraConfigID "; if (args.DBType == 1) { strSQL = @" update dbo.DbCameraConfig set MachineName=@MachineName, IPAddress1=@IPAddress1, Port1=@Port1, Account1=@Account1, Password1=@Password1, IPAddress2=@IPAddress2, Port2=@Port2, Account2=@Account2, Password2=@Password2, IPAddress3=@IPAddress3, Port3=@Port3, Account3=@Account3, Password3=@Password3, IPAddress4=@IPAddress4, Port4=@Port4, Account4=@Account4, Password4=@Password4, ChangedBy=@ChangedBy, ChangeTime=getdate(), UseCamera1 = @UseCamera1, UseCamera2 = @UseCamera2, UseCamera3 = @UseCamera3, UseCamera4 = @UseCamera4 where CameraConfigID = @CameraConfigID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void InsertAndUpdate(FactoryArgs args, t_BigID CameraConfigID, t_String MachineName, t_String IPAddress1, t_ID Port1, t_String Account1, t_String Password1, t_Bool UseCamera1, t_String IPAddress2, t_ID Port2, t_String Account2, t_String Password2, t_Bool UseCamera2, t_String IPAddress3, t_ID Port3, t_String Account3, t_String Password3, t_Bool UseCamera3, t_String IPAddress4, t_ID Port4, t_String Account4, t_String Password4, t_Bool UseCamera4) { using (DataTable dtExists = _DALDbCameraConfig.VerifyExists(args, MachineName)) { if (dtExists.Rows.Count == 0) { _DALDbCameraConfig.Insert(args, out CameraConfigID, MachineName, IPAddress1, Port1, Account1, Password1, UseCamera1, IPAddress2, Port2, Account2, Password2, UseCamera2, IPAddress3, Port3, Account3, Password3, UseCamera3, IPAddress4, Port4, Account4, Password4, UseCamera4); } else { CameraConfigID = new t_BigID(dtExists.Rows[0]["CameraConfigID"]); _DALDbCameraConfig.Update(args, CameraConfigID, MachineName, IPAddress1, Port1, Account1, Password1, UseCamera1, IPAddress2, Port2, Account2, Password2, UseCamera2, IPAddress3, Port3, Account3, Password3, UseCamera3, IPAddress4, Port4, Account4, Password4, UseCamera4); } } }
public void Customer_Update(FactoryArgs args, t_BigID CustomerID, t_String CustomerName, t_String Contact, t_String Phone, t_String Address, t_Bool CarIsLimit, t_ID AmountType, t_String LicenceNum, t_String Description, t_ID ReceiveType, t_Decimal CreditAmount, t_Bool IsDisplayPrice, t_Bool IsDisplayAmount, t_Bool IsPrintAmount, t_Bool IsAllowOverFul, t_Bool IsAllowEmptyIn, t_Decimal AmountNotEnough, t_String K3CustomerCode, t_BigID CustomerTypeID) { CustomerTypeID.NullIfZero(); CarIsLimit.IsNullToZero(); IsDisplayPrice.IsNullToZero(); IsDisplayAmount.IsNullToZero(); IsPrintAmount.IsNullToZero(); IsAllowOverFul.IsNullToZero(); CreditAmount.IsNullToZero(); CreditAmount.IsNullToZero(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CustomerID", CustomerID)); parms.Add(new LBDbParameter("CustomerName", CustomerName)); parms.Add(new LBDbParameter("CustomerTypeID", CustomerTypeID)); parms.Add(new LBDbParameter("Contact", Contact)); parms.Add(new LBDbParameter("Phone", Phone)); parms.Add(new LBDbParameter("Address", Address)); parms.Add(new LBDbParameter("CarIsLimit", CarIsLimit)); parms.Add(new LBDbParameter("AmountType", AmountType)); parms.Add(new LBDbParameter("LicenceNum", LicenceNum)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("ReceiveType", ReceiveType)); parms.Add(new LBDbParameter("CreditAmount", CreditAmount)); parms.Add(new LBDbParameter("IsDisplayPrice", IsDisplayPrice)); parms.Add(new LBDbParameter("IsDisplayAmount", IsDisplayAmount)); parms.Add(new LBDbParameter("IsPrintAmount", IsPrintAmount)); parms.Add(new LBDbParameter("IsAllowOverFul", IsAllowOverFul)); parms.Add(new LBDbParameter("IsAllowEmptyIn", IsAllowEmptyIn)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); parms.Add(new LBDbParameter("AmountNotEnough", AmountNotEnough)); parms.Add(new LBDbParameter("K3CustomerCode", K3CustomerCode)); string strSQL = @" update dbo.DbCustomer set CustomerName = @CustomerName, Contact=@Contact, Phone=@Phone, Address=@Address, CarIsLimit=@CarIsLimit, AmountType=@AmountType, LicenceNum=@LicenceNum, Description=@Description, ReceiveType=@ReceiveType, CreditAmount=@CreditAmount, IsDisplayPrice=@IsDisplayPrice, IsDisplayAmount=@IsDisplayAmount, IsPrintAmount=@IsPrintAmount, IsAllowOverFul=@IsAllowOverFul, ChangeBy=@ChangeBy, ChangeTime=@ChangeTime, IsAllowEmptyIn = @IsAllowEmptyIn, AmountNotEnough = @AmountNotEnough, K3CustomerCode = @K3CustomerCode, CustomerTypeID = @CustomerTypeID where CustomerID = @CustomerID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void Insert(FactoryArgs args, out t_BigID BackUpConfigID, t_ID BackUpType, t_ID BackUpWeek, t_ID BackUpHour, t_ID BackUpMinu, t_Bool IsEffect, t_ID BackUpFileMaxNum, t_String BackUpPath, t_String BackUpName) { BackUpConfigID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("BackUpConfigID", BackUpConfigID, true)); parms.Add(new LBDbParameter("BackUpType", BackUpType)); parms.Add(new LBDbParameter("BackUpWeek", BackUpWeek)); parms.Add(new LBDbParameter("BackUpHour", BackUpHour)); parms.Add(new LBDbParameter("BackUpMinu", BackUpMinu)); parms.Add(new LBDbParameter("IsEffect", IsEffect)); parms.Add(new LBDbParameter("BackUpFileMaxNum", BackUpFileMaxNum)); parms.Add(new LBDbParameter("BackUpPath", BackUpPath)); parms.Add(new LBDbParameter("BackUpName", BackUpName)); parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName))); string strSQL = @" insert into dbo.DbBackUpConfig( BackUpType, BackUpWeek, BackUpHour, BackUpMinu, IsEffect, BackUpFileMaxNum, ChangedBy, ChangedTime, BackUpPath, BackUpName) values( @BackUpType, @BackUpWeek, @BackUpHour, @BackUpMinu, @IsEffect, @BackUpFileMaxNum, @ChangedBy, datetime('now','localtime'), @BackUpPath, @BackUpName); select last_insert_rowid() as BackUpConfigID; "; if (args.DBType == 1) { strSQL = @" insert into dbo.DbBackUpConfig( BackUpType, BackUpWeek, BackUpHour, BackUpMinu, IsEffect, BackUpFileMaxNum, ChangedBy, ChangedTime, BackUpPath, BackUpName) values( @BackUpType, @BackUpWeek, @BackUpHour, @BackUpMinu, @IsEffect, @BackUpFileMaxNum, @ChangedBy, getdate(), @BackUpPath, @BackUpName) select @@identity as BackUpConfigID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); BackUpConfigID.SetValueWithObject(parms["BackUpConfigID"].Value); }
public void Update(FactoryArgs args, t_BigID BackUpConfigID, t_ID BackUpType, t_ID BackUpWeek, t_ID BackUpHour, t_ID BackUpMinu, t_Bool IsEffect, t_ID BackUpFileMaxNum, t_String BackUpPath, t_String BackUpName) { _DALDbBackUpConfig.Update(args, BackUpConfigID, BackUpType, BackUpWeek, BackUpHour, BackUpMinu, IsEffect, BackUpFileMaxNum, BackUpPath, BackUpName); }
public void InsertPermissionData(FactoryArgs args, out t_BigID PermissionDataID, t_BigID PermissionID, t_String PermissionCode, t_String PermissionDataName, t_SmallID PermissionType, t_ID PermissionSPType, t_ID PermissionViewType, t_String LogFieldName, t_ID DetailIndex, t_Bool Forbid) { PermissionDataID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("PermissionDataID", PermissionDataID, true)); parms.Add(new LBDbParameter("PermissionID", PermissionID)); parms.Add(new LBDbParameter("PermissionCode", PermissionCode)); parms.Add(new LBDbParameter("PermissionDataName", PermissionDataName)); parms.Add(new LBDbParameter("PermissionType", PermissionType)); parms.Add(new LBDbParameter("PermissionSPType", PermissionSPType)); parms.Add(new LBDbParameter("PermissionViewType", PermissionViewType)); parms.Add(new LBDbParameter("LogFieldName", LogFieldName)); parms.Add(new LBDbParameter("DetailIndex", DetailIndex)); parms.Add(new LBDbParameter("Forbid", Forbid)); string strSQL = @" insert into dbo.DbPermissionData(PermissionID, PermissionCode, PermissionDataName, PermissionType, PermissionSPType, PermissionViewType, LogFieldName,DetailIndex, Forbid) values(@PermissionID, @PermissionCode, @PermissionDataName, @PermissionType, @PermissionSPType, @PermissionViewType,@LogFieldName,@DetailIndex, @Forbid) set @PermissionDataID = @@identity "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); PermissionDataID.SetValueWithObject(parms["PermissionDataID"].Value); }
public void Update(FactoryArgs args, t_BigID BackUpConfigID, t_ID BackUpType, t_ID BackUpWeek, t_ID BackUpHour, t_ID BackUpMinu, t_Bool IsEffect, t_ID BackUpFileMaxNum, t_String BackUpPath, t_String BackUpName) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("BackUpConfigID", BackUpConfigID)); parms.Add(new LBDbParameter("BackUpType", BackUpType)); parms.Add(new LBDbParameter("BackUpWeek", BackUpWeek)); parms.Add(new LBDbParameter("BackUpHour", BackUpHour)); parms.Add(new LBDbParameter("BackUpMinu", BackUpMinu)); parms.Add(new LBDbParameter("IsEffect", IsEffect)); parms.Add(new LBDbParameter("BackUpFileMaxNum", BackUpFileMaxNum)); parms.Add(new LBDbParameter("BackUpPath", BackUpPath)); parms.Add(new LBDbParameter("BackUpName", BackUpName)); parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName))); string strSQL = @" update dbo.DbBackUpConfig set BackUpType=@BackUpType, BackUpWeek=@BackUpWeek, BackUpHour=@BackUpHour, BackUpMinu=@BackUpMinu, IsEffect=@IsEffect, BackUpFileMaxNum=@BackUpFileMaxNum, ChangedBy=@ChangedBy, ChangedTime=datetime('now','localtime'), BackUpPath=@BackUpPath, BackUpName=@BackUpName where BackUpConfigID = @BackUpConfigID "; if (args.DBType == 1) { strSQL = @" update dbo.DbBackUpConfig set BackUpType=@BackUpType, BackUpWeek=@BackUpWeek, BackUpHour=@BackUpHour, BackUpMinu=@BackUpMinu, IsEffect=@IsEffect, BackUpFileMaxNum=@BackUpFileMaxNum, ChangedBy=@ChangedBy, ChangedTime=getdate(), BackUpPath=@BackUpPath, BackUpName=@BackUpName where BackUpConfigID = @BackUpConfigID "; } DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
public void UpdatePermissionData(FactoryArgs args, t_BigID PermissionDataID, t_String PermissionCode, t_String PermissionDataName, t_SmallID PermissionType, t_ID PermissionSPType, t_ID PermissionViewType, t_String LogFieldName, t_ID DetailIndex, t_Bool Forbid) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("PermissionDataID", PermissionDataID)); parms.Add(new LBDbParameter("PermissionCode", PermissionCode)); parms.Add(new LBDbParameter("PermissionDataName", PermissionDataName)); parms.Add(new LBDbParameter("PermissionType", PermissionType)); parms.Add(new LBDbParameter("PermissionSPType", PermissionSPType)); parms.Add(new LBDbParameter("PermissionViewType", PermissionViewType)); parms.Add(new LBDbParameter("LogFieldName", LogFieldName)); parms.Add(new LBDbParameter("DetailIndex", DetailIndex)); parms.Add(new LBDbParameter("Forbid", Forbid)); string strSQL = @" update dbo.DbPermissionData set PermissionCode = @PermissionCode, PermissionDataName = @PermissionDataName, PermissionType = @PermissionType, PermissionSPType = @PermissionSPType, LogFieldName = @LogFieldName, PermissionViewType = @PermissionViewType, DetailIndex = @DetailIndex, Forbid = @Forbid where PermissionDataID = @PermissionDataID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }