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();
using (DataTable dtPermission = _DALPermission.GetPermission(args, PermissionID))
{
if (dtPermission.Rows.Count > 0)//校验上级权限组是否存在
{
using (DataTable dtExistsName = _DALPermission.GetPermissionDataByCode(args, PermissionCode))
{
if (dtExistsName.Rows.Count == 0)//不存在，可添加
{
_DALPermission.InsertPermissionData(args, out PermissionDataID, PermissionID,
PermissionCode, PermissionDataName, PermissionType, PermissionSPType, PermissionViewType,
LogFieldName, DetailIndex, Forbid);
}
else
{
throw new Exception("当前权限分类名称已存在！");
}
}
}
else
{
throw new Exception("上级权限分类不存在，无法在该权限分类下级添加权限！");
}
}
}
public void Insert(FactoryArgs args,
out t_BigID DescriptionID, t_String Description)
{
DescriptionID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("DescriptionID", DescriptionID, true));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
string strSQL = @"
insert into dbo.DbDescription( Description,ChangedBy, ChangeTime)
values( @Description, @ChangedBy, datetime('now','localtime'));
select last_insert_rowid() as DescriptionID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.DbDescription( Description,ChangedBy, ChangeTime)
values( @Description, @ChangedBy, getdate())
select @@identity as DescriptionID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
DescriptionID.SetValueWithObject(parms["DescriptionID"].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 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 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 Update(FactoryArgs args, t_BigID ModifyBillHeaderID, t_BigID CustomerID,
t_DTSmall BillDate, t_DTSmall EffectDate, t_String Description)
{
using (DataTable dtCustomer = _DALModifyBillHeader.GetCustomerByID(args, CustomerID))
{
if (dtCustomer.Rows.Count == 0)
{
throw new Exception("所选客户不存在，保存不成功！");
}
}
using (DataTable dtHeader = _DALModifyBillHeader.GetModifyBillHeader(args, ModifyBillHeaderID))
{
DataRow drHeader = dtHeader.Rows[0];
bool bolIsApprove = LBConverter.ToBoolean(drHeader["IsApprove"]);
bool bolIsCancel = LBConverter.ToBoolean(drHeader["IsCancel"]);
if (bolIsApprove)
{
throw new Exception("该调价单已审核，无法保存修改！");
}
if (bolIsCancel)
{
throw new Exception("该调价单已作废，无法保存修改！");
}
}
_DALModifyBillHeader.Update(args, ModifyBillHeaderID, CustomerID, BillDate, EffectDate, Description);
}
public void Update(FactoryArgs args, t_BigID ModifyBillHeaderID, t_BigID CustomerID,
t_DTSmall BillDate, t_DTSmall EffectDate, t_String Description)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ModifyBillHeaderID", ModifyBillHeaderID));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("EffectDate", EffectDate));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
update dbo.ModifyBillHeader
set CustomerID = @CustomerID,
BillDate = @BillDate,
EffectDate = @EffectDate,
Description = @Description,
ChangeBy = @ChangeBy,
ChangeTime = @ChangeTime
where ModifyBillHeaderID = @ModifyBillHeaderID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
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 GetConfigValue(FactoryArgs args, t_String SysConfigFieldName, out t_String SysConfigValue)
{
SysConfigValue = new t_String("");
t_String SysConfigDefaultValue = new t_String("");
using (DataTable dtConfig = _DALDbSysConfig.GetDbSysConfigField(args, SysConfigFieldName))
{
if (dtConfig.Rows.Count == 0)
{
throw new Exception("该系统设置无效！");
}
else
{
DataRow drConfig = dtConfig.Rows[0];
SysConfigDefaultValue.SetValueWithObject(drConfig["SysConfigDefaultValue"]);
}
}
using (DataTable dtConfigValue = _DALDbSysConfig.GetDbSysConfigValue(args, SysConfigFieldName))
{
if (dtConfigValue.Rows.Count == 0)
{
SysConfigValue.Value = SysConfigDefaultValue.Value;
}
else
{
DataRow drConfig = dtConfigValue.Rows[0];
SysConfigValue.SetValueWithObject(drConfig["SysConfigValue"]);
}
}
}
public void ReadTopBillDateByCardCode(FactoryArgs args, t_String CardCode,
out t_String BillDate)
{
BillDate = new t_String("");
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CardCode", CardCode));
string strSQL = @"
select BillDate
from dbo.SaleCarInBill
where CardCode = @CardCode
order by BillDate desc limit 1
";
if (args.DBType == 1)
{
strSQL = @"
select top 1 BillDate
from dbo.SaleCarInBill
where CardCode = @CardCode
order by BillDate desc
";
}
DataTable dt = DBHelper.ExecuteQuery(args, strSQL, parms);
if (dt.Rows.Count > 0)
{
BillDate.Value = dt.Rows[0]["BillDate"].ToString().TrimEnd();
}
}
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 Update(FactoryArgs args, t_BigID ModifyBillDetailID, t_BigID ItemID, t_BigID CarID,
t_Decimal Price, t_ID CalculateType, t_BigID UOMID, t_String Description, t_Decimal MaterialPrice, t_Decimal FarePrice,
t_Decimal TaxPrice, t_Decimal BrokerPrice)
{
_DALModifyBillDetail.Update(args, ModifyBillDetailID, ItemID, CarID, Price, CalculateType, UOMID, Description,
MaterialPrice, FarePrice, TaxPrice, BrokerPrice);
}
public void InsertPermission(FactoryArgs args, out t_BigID PermissionID, t_String PermissionName,
t_BigID ParentPermissionID)
{
PermissionID = new t_BigID();
using (DataTable dtPermission = _DALPermission.GetPermission(args, ParentPermissionID))
{
if (ParentPermissionID.Value == null || dtPermission.Rows.Count > 0)//校验上级权限组是否存在
{
using (DataTable dtExistsName = _DALPermission.GetPermissionByName(args, ParentPermissionID, PermissionName))
{
if (dtExistsName.Rows.Count == 0)//不存在，可添加
{
_DALPermission.InsertPermission(args, out PermissionID, ParentPermissionID, PermissionName);
}
else
{
throw new Exception("当前权限分类名称已存在！");
}
}
}
else
{
throw new Exception("上级权限分类不存在，无法在该权限分类下级添加权限分类！");
}
}
}
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 CardID, t_String CardCode, t_String CardName)
{
CardID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CardID", CardID, true));
parms.Add(new LBDbParameter("CardCode", CardCode));
parms.Add(new LBDbParameter("CardName", CardName));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
string strSQL = @"
insert into DbCard( CardCode, CardName, ChangeBy, ChangeTime)
values( @CardCode, @CardName,@ChangeBy,datetime('now','localtime'));
select last_insert_rowid() as CardID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into DbCard( CardCode, CardName, ChangeBy, ChangeTime)
values( @CardCode, @CardName,@ChangeBy,getdate()
select @@identity as CardID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
CardID.Value = Convert.ToInt64(parms["CardID"].Value);
}
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, getdate(), @BackUpPath, @BackUpName)
set @BackUpConfigID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
BackUpConfigID.SetValueWithObject(parms["BackUpConfigID"].Value);
}
public void Update(FactoryArgs args, t_BigID CardID, t_String CardCode, t_String CardName)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CardID", CardID));
parms.Add(new LBDbParameter("CardCode", CardCode));
parms.Add(new LBDbParameter("CardName", CardName));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
string strSQL = @"
update DbCard
set CardCode = @CardCode,
CardName = @CardName,
ChangeBy= @ChangeBy,
ChangeTime = datetime('now','localtime')
where CardID = @CardID
";
if (args.DBType == 1)
{
strSQL = @"
update DbCard
set CardCode = @CardCode,
CardName = @CardName,
ChangeBy= @ChangeBy,
ChangeTime = getdate()
where CardID = @CardID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
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=getdate(),
BackUpPath=@BackUpPath,
BackUpName=@BackUpName
where BackUpConfigID = @BackUpConfigID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Insert(FactoryArgs args, out t_BigID ModifyBillHeaderID, t_BigID BillTypeID, t_BigID CustomerID, t_String ModifyBillCode,
t_DTSmall BillDate, t_DTSmall EffectDate, t_String Description)
{
ModifyBillHeaderID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ModifyBillHeaderID", ModifyBillHeaderID, true));
parms.Add(new LBDbParameter("BillTypeID", BillTypeID));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ModifyBillCode", ModifyBillCode));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("EffectDate", EffectDate));
parms.Add(new LBDbParameter("Description", Description));
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)));
string strSQL = @"
insert into dbo.ModifyBillHeader(CustomerID,BillTypeID, ModifyBillCode, BillDate, EffectDate, Description,
IsApprove,IsCancel,CreateBy, CreateTime, ChangeBy, ChangeTime)
values( @CustomerID,@BillTypeID, @ModifyBillCode, @BillDate, @EffectDate, @Description,
0, 0, @CreateBy, @CreateTime, @ChangeBy, @ChangeTime)
set @ModifyBillHeaderID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ModifyBillHeaderID.Value = Convert.ToInt64(parms["ModifyBillHeaderID"].Value);
}
public void Insert(FactoryArgs args, out t_BigID UserID, t_String LoginName, t_String UserPassword, t_String UserName,
t_ID UserType, t_ID UserSex)
{
UserID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("UserID", UserID, true));
parms.Add(new LBDbParameter("LoginName", LoginName));
parms.Add(new LBDbParameter("UserPassword", UserPassword));
parms.Add(new LBDbParameter("UserName", UserName));
parms.Add(new LBDbParameter("UserType", UserType));
parms.Add(new LBDbParameter("UserSex", UserSex));
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.DBUser( LoginName, UserPassword, ForbidLogin, IsManager, ChangeBy, ChangeTime, UserType, UserName, UserSex)
values( @LoginName, @UserPassword, 0, 0, @ChangeBy, @ChangeTime, @UserType, @UserName, @UserSex)
set @UserID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
UserID.Value = Convert.ToInt64(parms["UserID"].Value);
}
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 Update(FactoryArgs args, t_BigID UserID, t_String LoginName, t_String UserPassword, t_String UserName,
t_ID UserType, t_ID UserSex)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("UserID", UserID));
parms.Add(new LBDbParameter("LoginName", LoginName));
parms.Add(new LBDbParameter("UserPassword", UserPassword));
parms.Add(new LBDbParameter("UserName", UserName));
parms.Add(new LBDbParameter("UserType", UserType));
parms.Add(new LBDbParameter("UserSex", UserSex));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
update dbo.DBUser
set LoginName=@LoginName,
--UserPassword=@UserPassword,
ForbidLogin=0,
ChangeBy=@ChangeBy,
ChangeTime=@ChangeTime,
UserType=@UserType,
UserName=@UserName,
UserSex=@UserSex
where UserID = @UserID
";
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 Insert(FactoryArgs args, out t_BigID SysViewTypeID, t_String SysViewType, t_String SysViewName)
{
SysViewTypeID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SysViewTypeID", SysViewTypeID, true));
parms.Add(new LBDbParameter("SysViewType", SysViewType));
parms.Add(new LBDbParameter("SysViewName", SysViewName));
string strSQL = @"
insert into dbo.SysViewType( SysViewType, SysViewName)
values( @SysViewType, @SysViewName)
select last_insert_rowid() as SysViewTypeID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.SysViewType( SysViewType, SysViewName)
values( @SysViewType, @SysViewName)
select @@identity as SysViewTypeID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SysViewTypeID.SetValueWithObject(Convert.ToInt64(parms["SysViewTypeID"].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 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 DescriptionID, t_String Description)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("DescriptionID", DescriptionID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.DbDescription
set Description=@Description,
ChangedBy=@ChangedBy,
ChangeTime=datetime('now','localtime')
where DescriptionID = @DescriptionID
";
if (args.DBType == 1)
{
strSQL = @"
update dbo.DbDescription
set Description=@Description,
ChangedBy=@ChangedBy,
ChangeTime=getdate()
where DescriptionID = @DescriptionID
";
}
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);
}
public void Update(FactoryArgs args, t_BigID SysViewTypeID, t_String SysViewType, t_String SysViewName)
{
using (DataTable dtView = _DALSysViewType.VerifyExists(args, SysViewType, SysViewName))
{
if (dtView.Rows.Count > 0)
{
foreach (DataRow drView in dtView.Rows)
{
long lSysViewTypeID = Convert.ToInt64(drView["SysViewTypeID"]);
string strSysViewType = drView["SysViewType"].ToString().TrimEnd();
string strSysViewName = drView["SysViewName"].ToString().TrimEnd();
if (SysViewTypeID.Value != lSysViewTypeID)
{
if (SysViewType.Value == strSysViewType)
{
throw new Exception("该视图号已存在！");
}
if (SysViewName.Value == strSysViewName)
{
throw new Exception("该视图名称已存在！");
}
}
}
}
}
_DALSysViewType.Update(args, SysViewTypeID, SysViewType, SysViewName);
}
public void UpdatePermission(FactoryArgs args, t_BigID PermissionID, t_String PermissionName,
t_BigID ParentPermissionID)
{
using (DataTable dtPermission = _DALPermission.GetPermission(args, ParentPermissionID))
{
if (ParentPermissionID.Value == null || dtPermission.Rows.Count > 0)//校验上级权限组是否存在
{
using (DataTable dtExistsName = _DALPermission.GetPermissionByName(args, ParentPermissionID, PermissionName))
{
if (dtExistsName.Rows.Count == 0)//不存在，可添加
{
_DALPermission.UpdatePermission(args, PermissionID, PermissionName);
}
else
{
dtExistsName.DefaultView.RowFilter = "PermissionID<>" + PermissionID.Value;
if (dtExistsName.DefaultView.Count == 0)
{
_DALPermission.UpdatePermission(args, PermissionID, PermissionName);
}
else
{
throw new Exception("当前权限分类名称已存在！");
}
}
}
}
else
{
throw new Exception("上级权限分类不存在，无法在该权限分类下级添加权限分类！");
}
}
}
