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);
        }
예제 #2
0
        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);
        }
예제 #3
0
 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 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);
        }
예제 #5
0
        public void Insert(FactoryArgs args, out t_BigID WeightLogID)
        {
            WeightLogID = new t_BigID();
            LBDbParameterCollection parms = new LBDbParameterCollection();

            parms.Add(new LBDbParameter("WeightLogID", WeightLogID, true));

            string strSQL = @"
insert into SalesCarWeightLog(  InWeightTime,CarWeightStatus)
values( datetime('now','localtime'),0);

select last_insert_rowid() as WeightLogID;
";

            if (args.DBType == 1)
            {
                strSQL = @"
insert into SalesCarWeightLog(  InWeightTime,CarWeightStatus)
values(getdate(),0)

select @@identity as WeightLogID
";
            }
            DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false);
            WeightLogID.Value = Convert.ToInt64(parms["WeightLogID"].Value);
        }
예제 #6
0
 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);
         }
     }
 }
예제 #7
0
 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);
 }
예제 #8
0
        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));
        }
예제 #9
0
        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);
        }
예제 #10
0
        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);
        }
예제 #11
0
        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);
        }
예제 #12
0
        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);
        }
예제 #13
0
        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);
        }
예제 #14
0
        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);
        }
예제 #15
0
        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);
        }
예제 #16
0
        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);
        }
예제 #17
0
        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);
        }
예제 #18
0
        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);
        }
예제 #19
0
        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);
        }
예제 #20
0
        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);
        }
예제 #21
0
        //按审核日期计算读取最近审核的明细行记录
        public DataTable GetLastModifyBillDetail(FactoryArgs args, t_BigID ModifyBillDetailID,
                                                 t_BigID CustomerID, t_BigID CarID, t_BigID ItemID, t_ID CalculateType)
        {
            LBDbParameterCollection parms = new LBDbParameterCollection();

            parms.Add(new LBDbParameter("ModifyBillDetailID", ModifyBillDetailID));
            parms.Add(new LBDbParameter("CustomerID", CustomerID));
            parms.Add(new LBDbParameter("CarID", CarID));
            parms.Add(new LBDbParameter("ItemID", ItemID));
            parms.Add(new LBDbParameter("CalculateType", CalculateType));
            string strSQL = @"

    select top 1 d.*
    from dbo.ModifyBillDetail d
        inner join dbo.ModifyBillHeader h on
            d.ModifyBillHeaderID = h.ModifyBillHeaderID
    where   ModifyBillDetailID<>@ModifyBillDetailID and
            CustomerID = @CustomerID and
            CarID = @CarID and
            ItemID = @ItemID and
            CalculateType = @CalculateType and
            h.IsApprove=1
    order by ApproveTime desc
";

            return(DBHelper.ExecuteQuery(args, strSQL, parms));
        }
예제 #22
0
        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 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);
        }
예제 #24
0
        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);
        }
예제 #25
0
        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);
        }
예제 #26
0
        public void Delete(FactoryArgs args, t_BigID ModifyBillHeaderID)
        {
            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("该调价单已作废,无法删除!");
                }
            }

            DBHelper.ExecInTransDelegate exec = delegate(FactoryArgs argsInTrans)
            {
                using (DataTable dtDetail = _DALModifyBillDetail.GetModifyBillDetailByHeaderID(argsInTrans, ModifyBillHeaderID))
                {
                    foreach (DataRow dr in dtDetail.Rows)
                    {
                    }
                }
                _DALModifyBillHeader.Delete(argsInTrans, ModifyBillHeaderID);
            };
            DBHelper.ExecInTrans(args, exec);
        }
예제 #27
0
 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);
 }
예제 #28
0
        public DataTable GetCarItemPrice(FactoryArgs args, t_BigID ItemID, t_BigID CarID, t_BigID CustomerID, t_ID CalculateType)
        {
            LBDbParameterCollection parms = new LBDbParameterCollection();

            parms.Add(new LBDbParameter("CarID", CarID));
            parms.Add(new LBDbParameter("ItemID", ItemID));
            parms.Add(new LBDbParameter("CustomerID", CustomerID));
            parms.Add(new LBDbParameter("CalculateType", CalculateType));
            string strSQL = @"
SELECT     h.CustomerID, c.CustomerName,h.EffectDate,h.ApproveTime,
                       d.ModifyBillDetailID, d.ItemID,i.ItemCode,i.ItemRate,i.ItemMode ,i.ItemName, d.MaterialPrice,d.FarePrice,d.TaxPrice,d.BrokerPrice,
                      d.CarID,  d.Price, d.CalculateType,
                          (SELECT     ConstText
                            FROM          dbo.DbSystemConst
                            WHERE      (FieldName = 'CalculateType') AND (ConstValue = d.CalculateType)) AS CalculateTypeName, d.UOMID, u.UOMName
FROM         dbo.ModifyBillHeader AS h INNER JOIN
                      dbo.ModifyBillDetail AS d ON h.ModifyBillHeaderID = d.ModifyBillHeaderID INNER JOIN
                      dbo.DbCustomer AS c ON c.CustomerID = h.CustomerID INNER JOIN
                      dbo.DbItemBase AS i ON i.ItemID = d.ItemID INNER JOIN
                      dbo.DbUOM AS u ON u.UOMID = d.UOMID 
                    --LEFT OUTER JOIN dbo.DbCar AS ca ON ca.CarID = d.CarID and 
where --d.CarID = @CarID and 
    d.ItemID = @ItemID and 
    isnull(h.CustomerID,0) = isnull(@CustomerID,0) and
    d.CalculateType = @CalculateType and 
    h.IsApprove=1 and 
    isnull(h.IsCancel,0)=0 and 
    h.EffectDate<=CONVERT(varchar(12) , getdate(), 111 )
order by h.ApproveTime desc
";

            return(DBHelper.ExecuteQuery(args, strSQL, parms));
        }
예제 #29
0
        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);
        }
예제 #30
0
        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"]);
                }
            }
        }