public void InsertField(FactoryArgs args, out t_BigID ReportViewFieldID, t_BigID ReportViewID,
t_String FieldName, t_ID FieldType, t_String FieldText)
{
ReportViewFieldID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReportViewFieldID", ReportViewFieldID, true));
parms.Add(new LBDbParameter("ReportViewID", ReportViewID));
parms.Add(new LBDbParameter("FieldName", FieldName));
parms.Add(new LBDbParameter("FieldType", FieldType));
parms.Add(new LBDbParameter("FieldText", FieldText));
string strSQL = @"
insert dbo.DbReportViewField( ReportViewID,FieldName,FieldType,FieldText)
values(@ReportViewID,@FieldName,@FieldType,@FieldText);
select last_insert_rowid() as ReportViewFieldID;
";
if (args.DBType == 1)
{
strSQL = @"
insert dbo.DbReportViewField( ReportViewID,FieldName,FieldType,FieldText)
values(@ReportViewID,@FieldName,@FieldType,@FieldText)
select @@identity as ReportViewFieldID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReportViewFieldID.SetValueWithObject(parms["ReportViewFieldID"].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=getdate(),
BackUpPath=@BackUpPath,
BackUpName=@BackUpName
where BackUpConfigID = @BackUpConfigID
";
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)
{
_DALDbBackUpConfig.Update(args, BackUpConfigID, BackUpType, BackUpWeek, BackUpHour, BackUpMinu, IsEffect, BackUpFileMaxNum,
BackUpPath, BackUpName);
}
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 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 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 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 InsertUserType(FactoryArgs args,
out t_BigID WeightDeviceUserTypeID, t_ID WeightDeviceType, t_String MachineName, t_String SerialName)
{
WeightDeviceUserTypeID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("WeightDeviceUserTypeID", WeightDeviceUserTypeID, true));
parms.Add(new LBDbParameter("WeightDeviceType", WeightDeviceType));
parms.Add(new LBDbParameter("MachineName", MachineName));
parms.Add(new LBDbParameter("SerialName", SerialName));
string strSQL = @"
insert into dbo.DbWeightDeviceUserType( WeightDeviceType,MachineName,SerialName )
values( @WeightDeviceType, @MachineName,@SerialName);
select last_insert_rowid() as WeightDeviceUserTypeID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.DbWeightDeviceUserType( WeightDeviceType,MachineName,SerialName )
values( @WeightDeviceType, @MachineName,@SerialName)
select @@identity as WeightDeviceUserTypeID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
WeightDeviceUserTypeID.SetValueWithObject(parms["WeightDeviceUserTypeID"].Value);
}
public void InsertUserCnofig(FactoryArgs args,
t_BigID WeightDeviceUserTypeID, t_ID DeviceBoTeLv, t_ID DeviceShuJuWei,
t_ID DeviceTingZhiWei, t_ID DeviceZhenChangDu, t_ID DeviceZhenQiShiBiaoShi, t_ID DeviceZhenChuLiFangShi, t_ID DeviceChongFuWeiZhi,
t_ID DeviceChongFuChangDu, t_ID DeviceXiaoShuWei, t_ID DeviceFuHaoKaiShi)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("WeightDeviceUserTypeID", WeightDeviceUserTypeID));
parms.Add(new LBDbParameter("DeviceBoTeLv", DeviceBoTeLv));
parms.Add(new LBDbParameter("DeviceShuJuWei", DeviceShuJuWei));
parms.Add(new LBDbParameter("DeviceTingZhiWei", DeviceTingZhiWei));
parms.Add(new LBDbParameter("DeviceZhenChangDu", DeviceZhenChangDu));
parms.Add(new LBDbParameter("DeviceZhenQiShiBiaoShi", DeviceZhenQiShiBiaoShi));
parms.Add(new LBDbParameter("DeviceZhenChuLiFangShi", DeviceZhenChuLiFangShi));
parms.Add(new LBDbParameter("DeviceChongFuWeiZhi", DeviceChongFuWeiZhi));
parms.Add(new LBDbParameter("DeviceChongFuChangDu", DeviceChongFuChangDu));
parms.Add(new LBDbParameter("DeviceXiaoShuWei", DeviceXiaoShuWei));
parms.Add(new LBDbParameter("DeviceFuHaoKaiShi", DeviceFuHaoKaiShi));
string strSQL = @"
insert into dbo.DbWeightDeviceUserConfig( WeightDeviceUserTypeID, DeviceBoTeLv, DeviceShuJuWei, DeviceTingZhiWei, DeviceZhenChangDu,
DeviceZhenQiShiBiaoShi, DeviceZhenChuLiFangShi, DeviceChongFuWeiZhi, DeviceChongFuChangDu, DeviceXiaoShuWei,
DeviceFuHaoKaiShi )
values( @WeightDeviceUserTypeID, @DeviceBoTeLv, @DeviceShuJuWei, @DeviceTingZhiWei, @DeviceZhenChangDu,
@DeviceZhenQiShiBiaoShi, @DeviceZhenChuLiFangShi, @DeviceChongFuWeiZhi, @DeviceChongFuChangDu, @DeviceXiaoShuWei,
@DeviceFuHaoKaiShi)
";
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 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 Update(FactoryArgs args, t_BigID SaleCarReturnBillID,
t_Decimal CarTare, t_Decimal SuttleWeight, t_ID ReturnType, t_String Description, t_ID ReturnReason,
t_BigID NewSaleCarInBillID)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarReturnBillID", SaleCarReturnBillID));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("ReturnType", ReturnType));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReturnReason", ReturnReason));
parms.Add(new LBDbParameter("NewSaleCarInBillID", NewSaleCarInBillID));
string strSQL = @"
update SaleCarReturnBill
set ReturnStatus=1,
CarTare = @CarTare,
SuttleWeight = @SuttleWeight,
ReturnType = @ReturnType,
Description = @Description,
CarOutTime = getdate(),
ReturnReason = @ReturnReason,
NewSaleCarInBillID = @NewSaleCarInBillID
where SaleCarReturnBillID = @SaleCarReturnBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void CardConfig(FactoryArgs args, t_String ReadCardSerialCOM, t_String WriteCardSerialCOM,
t_ID ReadCardBaud, t_String MachineName, t_ID UseReadCard, t_ID UseWriteCard,
t_ID ConnectType, t_String IPAddress, t_ID IPPort)
{
_DALDbCardn.CardConfig(args, ReadCardSerialCOM, WriteCardSerialCOM, ReadCardBaud, MachineName,
UseReadCard, UseWriteCard, ConnectType, IPAddress, IPPort);
}
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 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 GetTodayTotalWeight(FactoryArgs args, out t_Decimal SalesTotalWeight, out t_ID TotalCar)
{
DateTime dtFrom = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime dtTo = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")).AddDays(1);
SalesTotalWeight = new t_Decimal(0);
TotalCar = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SalesTotalWeight", SalesTotalWeight, true));
parms.Add(new LBDbParameter("TotalCar", TotalCar, true));
parms.Add(new LBDbParameter("DTFrom", new t_DTSmall(dtFrom)));
parms.Add(new LBDbParameter("DTTo", new t_DTSmall(dtTo)));
string strSQL = @"
select @SalesTotalWeight = sum(SuttleWeight/1000.0), @TotalCar = count(1)
from dbo.SaleCarOutBill o
inner join SaleCarInBill i on
i.SaleCarInBillID = o.SaleCarInBillID
where i.BillStatus = 2 and
o.BillDate>=@DTFrom and o.BillDate<@DTTo
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SalesTotalWeight.SetValueWithObject(parms["SalesTotalWeight"].Value);
TotalCar.SetValueWithObject(parms["TotalCar"].Value);
}
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 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 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 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 DBUser_Update(FactoryArgs args, t_BigID UserID, t_String LoginName, t_String UserPassword, t_String UserName,
t_ID UserType, t_ID UserSex)
{
using (DataTable dtUser = _DALDBUser.GetUserByLoginName(args, UserID, LoginName))
{
if (dtUser.Rows.Count > 0)
{
throw new Exception("该账户名称已存在！");
}
}
_DALDBUser.Update(args, UserID, LoginName, UserPassword, UserName, UserType, UserSex);
}
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 dbo.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)
set @CameraConfigID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
CameraConfigID.SetValueWithObject(parms["CameraConfigID"].Value);
}
public void Insert(FactoryArgs args,
t_ID WeightType, t_String MachineName)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("WeightType", WeightType));
parms.Add(new LBDbParameter("MachineName", MachineName));
string strSQL = @"
insert into dbo.DbWeightType( WeightType,MachineName)
values( @WeightType, @MachineName)
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void GetInsideCarCount(FactoryArgs args, out t_ID CarCount)
{
CarCount = new t_ID(0);
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CarCount", CarCount, true));
string strSQL = @"
select @CarCount = sum(1)
from dbo.View_SaleCarInOutBill
where SaleCarOutBillID is null and isnull(IsCancel,0) = 0
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
CarCount.SetValueWithObject(parms["CarCount"].Value);
}
public void Update(FactoryArgs args, t_String SysConfigFieldName, t_String SysConfigValue)
{
t_ID SysConfigDataType = new t_ID(0);//0字符串 1小数 2整数 3布尔值
t_String SysConfigFieldText = new t_String("");
using (DataTable dtConfig = _DALDbSysConfig.GetDbSysConfigField(args, SysConfigFieldName))
{
if (dtConfig.Rows.Count == 0)
{
throw new Exception("该系统设置无效！");
}
else
{
DataRow drConfig = dtConfig.Rows[0];
SysConfigDataType.SetValueWithObject(drConfig["SysConfigDataType"]);
SysConfigFieldText.SetValueWithObject(drConfig["SysConfigFieldText"]);
}
}
if (SysConfigDataType.Value == 1)
{
decimal decValue;
if (!decimal.TryParse(SysConfigValue.Value, out decValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为小数类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
if (SysConfigDataType.Value == 2)
{
int iValue;
if (!int.TryParse(SysConfigValue.Value, out iValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为整数类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
if (SysConfigDataType.Value == 3)
{
int iValue;
if (!int.TryParse(SysConfigValue.Value, out iValue))
{
throw new Exception("【" + SysConfigFieldText.Value + "】为布尔值类型，当前传入的值为【" + SysConfigValue.Value + "】，无法保存！");
}
}
_DALDbSysConfig.Update(args, SysConfigFieldName, SysConfigValue);
}
public void ReadReceiveType(FactoryArgs args, t_BigID CustomerID, out t_ID ReceiveType)
{
ReceiveType = new t_ID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType, true));
string strSQL = @"
select ReceiveType
from dbo.DbCustomer
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReceiveType.SetValueWithObject(parms["ReceiveType"].Value);
}
public void InsertAndUpdate(FactoryArgs args,
t_ID WeightType, t_String MachineName)
{
using (DataTable dtExists = _DALDbWeightType.VerifyExists(args, MachineName))
{
if (dtExists.Rows.Count == 0)
{
_DALDbWeightType.Insert(args, WeightType, MachineName);
}
else
{
t_BigID WeightTypeID = new t_BigID(dtExists.Rows[0]["WeightTypeID"]);
_DALDbWeightType.Update(args, WeightTypeID, WeightType, MachineName);
}
}
}
