public void UpdateInBillDate(FactoryArgs args, t_BigID SaleCarInBillID, t_DTSmall BillDate,
t_String ApproveBy, t_DTSmall ApproveTime, t_String CreateBy, t_DTSmall CreateTime,
t_String CancelBy, t_DTSmall CancelTime, t_DTSmall CancelByDate, t_String ImportSaleCarInBillCode)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("ApproveBy", ApproveBy));
parms.Add(new LBDbParameter("ApproveTime", ApproveTime));
parms.Add(new LBDbParameter("CreateBy", CreateBy));
parms.Add(new LBDbParameter("CreateTime", CreateTime));
parms.Add(new LBDbParameter("CancelBy", CancelBy));
parms.Add(new LBDbParameter("CancelTime", CancelTime));
parms.Add(new LBDbParameter("CancelByDate", CancelByDate));
parms.Add(new LBDbParameter("ImportSaleCarInBillCode", ImportSaleCarInBillCode));
string strSQL = @"
update dbo.SaleCarInBill
set BillDate = @BillDate,
ApproveBy = @ApproveBy,
ApproveTime = @ApproveTime,
CreateBy = @CreateBy,
CreateTime = @CreateTime,
CancelBy = @CancelBy,
CancelTime = @CancelTime,
CancelByDate = @CancelByDate,
ImportSaleCarInBillCode = @ImportSaleCarInBillCode
where SaleCarInBillID = @SaleCarInBillID
";
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 Insert(FactoryArgs args, out t_BigID WeightLogID, t_DTSmall InWeightTime,
t_Image CameraBuffer, t_Image ScreenBuffer)
{
WeightLogID = new t_BigID();
_DALSalesCarWeightLog.Insert(args, out WeightLogID);
SaveCameraImage(args, WeightLogID, new t_ID(0), CameraBuffer, ScreenBuffer);
}
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 Bank_Insert(FactoryArgs args, out t_BigID ReceiveBankID, t_String BankCode, t_String BankName)
{
t_String ChangeBy = new t_String();
t_DTSmall ChangeTime = new t_DTSmall();
ReceiveBankID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReceiveBankID", ReceiveBankID, true));
parms.Add(new LBDbParameter("BankCode", BankCode));
parms.Add(new LBDbParameter("BankName", BankName));
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.DbReceiveBank( BankCode,BankName,ChangeBy,ChangeTime )
values(@BankCode, @BankName, @ChangeBy, @ChangeTime )
select last_insert_rowid() as ReceiveBankID
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.DbReceiveBank( BankCode,BankName,ChangeBy,ChangeTime )
values(@BankCode, @BankName, @ChangeBy, @ChangeTime );
select @@identity as ReceiveBankID;
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReceiveBankID.Value = Convert.ToInt64(parms["ReceiveBankID"].Value);
}
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 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 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 Insert(FactoryArgs args, out t_BigID ModifyBillHeaderID, out t_String ModifyBillCode, t_BigID CustomerID,
t_DTSmall BillDate, t_DTSmall EffectDate, t_String Description)
{
ModifyBillCode = new t_String();
ModifyBillHeaderID = new t_BigID();
t_BigID BillTypeID = new t_BigID(2);
using (DataTable dtCustomer = _DALModifyBillHeader.GetCustomerByID(args, CustomerID))
{
if (dtCustomer.Rows.Count == 0)
{
throw new Exception("所选客户不存在，保存不成功！");
}
}
//生成编码
string strBillFont = "SM" + DateTime.Now.ToString("yyMMdd");
using (DataTable dtBillCode = _DALModifyBillHeader.GetMaxBillCode(args))
{
if (dtBillCode.Rows.Count > 0)
{
DataRow drBillCode = dtBillCode.Rows[0];
int iIndex = 1;
string strIndex = "";
if (drBillCode["ModifyBillCode"].ToString().TrimEnd().Contains(strBillFont))
{
iIndex = Convert.ToInt32(drBillCode["ModifyBillCode"].ToString().TrimEnd().Replace(strBillFont, ""));
iIndex += 1;
if (iIndex < 10)
{
strIndex = "0" + iIndex.ToString();
}
else
{
strIndex = iIndex.ToString();
}
ModifyBillCode.SetValueWithObject(strBillFont + strIndex);
}
else
{
ModifyBillCode.SetValueWithObject(strBillFont + "01");
}
}
else
{
ModifyBillCode.SetValueWithObject(strBillFont + "01");
}
}
_DALModifyBillHeader.Insert(args, out ModifyBillHeaderID, BillTypeID, CustomerID,
ModifyBillCode, BillDate, EffectDate, Description);
}
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID,
t_BigID ItemID, t_DTSmall BillDate, t_Float CarTare, t_BigID SupplierID, t_String Description,
t_String CardCode, t_Float TotalWeight, t_Float SuttleWeight)
{
SaleCarInBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("SupplierID", SupplierID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("CardCode", CardCode));
parms.Add(new LBDbParameter("TotalWeight", TotalWeight));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, BillStatus, CarTare, SupplierID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description,
0,@CreateBy,@BillDate,datetime('now','localtime'),@CardCode,@TotalWeight,@SuttleWeight);
select last_insert_rowid() as SaleCarInBillID;
";
if (args.DBType == 1)
{
strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, BillStatus, CarTare, SupplierID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,CardCode,TotalWeight,SuttleWeight)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, 1, @CarTare, @SupplierID,@Description,
0,@CreateBy,@BillDate,getdate(),@CardCode,@TotalWeight,@SuttleWeight)
select @@identity as SaleCarInBillID
";
}
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value);
}
public void UnCancel(FactoryArgs args, t_BigID SaleCarInBillID, t_DTSmall CancelByDate)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("CancelByDate", CancelByDate));
string strSQL = @"
update dbo.SaleCarInBill
set IsCancel=0,
CancelBy = '',
CancelTime = null,
CancelByDate= @CancelByDate
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Approve(FactoryArgs args, t_BigID SaleCarInBillID, t_DTSmall ApproveTime)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("ApproveTime", ApproveTime));
parms.Add(new LBDbParameter("ApproveBy", new t_String(args.LoginName)));
string strSQL = @"
update dbo.SaleCarInBill
set BillStatus=2,
ApproveTime = @ApproveTime,
ApproveBy=@ApproveBy
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void UpdateReportTemplate(FactoryArgs args,
t_BigID ReportTemplateID, t_DTSmall TemplateFileTime, t_Image TemplateData)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReportTemplateID", ReportTemplateID));
parms.Add(new LBDbParameter("TemplateFileTime", TemplateFileTime));
parms.Add(new LBDbParameter("TemplateData", TemplateData));
string strSQL = @"
update dbo.DbReportTemplate
set TemplateFileTime=@TemplateFileTime,
TemplateData=isnull(@TemplateData,TemplateData)
where ReportTemplateID = @ReportTemplateID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void InsertInBill(FactoryArgs args, out t_BigID SaleCarInBillID, t_String SaleCarInBillCode, t_BigID CarID,
t_BigID ItemID, t_DTSmall BillDate, t_ID ReceiveType, t_ID CalculateType, t_Float CarTare, t_BigID CustomerID, t_String Description,
t_ID SaleBillType, t_BigID SaleCarInBillIDFromClient, t_String CreateBy)
{
SaleCarInBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillCode", SaleCarInBillCode));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("ItemID", ItemID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType));
parms.Add(new LBDbParameter("CalculateType", CalculateType));
parms.Add(new LBDbParameter("CarTare", CarTare));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("SaleBillType", SaleBillType));
parms.Add(new LBDbParameter("SaleCarInBillIDFromClient", SaleCarInBillIDFromClient));
parms.Add(new LBDbParameter("CreateBy", CreateBy));
string strSQL = @"
insert into dbo.SaleCarInBill( SaleCarInBillCode, CarID,PrintCount,
ItemID, BillDate, ReceiveType, BillStatus, CalculateType, CarTare, CustomerID,Description,
IsCancel, CreateBy, CreateTime,CancelByDate,SaleBillType,SaleCarInBillIDFromClient)
values( @SaleCarInBillCode, @CarID,0,
@ItemID, @BillDate, @ReceiveType, 1, @CalculateType, @CarTare, @CustomerID,@Description,
0,@CreateBy,@BillDate,null,@SaleBillType,@SaleCarInBillIDFromClient)
set @SaleCarInBillID = @@identity
update dbo.DbCar
set SortLevel = isnull(SortLevel,0)+1
where CarID = @CarID
update dbo.DbCustomer
set SortLevel = isnull(SortLevel,0)+1
where CustomerID = @CustomerID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarInBillID.Value = Convert.ToInt64(parms["SaleCarInBillID"].Value);
}
public void ChargeType_Update(FactoryArgs args, t_BigID ChargeTypeID, t_String ChargeTypeName)
{
t_String ChangeBy = new t_String();
t_DTSmall ChangeTime = new t_DTSmall();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID));
parms.Add(new LBDbParameter("ChargeTypeName", ChargeTypeName));
parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
string strSQL = @"
update dbo.DbChargeType
set ChargeTypeName = @ChargeTypeName,
ChangeBy = @ChangeBy,
ChangeTime = @ChangeTime
where ChargeTypeID =@ChargeTypeID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID ReceiveBillHeaderID, t_DTSmall BillDate, t_Decimal ReceiveAmount,
t_String Description, t_BigID ReceiveBankID, t_ID RPReceiveType,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount,
t_BigID ChargeTypeID)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReceiveBillHeaderID", ReceiveBillHeaderID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("ReceiveAmount", ReceiveAmount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveBankID", ReceiveBankID));
parms.Add(new LBDbParameter("RPReceiveType", RPReceiveType));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("SalesReceiveAmountAdd", SalesReceiveAmountAdd));
parms.Add(new LBDbParameter("SalesReceiveAmountReduce", SalesReceiveAmountReduce));
parms.Add(new LBDbParameter("OriginalAmount", OriginalAmount));
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID));
string strSQL = @"
update dbo.RPReceiveBillHeader
set BillDate = @BillDate,
ReceiveAmount = @ReceiveAmount,
Description = @Description,
ChangedBy = @ChangedBy,
ChangeTime = @ChangeTime,
ReceiveBankID = @ReceiveBankID,
RPReceiveType = @RPReceiveType,
SalesReceiveAmountAdd = @SalesReceiveAmountAdd,
SalesReceiveAmountReduce = @SalesReceiveAmountReduce,
OriginalAmount = @OriginalAmount,
ChargeTypeID = @ChargeTypeID
where ReceiveBillHeaderID = @ReceiveBillHeaderID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
public void Update(FactoryArgs args, t_BigID ReceiveBillHeaderID, t_DTSmall BillDate, t_Decimal ReceiveAmount,
t_String Description, t_BigID ReceiveBankID, t_ID RPReceiveType, t_Decimal SalesReceiveAmountAdd,
t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount, t_BigID ChargeTypeID)
{
RPReceiveType.IsNullToZero();
if (ReceiveAmount.Value == 0)
{
throw new Exception("充值金额不能为0！");
}
using (DataTable dtHeader = _DALRPReceiveBillHeader.GetRPReceiveBillHeader(args, ReceiveBillHeaderID))
{
if (dtHeader.Rows.Count > 0)
{
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("该充值单已作废，无法进行修改！");
}
}
else
{
throw new Exception("该充值单已删除，无法进行修改！");
}
}
_DALRPReceiveBillHeader.Update(args, ReceiveBillHeaderID, BillDate, ReceiveAmount,
Description, ReceiveBankID, RPReceiveType, SalesReceiveAmountAdd, SalesReceiveAmountReduce, OriginalAmount,
ChargeTypeID);
}
public void ChargeType_Insert(FactoryArgs args, out t_BigID ChargeTypeID, t_String ChargeTypeCode, t_String ChargeTypeName)
{
t_String ChangeBy = new t_String();
t_DTSmall ChangeTime = new t_DTSmall();
ChargeTypeID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID, true));
parms.Add(new LBDbParameter("ChargeTypeCode", ChargeTypeCode));
parms.Add(new LBDbParameter("ChargeTypeName", ChargeTypeName));
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.DbChargeType( ChargeTypeCode,ChargeTypeName,ChangeBy,ChangeTime )
values(@ChargeTypeCode, @ChargeTypeName, @ChangeBy, @ChangeTime )
set @ChargeTypeID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ChargeTypeID.Value = Convert.ToInt64(parms["ChargeTypeID"].Value);
}
public void InsertChangeBill(FactoryArgs args, out t_BigID SaleCarChangeBillID,
t_BigID SaleCarInBillID, t_DTSmall ChangeDate, t_String ChangeBy, t_String ChangeDesc,
t_String ChangeDetail)
{
SaleCarChangeBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarChangeBillID", SaleCarChangeBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("ChangeDate", ChangeDate));
parms.Add(new LBDbParameter("ChangeBy", ChangeBy));
parms.Add(new LBDbParameter("ChangeDesc", ChangeDesc));
parms.Add(new LBDbParameter("ChangeDetail", ChangeDetail));
string strSQL = @"
insert dbo.SaleCarChangeBill(SaleCarInBillID,ChangeDate,ChangeBy,ChangeDesc,ChangeDetail)
values(@SaleCarInBillID,@ChangeDate,@ChangeBy,@ChangeDesc,@ChangeDetail)
set @SaleCarChangeBillID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarChangeBillID.SetValueWithObject(parms["SaleCarChangeBillID"].Value);
}
public void GetCameraImage(FactoryArgs args, t_BigID SaleCarReturnBillID,
out t_Image InMonitoreImg1, out t_Image InMonitoreImg2, out t_Image InMonitoreImg3, out t_Image InMonitoreImg4,
out t_Image OutMonitoreImg1, out t_Image OutMonitoreImg2, out t_Image OutMonitoreImg3, out t_Image OutMonitoreImg4)
{
InMonitoreImg1 = new t_Image();
InMonitoreImg2 = new t_Image();
InMonitoreImg3 = new t_Image();
InMonitoreImg4 = new t_Image();
OutMonitoreImg1 = new t_Image();
OutMonitoreImg2 = new t_Image();
OutMonitoreImg3 = new t_Image();
OutMonitoreImg4 = new t_Image();
t_DTSmall CarInTime = new t_DTSmall();
t_DTSmall CarOutTime = new t_DTSmall();
using (DataTable dtBill = _DALSaleCarReturnBill.GetReturnBill(args, SaleCarReturnBillID))
{
if (dtBill.Rows.Count > 0)
{
DataRow drBill = dtBill.Rows[0];
CarInTime.SetValueWithObject(drBill["CarInTime"]);
CarOutTime.SetValueWithObject(drBill["CarOutTime"]);
}
}
//读取入场图片
if (CarInTime.Value != null)
{
string strInPath = GetPicturePath(enImagePathType.InBillPath, (DateTime)CarInTime.Value);
string strPathImg1 = Path.Combine(strInPath, SaleCarReturnBillID.Value.ToString() + "_Image1.jpg");
string strPathImg2 = Path.Combine(strInPath, SaleCarReturnBillID.Value.ToString() + "_Image2.jpg");
string strPathImg3 = Path.Combine(strInPath, SaleCarReturnBillID.Value.ToString() + "_Image3.jpg");
string strPathImg4 = Path.Combine(strInPath, SaleCarReturnBillID.Value.ToString() + "_Image4.jpg");
if (File.Exists(strPathImg1))
{
InMonitoreImg1.SetValueWithObject(CommonHelper.ReadFile(strPathImg1));
}
if (File.Exists(strPathImg2))
{
InMonitoreImg2.SetValueWithObject(CommonHelper.ReadFile(strPathImg2));
}
if (File.Exists(strPathImg3))
{
InMonitoreImg3.SetValueWithObject(CommonHelper.ReadFile(strPathImg3));
}
if (File.Exists(strPathImg4))
{
InMonitoreImg4.SetValueWithObject(CommonHelper.ReadFile(strPathImg4));
}
}
//读取出场图片
if (CarOutTime.Value != null)
{
string strOutPath = GetPicturePath(enImagePathType.OutBillPath, (DateTime)CarOutTime.Value);
string strPathImg1 = Path.Combine(strOutPath, SaleCarReturnBillID.Value.ToString() + "_Image1.jpg");
string strPathImg2 = Path.Combine(strOutPath, SaleCarReturnBillID.Value.ToString() + "_Image2.jpg");
string strPathImg3 = Path.Combine(strOutPath, SaleCarReturnBillID.Value.ToString() + "_Image3.jpg");
string strPathImg4 = Path.Combine(strOutPath, SaleCarReturnBillID.Value.ToString() + "_Image4.jpg");
if (File.Exists(strPathImg1))
{
OutMonitoreImg1.SetValueWithObject(CommonHelper.ReadFile(strPathImg1));
}
if (File.Exists(strPathImg2))
{
OutMonitoreImg2.SetValueWithObject(CommonHelper.ReadFile(strPathImg2));
}
if (File.Exists(strPathImg3))
{
OutMonitoreImg3.SetValueWithObject(CommonHelper.ReadFile(strPathImg3));
}
if (File.Exists(strPathImg4))
{
OutMonitoreImg4.SetValueWithObject(CommonHelper.ReadFile(strPathImg4));
}
}
}
public void GetCameraImage(FactoryArgs args, t_BigID WeightLogID,
out t_Image InWeightCamera, out t_Image InWeightScreen,
out t_Image SteadyWeightCamera, out t_Image SteadyWeightScreen,
out t_Image OutWeightCamera, out t_Image OutWeightScreen)
{
InWeightCamera = new t_Image();
InWeightScreen = new t_Image();
SteadyWeightCamera = new t_Image();
SteadyWeightScreen = new t_Image();
OutWeightCamera = new t_Image();
OutWeightScreen = new t_Image();
t_DTSmall InWeightTime = new t_DTSmall();
t_DTSmall SteadyWeightTime = new t_DTSmall();
t_DTSmall OutWeightTime = new t_DTSmall();
using (DataTable dtBill = _DALSalesCarWeightLog.GetSalesCarWeightLog(args, WeightLogID))
{
if (dtBill.Rows.Count > 0)
{
DataRow drBill = dtBill.Rows[0];
InWeightTime.SetValueWithObject(drBill["InWeightTime"]);
SteadyWeightTime.SetValueWithObject(drBill["SteadyWeightTime"]);
OutWeightTime.SetValueWithObject(drBill["OutWeightTime"]);
}
}
//读取入场图片
if (InWeightTime.Value != null)
{
string strInPath = GetPicturePath((DateTime)InWeightTime.Value);
string strPathImg1 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Camera_0.jpg");
string strPathImg2 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Screen_0.jpg");
if (File.Exists(strPathImg1))
{
InWeightCamera.SetValueWithObject(CommonHelper.ReadFile(strPathImg1));
}
if (File.Exists(strPathImg2))
{
InWeightScreen.SetValueWithObject(CommonHelper.ReadFile(strPathImg2));
}
}
if (SteadyWeightTime.Value != null)
{
string strInPath = GetPicturePath((DateTime)SteadyWeightTime.Value);
string strPathImg1 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Camera_1.jpg");
string strPathImg2 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Screen_1.jpg");
if (File.Exists(strPathImg1))
{
SteadyWeightCamera.SetValueWithObject(CommonHelper.ReadFile(strPathImg1));
}
if (File.Exists(strPathImg2))
{
SteadyWeightScreen.SetValueWithObject(CommonHelper.ReadFile(strPathImg2));
}
}
if (OutWeightTime.Value != null)
{
string strInPath = GetPicturePath((DateTime)OutWeightTime.Value);
string strPathImg1 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Camera_2.jpg");
string strPathImg2 = Path.Combine(strInPath, WeightLogID.Value.ToString() + "_Image_Screen_2.jpg");
if (File.Exists(strPathImg1))
{
OutWeightCamera.SetValueWithObject(CommonHelper.ReadFile(strPathImg1));
}
if (File.Exists(strPathImg2))
{
OutWeightScreen.SetValueWithObject(CommonHelper.ReadFile(strPathImg2));
}
}
}
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();
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));
parms.Add(new LBDbParameter("PrintCount", PrintCount));
string strSQL = @"
insert into dbo.DbReportTemplate( ReportTemplateName,ReportTemplateNameExt, TemplateFileTime,TemplateSeq,Description,TemplateData,ReportTypeID)
values( @ReportTemplateName,'.frx', @TemplateFileTime,@TemplateSeq,@Description,@TemplateData,@ReportTypeID)
set @ReportTemplateID = @@identity
insert dbo.DbPrinterConfig( ReportTemplateID, PrinterName, MachineName, IsManualPaperType,
PaperType, IsManualPaperSize, PaperSizeHeight, PaperSizeWidth, IsPaperTransverse,PrintCount)
values(@ReportTemplateID, @PrinterName, @MachineName, @IsManualPaperType,
@PaperType, @IsManualPaperSize, @PaperSizeHeight, @PaperSizeWidth, @IsPaperTransverse,@PrintCount)
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReportTemplateID.SetValueWithObject(parms["ReportTemplateID"].Value);
}
public void Insert(FactoryArgs args, out t_BigID ReceiveBillHeaderID, out t_String ReceiveBillCode, t_DTSmall BillDate, t_BigID CustomerID, t_Decimal ReceiveAmount,
t_String Description, t_BigID SaleCarInBillID, t_BigID ReceiveBankID, t_ID RPReceiveType,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount,
t_BigID ChargeTypeID)
{
BillDate = new t_DTSmall(DateTime.Now);
ReceiveBankID.NullIfZero();
RPReceiveType.IsNullToZero();
ReceiveBillCode = new t_String();
if (ReceiveAmount.Value == 0)
{
throw new Exception("充值金额不能为0！");
}
//生成编码
string strBillFont = "SK" + DateTime.Now.ToString("yyyyMM") + "-";
using (DataTable dtBillCode = _DALRPReceiveBillHeader.GetMaxBillCode(args, strBillFont))
{
if (dtBillCode.Rows.Count > 0)
{
DataRow drBillCode = dtBillCode.Rows[0];
int iIndex = 1;
string strIndex = "";
if (drBillCode["ReceiveBillCode"].ToString().TrimEnd().Contains(strBillFont))
{
iIndex = Convert.ToInt32(drBillCode["ReceiveBillCode"].ToString().TrimEnd().Replace(strBillFont, ""));
iIndex += 1;
if (iIndex < 10)
{
strIndex = "0000" + iIndex.ToString();
}
else if (iIndex < 100)
{
strIndex = "000" + iIndex.ToString();
}
else if (iIndex < 1000)
{
strIndex = "00" + iIndex.ToString();
}
else if (iIndex < 10000)
{
strIndex = "0" + iIndex.ToString();
}
else
{
strIndex = iIndex.ToString();
}
ReceiveBillCode.SetValueWithObject(strBillFont + strIndex);
}
else
{
ReceiveBillCode.SetValueWithObject(strBillFont + "00001");
}
}
else
{
ReceiveBillCode.SetValueWithObject(strBillFont + "00001");
}
}
_DALRPReceiveBillHeader.Insert(args, out ReceiveBillHeaderID, ReceiveBillCode, BillDate, CustomerID, ReceiveAmount, Description, SaleCarInBillID,
ReceiveBankID, RPReceiveType, SalesReceiveAmountAdd, SalesReceiveAmountReduce, OriginalAmount, ChargeTypeID);
}
public void InsertOutBill(FactoryArgs args, out t_BigID SaleCarOutBillID, t_String SaleCarOutBillCode, t_BigID SaleCarInBillID, t_BigID CarID, t_DTSmall BillDate,
t_Decimal TotalWeight, t_Decimal SuttleWeight, t_Decimal Price, t_Decimal Amount, t_ID ReceiveType, t_ID CalculateType, t_String Description)
{
SaleCarOutBillID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("SaleCarOutBillID", SaleCarOutBillID, true));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("SaleCarOutBillCode", SaleCarOutBillCode));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CarID", CarID));
parms.Add(new LBDbParameter("TotalWeight", TotalWeight));
parms.Add(new LBDbParameter("SuttleWeight", SuttleWeight));
parms.Add(new LBDbParameter("Price", Price));
parms.Add(new LBDbParameter("Amount", Amount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveType", ReceiveType));
parms.Add(new LBDbParameter("CalculateType", CalculateType));
parms.Add(new LBDbParameter("CreateBy", new t_String(args.LoginName)));
string strSQL = @"
insert into dbo.SaleCarOutBill( SaleCarInBillID,SaleCarOutBillCode, BillDate, CarID,TotalWeight,
SuttleWeight, Price, Amount, Description,CreateBy, CreateTime)
values( @SaleCarInBillID,@SaleCarOutBillCode, @BillDate, @CarID, @TotalWeight,
@SuttleWeight, @Price, @Amount, @Description,@CreateBy,datetime('now','localtime'))
set @SaleCarOutBillID = @@identity
update dbo.SaleCarInBill
set ReceiveType = @ReceiveType,
CalculateType = @CalculateType
where SaleCarInBillID = @SaleCarInBillID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
SaleCarOutBillID.Value = Convert.ToInt64(parms["SaleCarOutBillID"].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, 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 UpdateReportTemplate(FactoryArgs args,
t_BigID ReportTemplateID, t_DTSmall TemplateFileTime, t_Image TemplateData)
{
_DALDbReportTemplate.UpdateReportTemplate(args, ReportTemplateID, TemplateFileTime, TemplateData);
}
public void Insert(FactoryArgs args, out t_BigID ReceiveBillHeaderID, t_String ReceiveBillCode, t_DTSmall BillDate, t_BigID CustomerID, t_Decimal ReceiveAmount,
t_String Description, t_BigID SaleCarInBillID, t_BigID ReceiveBankID, t_ID RPReceiveType,
t_Decimal SalesReceiveAmountAdd, t_Decimal SalesReceiveAmountReduce, t_Decimal OriginalAmount,
t_BigID ChargeTypeID)
{
ReceiveBillHeaderID = new t_BigID();
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReceiveBillHeaderID", ReceiveBillHeaderID, true));
parms.Add(new LBDbParameter("ReceiveBillCode", ReceiveBillCode));
parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID));
parms.Add(new LBDbParameter("BillDate", BillDate));
parms.Add(new LBDbParameter("CustomerID", CustomerID));
parms.Add(new LBDbParameter("ReceiveAmount", ReceiveAmount));
parms.Add(new LBDbParameter("Description", Description));
parms.Add(new LBDbParameter("ReceiveBankID", ReceiveBankID));
parms.Add(new LBDbParameter("RPReceiveType", RPReceiveType));
parms.Add(new LBDbParameter("CreatedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("CreateTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("ChangedBy", new t_String(args.LoginName)));
parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now)));
parms.Add(new LBDbParameter("SalesReceiveAmountAdd", SalesReceiveAmountAdd));
parms.Add(new LBDbParameter("SalesReceiveAmountReduce", SalesReceiveAmountReduce));
parms.Add(new LBDbParameter("OriginalAmount", OriginalAmount));
parms.Add(new LBDbParameter("ChargeTypeID", ChargeTypeID));
string strSQL = @"
insert into dbo.RPReceiveBillHeader( ReceiveBillCode, BillDate, CustomerID, ReceiveAmount,
Description,CreatedBy,CreateTime,ChangedBy,ChangeTime,IsApprove,IsCancel,SaleCarInBillID,
ReceiveBankID,RPReceiveType,SalesReceiveAmountAdd,SalesReceiveAmountReduce,OriginalAmount,ChargeTypeID)
values( @ReceiveBillCode, @BillDate, @CustomerID, @ReceiveAmount,
@Description,@CreatedBy,@CreateTime,@ChangedBy,@ChangeTime,0,0,@SaleCarInBillID,
@ReceiveBankID,@RPReceiveType,@SalesReceiveAmountAdd,@SalesReceiveAmountReduce,@OriginalAmount,@ChargeTypeID)
set @ReceiveBillHeaderID = @@identity
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
ReceiveBillHeaderID.SetValueWithObject(parms["ReceiveBillHeaderID"].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_String PrinterName, t_String MachineName, t_Bool IsManualPaperType, t_String PaperType, t_Bool IsManualPaperSize,
t_ID PaperSizeHeight, t_ID PaperSizeWidth, t_Bool IsPaperTransverse)
{
LBDbParameterCollection parms = new LBDbParameterCollection();
parms.Add(new LBDbParameter("ReportTemplateID", ReportTemplateID));
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("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 = @"
update dbo.DbReportTemplate
set ReportTemplateName = @ReportTemplateName,
TemplateFileTime=@TemplateFileTime,
TemplateSeq=@TemplateSeq,
Description=@Description,
TemplateData=isnull(@TemplateData,TemplateData)
where ReportTemplateID = @ReportTemplateID
";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
LBDbParameterCollection parms1 = new LBDbParameterCollection();
parms1.Add(new LBDbParameter("ReportTemplateID", ReportTemplateID));
strSQL = "select 1 from dbo.DbPrinterConfig where ReportTemplateID = @ReportTemplateID";
using (DataTable dtResult = DBHelper.ExecuteQuery(args, strSQL, parms1))
{
if (dtResult.Rows.Count > 0)
{
strSQL = @"insert 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);
}
else
{
strSQL = @"update dbo.DbPrinterConfig
set PrinterName = @PrinterName,
MachineName = @MachineName,
IsManualPaperType = @IsManualPaperType,
PaperType = @PaperType,
IsManualPaperSize = @IsManualPaperSize,
PaperSizeHeight = @PaperSizeHeight,
PaperSizeWidth = @PaperSizeWidth,
IsPaperTransverse = @IsPaperTransverse
where ReportTemplateID = @ReportTemplateID";
DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
}
}
}
