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);
}
}
