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 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 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); }
private void btnSave_Click(object sender, EventArgs e) { try { this.VerifyTextBoxIsEmpty();//校验控件值是否为空 int iSPType = mlUOMID > 0 ? 20201 : 20200; LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("UOMID", enLBDbType.Int64, mlUOMID)); parmCol.Add(new LBParameter("UOMName", enLBDbType.String, this.txtUOMName.Text)); parmCol.Add(new LBParameter("UOMType", enLBDbType.Int32, this.txtUOMType.SelectedValue)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(iSPType, parmCol, out dsReturn, out dictValue); if (dictValue.ContainsKey("UOMID")) { long.TryParse(dictValue["UOMID"].ToString(), out mlUOMID); } LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); btnDelete.Visible = mlUOMID > 0; } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
public void Insert(FactoryArgs args, out t_BigID ItemID, t_BigID ItemTypeID, t_String ItemCode, t_String K3ItemCode, t_String ItemName, t_String ItemMode, t_Float ItemRate, t_BigID UOMID, t_String Description, t_Bool IsForbid, t_Decimal ItemPrice) { ItemID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("ItemID", ItemID, true)); parms.Add(new LBDbParameter("ItemTypeID", ItemTypeID)); parms.Add(new LBDbParameter("ItemCode", ItemCode)); parms.Add(new LBDbParameter("K3ItemCode", K3ItemCode)); parms.Add(new LBDbParameter("ItemName", ItemName)); parms.Add(new LBDbParameter("ItemMode", ItemMode)); parms.Add(new LBDbParameter("ItemRate", ItemRate)); parms.Add(new LBDbParameter("UOMID", UOMID)); parms.Add(new LBDbParameter("Description", Description)); parms.Add(new LBDbParameter("IsForbid", IsForbid)); parms.Add(new LBDbParameter("ItemPrice", ItemPrice)); parms.Add(new LBDbParameter("ChangeBy", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" insert into dbo.DbItemBase( ItemTypeID, ItemCode,K3ItemCode, ItemName, ItemMode, ItemRate, UOMID, Description, IsForbid, ChangeBy, ChangeTime,ItemPrice) values( @ItemTypeID, @ItemCode,@K3ItemCode, @ItemName, @ItemMode, @ItemRate, @UOMID, @Description, @IsForbid, @ChangeBy, @ChangeTime,@ItemPrice) set @ItemID = @@identity "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); ItemID.Value = Convert.ToInt64(parms["ItemID"].Value); }
public void 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 Car_Update(FactoryArgs args, t_BigID CarID, t_String CarNum, t_String Description, t_Decimal DefaultCarWeight, t_BigID SupplierID, t_BigID CardID) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CarID", CarID)); parms.Add(new LBDbParameter("CarNum", CarNum)); 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))); parms.Add(new LBDbParameter("DefaultCarWeight", DefaultCarWeight)); parms.Add(new LBDbParameter("SupplierID", SupplierID)); parms.Add(new LBDbParameter("CardID", CardID)); string strSQL = @" update dbo.DbCar set CarNum = @CarNum, Description = @Description, ChangeBy = @ChangeBy, ChangeTime = @ChangeTime, DefaultCarWeight = @DefaultCarWeight, SupplierID = @SupplierID, CardID = @CardID where CarID =@CarID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
private void SaveOutSalesPicture(object objSaleCarReturnBillID) { long lSaleCarReturnBillID = LBConverter.ToInt64(objSaleCarReturnBillID); try { CameraInfo cameraInfo = new CameraInfo(); if (GetCameraEvent != null) { GetCameraEvent(this, cameraInfo); } byte[] bImg1 = cameraInfo.Image1; byte[] bImg2 = cameraInfo.Image2; byte[] bImg3 = cameraInfo.Image3; byte[] bImg4 = cameraInfo.Image4; LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("SaleCarReturnBillID", enLBDbType.Int64, lSaleCarReturnBillID)); parmCol.Add(new LBParameter("MonitoreImg1", enLBDbType.Bytes, bImg1)); parmCol.Add(new LBParameter("MonitoreImg2", enLBDbType.Bytes, bImg2)); parmCol.Add(new LBParameter("MonitoreImg3", enLBDbType.Bytes, bImg3)); parmCol.Add(new LBParameter("MonitoreImg4", enLBDbType.Bytes, bImg4)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(30004, parmCol, out dsReturn, out dictValue); } catch (Exception ex) { LBErrorLog.InsertErrorLog("保存出场图片时报错,退货单号:" + lSaleCarReturnBillID.ToString() + "\n错误信息:" + ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtCardCode.Text.TrimEnd() == "") { throw new Exception("【编辑卡片】不能为空!"); } string strCrrentCardCode = LBCardHelper.ReadCardCode(); if (strCrrentCardCode == "") { throw new Exception("请将卡片放置读卡器上,否则无法保存!"); } if (strCrrentCardCode != this.txtCardCode.Text) { if (LB.WinFunction.LBCommonHelper.ConfirmMessage("当前设置的卡号为【" + strCrrentCardCode + "】,是否确认改写为【" + this.txtCardCode.Text + "】?", "提示", MessageBoxButtons.YesNo) == DialogResult.No) { return; } else { //将卡号写入卡片 string strMsg; bool bolSuccess = LBCardHelper.WriteCardCode(this.txtCardCode.Text, out strMsg); if (!bolSuccess) { throw new Exception("卡号写入失败,失败原因:" + strMsg); } } } int iSPType = 20500; if (mlCardID > 0) { iSPType = 20501; } LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("CardID", enLBDbType.Int64, mlCardID)); parmCol.Add(new LBParameter("CardName", enLBDbType.String, this.txtCardName.Text)); parmCol.Add(new LBParameter("CardCode", enLBDbType.String, this.txtCardCode.Text)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(iSPType, parmCol, out dsReturn, out dictValue); if (dictValue.ContainsKey("CardID")) { mlCardID = LBConverter.ToInt64(dictValue["CardID"]); } LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); SetButtonStatus(); } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
public void Car_Insert(FactoryArgs args, out t_BigID CarID, t_String CarCode, t_String CarNum, t_String Description, t_Decimal DefaultCarWeight) { CarID = new t_BigID(); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CarID", CarID, true)); parms.Add(new LBDbParameter("CarNum", CarNum)); parms.Add(new LBDbParameter("CarCode", CarCode)); 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("DefaultCarWeight", DefaultCarWeight)); parms.Add(new LBDbParameter("ChangeTime", new t_DTSmall(DateTime.Now))); string strSQL = @" insert into dbo.DbCar(CarNum,CarCode,Description,CreateBy, CreateTime, ChangeBy, ChangeTime,DefaultCarWeight) values( @CarNum,@CarCode,@Description, @CreateBy, @CreateTime, @ChangeBy, @ChangeTime,@DefaultCarWeight) set @CarID = @@identity "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); CarID.Value = Convert.ToInt64(parms["CarID"].Value); }
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_String SysConfigFieldName, t_String SysConfigValue) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("LoginName", new t_String(args.LoginName))); parms.Add(new LBDbParameter("ChangedTime", new t_DTSmall(DateTime.Now))); parms.Add(new LBDbParameter("SysConfigFieldName", SysConfigFieldName)); parms.Add(new LBDbParameter("SysConfigValue", SysConfigValue)); string strSQL = @" select 1 from DbSysConfigValue where rtrim(SysConfigFieldName)=rtrim(@SysConfigFieldName) "; using (DataTable dtResult = DBHelper.ExecuteQuery(args, strSQL, parms)) { if (dtResult.Rows.Count > 0) { strSQL = @" update dbo.DbSysConfigValue set SysConfigValue = @SysConfigValue where SysConfigFieldName = @SysConfigFieldName"; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); } else { strSQL = @" insert into dbo.DbSysConfigValue( SysConfigFieldName,SysConfigValue) values(@SysConfigFieldName,@SysConfigValue)"; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); } } }
public static void CustomReportUpload(object sender, FastReport.Design.ReportUploadEventArgs e) { try { FastReport.Report report = e.Report; string strTemplateFileName = report.FileName; string strExt = Path.GetExtension(strTemplateFileName); string strFileName = Path.GetFileName(strTemplateFileName); string strReportTemplateName = strFileName.Substring(0, strFileName.Length - strExt.Length); int iReportTemplateID = GetReportTemplateID(strReportTemplateName); if (iReportTemplateID > 0) { byte[] bReport = ReportHelper.ConvertToByte(strTemplateFileName); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBParameter("ReportTemplateID", enLBDbType.Int64, iReportTemplateID)); parms.Add(new LBParameter("TemplateFileTime", enLBDbType.DateTime, DateTime.Now)); parms.Add(new LBParameter("TemplateData", enLBDbType.Object, bReport)); DataSet dsReturn; Dictionary <string, object> dictResult; ExecuteSQL.CallSP(12003, parms, out dsReturn, out dictResult); LB.WinFunction.LBCommonHelper.ShowCommonMessage("上传成功!"); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { int iReadSerialBaud = LBConverter.ToInt32(this.txtReadSerialBaud.Text); string strReadSerialName = this.txtReadSerialName.SelectedValue == null?"": this.txtReadSerialName.SelectedValue.ToString(); string strWriteSerialName = this.txtWriteSerialName.SelectedValue == null ? "" : this.txtWriteSerialName.SelectedValue.ToString(); LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("ReadCardSerialCOM", enLBDbType.String, strReadSerialName)); parmCol.Add(new LBParameter("WriteCardSerialCOM", enLBDbType.String, strWriteSerialName)); parmCol.Add(new LBParameter("ReadCardBaud", enLBDbType.Int32, iReadSerialBaud)); parmCol.Add(new LBParameter("MachineName", enLBDbType.String, LoginInfo.MachineName)); parmCol.Add(new LBParameter("UseReadCard", enLBDbType.Int32, (this.cbUseReadCard.Checked?1:0))); parmCol.Add(new LBParameter("UseWriteCard", enLBDbType.Int32, (this.cbUseWriteCard.Checked ? 1 : 0))); parmCol.Add(new LBParameter("ConnectType", enLBDbType.Int32, (this.rbNet.Checked ? 1 : 0))); parmCol.Add(new LBParameter("IPAddress", enLBDbType.String, this.txtIPAddress.Text)); parmCol.Add(new LBParameter("IPPort", enLBDbType.Int32, LBConverter.ToInt32(this.txtPort.Text))); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(20503, parmCol, out dsReturn, out dictValue); LBCardHelper.StartSerial(enCardType.ReadCard); LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
public void UpdateInfraredDeviceConfig(FactoryArgs args, t_String MachineName, t_String SerialName, t_ID HeaderXType, t_ID TailXType, t_ID SuccessYType, t_ID FailYType, t_Bool IsHeaderEffect, t_Bool IsTailEffect, t_Bool IsAlermEffect) { 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("SuccessYType", SuccessYType)); parms.Add(new LBDbParameter("FailYType", FailYType)); parms.Add(new LBDbParameter("IsHeaderEffect", IsHeaderEffect)); parms.Add(new LBDbParameter("IsTailEffect", IsTailEffect)); parms.Add(new LBDbParameter("IsAlermEffect", IsAlermEffect)); string strSQL = @" update dbo.DbInfraredDeviceConfig set SerialName = @SerialName, HeaderXType = @HeaderXType, TailXType = @TailXType, SuccessYType = @SuccessYType, FailYType = @FailYType, IsHeaderEffect = @IsHeaderEffect, IsTailEffect = @IsTailEffect, IsAlermEffect = @IsAlermEffect where MachineName = @MachineName "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
private void btnSave_Click(object sender, EventArgs e) { try { int WeightType = LBConverter.ToInt32(this.txtWeightType.SelectedValue);; LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("WeightType", enLBDbType.Int32, WeightType)); parmCol.Add(new LBParameter("MachineName", enLBDbType.String, LoginInfo.MachineName)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(14200, parmCol, out dsReturn, out dictValue); if (_OrgWeightType != WeightType) { IsChangeWeightType = true; LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!修改后需要注销并重新登录系统!"); this.Close(); } else { LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
private void btnDelete_Click(object sender, EventArgs e) { try { long lUOMID = 0; string strUOMName = ""; if (grdMain.CurrentRow != null) { DataRowView drv = grdMain.CurrentRow.DataBoundItem as DataRowView; lUOMID = LBConverter.ToInt64(drv["UOMID"]); strUOMName = drv["UOMName"].ToString().TrimEnd(); } if (lUOMID == 0) { return; } if (LB.WinFunction.LBCommonHelper.ConfirmMessage("是否确认删除计量单位:" + strUOMName + "?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("UOMID", enLBDbType.Int64, lUOMID)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(20202, parmCol, out dsReturn, out dictValue); LoadDataSource(); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
private void btnDeleteItemType_Click(object sender, EventArgs e) { try { if (tvItemType.SelectedNode == null || tvItemType.SelectedNode.Tag == null) { return; } DataRow dr = tvItemType.SelectedNode.Tag as DataRow; long lItemTypeID = LBConverter.ToInt64(dr["ItemTypeID"]); if (LB.WinFunction.LBCommonHelper.ConfirmMessage("是否确认物料类型?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (lItemTypeID > 0) { LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("ItemTypeID", enLBDbType.Int64, lItemTypeID)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(20102, parmCol, out dsReturn, out dictValue); } BuildTree(); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { int HeaderXType = LBConverter.ToInt32(this.txtHeaderXType.SelectedValue); int TailXType = LBConverter.ToInt32(this.txtTailXType.SelectedValue); int FailYType = LBConverter.ToInt32(this.txtFailYType.SelectedValue); int SuccessYType = LBConverter.ToInt32(this.txtSuccessYType.SelectedValue); int IsAlermEffect = this.chkAlermEffect.Checked ? 1 : 0; int IsHeaderEffect = this.chkHeaderEffect.Checked ? 1 : 0; int IsTailEffect = this.chkTailEffect.Checked ? 1 : 0; string strSerialName = this.txtSerialName.SelectedValue == null?"": this.txtSerialName.SelectedValue.ToString(); LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("HeaderXType", enLBDbType.Int32, HeaderXType)); parmCol.Add(new LBParameter("TailXType", enLBDbType.Int32, TailXType)); parmCol.Add(new LBParameter("SuccessYType", enLBDbType.Int32, SuccessYType)); parmCol.Add(new LBParameter("FailYType", enLBDbType.Int32, FailYType)); parmCol.Add(new LBParameter("IsHeaderEffect", enLBDbType.Boolean, IsHeaderEffect)); parmCol.Add(new LBParameter("IsTailEffect", enLBDbType.Boolean, IsTailEffect)); parmCol.Add(new LBParameter("IsAlermEffect", enLBDbType.Boolean, IsAlermEffect)); parmCol.Add(new LBParameter("MachineName", enLBDbType.String, LoginInfo.MachineName)); parmCol.Add(new LBParameter("SerialName", enLBDbType.String, strSerialName)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(14500, parmCol, out dsReturn, out dictValue); LBInFrareHelper.InitSerialPort(); LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
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 DataTable ReadModifyDetailByItem(FactoryArgs args, t_BigID CustomerID, t_BigID ItemID) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CustomerID", CustomerID)); parms.Add(new LBDbParameter("ItemID", ItemID)); string strSQL = @" if @CustomerID > 0 begin select top 1 d.* from dbo.ModifyBillDetail d inner join dbo.ModifyBillHeader h on h.ModifyBillHeaderID = d.ModifyBillHeaderID where IsApprove = 1 and h.CustomerID = @CustomerID and d.ItemID = @ItemID order by h.EffectDate desc,h.ApproveTime desc end else begin select top 1 d.* from dbo.ModifyBillDetail d inner join dbo.ModifyBillHeader h on h.ModifyBillHeaderID = d.ModifyBillHeaderID where IsApprove = 1 and d.ItemID = @ItemID order by h.EffectDate desc,h.ApproveTime desc end "; return(DBHelper.ExecuteQuery(args, strSQL, parms)); }
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 UpdateInOutBill(FactoryArgs args, t_BigID SaleCarInBillID, t_BigID ItemID, t_BigID CustomerID, t_Decimal Price, t_Decimal Amount) { LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("SaleCarInBillID", SaleCarInBillID)); parms.Add(new LBDbParameter("ItemID", ItemID)); parms.Add(new LBDbParameter("CustomerID", CustomerID)); parms.Add(new LBDbParameter("Price", Price)); parms.Add(new LBDbParameter("Amount", Amount)); string strSQL = @" update dbo.SaleCarInBill set ItemID = @ItemID, CustomerID = @CustomerID where SaleCarInBillID = @SaleCarInBillID update dbo.SaleCarOutBill set Price = @Price, Amount = @Amount where SaleCarInBillID = @SaleCarInBillID "; DBHelper.ExecuteNonQuery(args, System.Data.CommandType.Text, strSQL, parms, false); }
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 ReadTopBillDateByCardCode(FactoryArgs args, t_String CardCode, out t_String BillDate) { BillDate = new t_String(""); LBDbParameterCollection parms = new LBDbParameterCollection(); parms.Add(new LBDbParameter("CardCode", CardCode)); string strSQL = @" select BillDate from dbo.SaleCarInBill where CardCode = @CardCode order by BillDate desc limit 1 "; if (args.DBType == 1) { strSQL = @" select top 1 BillDate from dbo.SaleCarInBill where CardCode = @CardCode order by BillDate desc "; } DataTable dt = DBHelper.ExecuteQuery(args, strSQL, parms); if (dt.Rows.Count > 0) { BillDate.Value = dt.Rows[0]["BillDate"].ToString().TrimEnd(); } }
public void Insert(FactoryArgs args, out t_BigID 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)); }
private void btnSave_Click(object sender, EventArgs e) { try { this.VerifyTextBoxIsEmpty();//校验控件是否为空 int iSPType = 14700; if (mlChargeTypeID > 0) { iSPType = 14701; } LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("ChargeTypeID", enLBDbType.Int64, mlChargeTypeID)); parmCol.Add(new LBParameter("ChargeTypeCode", enLBDbType.String, "")); parmCol.Add(new LBParameter("ChargeTypeName", enLBDbType.String, this.txtChargeTypeName.Text)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(iSPType, parmCol, out dsReturn, out dictValue); if (dictValue.ContainsKey("ChargeTypeID")) { mlChargeTypeID = LBConverter.ToInt64(dictValue["ChargeTypeID"]); } if (dictValue.ContainsKey("ChargeTypeCode")) { this.txtChargeTypeCode.Text = dictValue["ChargeTypeCode"].ToString(); } LB.WinFunction.LBCommonHelper.ShowCommonMessage("保存成功!"); SetButtonStatus(); } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }
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); }
private void btnCancel_Click(object sender, EventArgs e) { try { frmSaleCarInOutCancel frmCancel = new frmSaleCarInOutCancel(txtCarID.TextBox.Text); LBShowForm.ShowDialog(frmCancel); if (frmCancel.IsAllowCancel) { LBDbParameterCollection parmCol = new LBDbParameterCollection(); parmCol.Add(new LBParameter("SaleCarInBillID", enLBDbType.Int64, mlSaleCarInBillID)); DataSet dsReturn; Dictionary <string, object> dictValue; ExecuteSQL.CallSP(14106, parmCol, out dsReturn, out dictValue); LB.WinFunction.LBCommonHelper.ShowCommonMessage("作废成功!"); ReadFeildValue(); } } catch (Exception ex) { LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex); } }