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