private void GetRawMaterial()
{
var cmd = new SqlCommand("select a.FItemID,a.FNumber,a.FName,FModel,FFullName,FDefaultLoc,FSPID,a.FUnitID,b.FName FUnitName from t_icitem a inner join t_MeasureUnit b on a.FUnitID=b.FMeasureUnitID where isnull(a.FDeleted,0)<>1 order by a.FitemID");
var wf = new WmsFunction(BaseStructure.KisConstring);
_dtRawMaterial = wf.GetSqlTable(cmd);
txtcInvCode.DataSource = _dtRawMaterial;
var cmdVendor = new SqlCommand("select FNumber,FName,FAddress from t_Supplier order by FNumber");
txtcVendor.DataSource = wf.GetSqlTable(cmdVendor);
}
private void GetProduct()
{
var cmd = new SqlCommand("Select * from Bom");
var wf = new WmsFunction(BaseStructure.WmsCon);
BomList = wf.GetSqlTable(cmd);
txtcInvCode.DataSource = BomList;
var cmdVendor = new SqlCommand("select FNumber,FName from t_Department order by FNumber");
wf.Constr = BaseStructure.KisConstring;
txtcDept.DataSource = wf.GetSqlTable(cmdVendor);
}
private void GetRawMaterial()
{
var cmd = new SqlCommand("select a.FItemID,a.FNumber,a.FName,FModel,FFullName,FDefaultLoc,FSPID,a.FUnitID,b.FName FUnitName from t_icitem a inner join t_MeasureUnit b on a.FUnitID=b.FMeasureUnitID where isnull(a.FDeleted,0)<>1 order by a.FitemID");
var wf = new WmsFunction(BaseStructure.KisConstring);
_dtRawMaterial = wf.GetSqlTable(cmd);
txtcInvCode.DataSource = _dtRawMaterial;
}
private void WorkTrackDeliveryOrder_Load(object sender, EventArgs e)
{
proDeliveryDetailTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
if (string.IsNullOrEmpty(_lid))
{
SetPanelVlaue("", "btnLast");
}
else
{
SetPanelVlaue(_lid);
}
//智能匹配数据源
var cmd = new SqlCommand("select top 100 cCode from ProDelivery order by AutoID desc");
cmd.Parameters.AddWithValue("@cCode", txtQuery.Text);
var wf = new WmsFunction(BaseStructure.WmsCon);
txtQuery.DataSource = wf.GetSqlTable(cmd);
//初始化表格功能控件
tsgfMain.FormId = Name.GetHashCode().ToString(CultureInfo.CurrentCulture);
tsgfMain.FormName = Text;
tsgfMain.Constr = BaseStructure.WmsCon;
tsgfMain.GetGridStyle(tsgfMain.FormId);
}
private void WorkTrackDeliveryOrder_Load(object sender, EventArgs e)
{
proDeliveryDetailTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
if (string.IsNullOrEmpty(_lid))
{
SetPanelVlaue("", "btnLast");
}
else
{
SetPanelVlaue(_lid);
}
//智能匹配数据源
var cmd = new SqlCommand("select top 100 cCode from ProDelivery order by AutoID desc");
cmd.Parameters.AddWithValue("@cCode", txtQuery.Text);
var wf = new WmsFunction(BaseStructure.WmsCon);
txtQuery.DataSource = wf.GetSqlTable(cmd);
//初始化表格功能控件
tsgfMain.FormId = Name.GetHashCode().ToString(CultureInfo.CurrentCulture);
tsgfMain.FormName = Text;
tsgfMain.Constr = BaseStructure.WmsCon;
tsgfMain.GetGridStyle(tsgfMain.FormId);
}
private DataTable GetPrintData()
{
var cmd = new SqlCommand("select * from View_ProductLabel where cSerialNumber=@cSerialNumber");
cmd.Parameters.AddWithValue("@cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
var wf = new WmsFunction(BaseStructure.WmsCon);
return(wf.GetSqlTable(cmd));
}
private void GetCurrentStock(string cFitemList)
{
var cmd = new SqlCommand(@" select a.FItemID,b.FNumber,b.FName,a.FQty Quantity,b.FModel,b.FFullName,a.FBatchNo,a.FStockID,
c.FNumber FStockNumber,c.FName FStockName,a.FStockPlaceID,d.FNumber FStockPlaceNumber,d.FName FStockPlaceName
from ICInventory a inner join t_ICItem b on a.FItemID=b.FItemID
inner join t_Stock c on a.FStockID=c.FItemID inner join t_StockPlace d on a.FStockPlaceID=d.FSPID
where a.FQty>0 and a.FItemID in(" + cFitemList + ") order by a.FItemID,a.FBatchNo,a.FStockID,a.FStockPlaceID ");
var wf = new WmsFunction(BaseStructure.KisConstring);
uGridCurrentStock.DataSource = wf.GetSqlTable(cmd);
}
private void GetCurrentStock(string cFitemList)
{
var cmd = new SqlCommand(@" select a.FItemID,b.FNumber,b.FName,a.FQty Quantity,b.FModel,b.FFullName,a.FBatchNo,a.FStockID,
c.FNumber FStockNumber,c.FName FStockName,a.FStockPlaceID,d.FNumber FStockPlaceNumber,d.FName FStockPlaceName
from ICInventory a inner join t_ICItem b on a.FItemID=b.FItemID
inner join t_Stock c on a.FStockID=c.FItemID inner join t_StockPlace d on a.FStockPlaceID=d.FSPID
where a.FQty>0 and a.FItemID in(" + cFitemList + ") order by a.FItemID,a.FBatchNo,a.FStockID,a.FStockPlaceID ");
var wf = new WmsFunction(BaseStructure.KisConstring);
uGridCurrentStock.DataSource = wf.GetSqlTable(cmd);
}
private void RefreshData(string cOrderNumber)
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,ICInvBackup.FBillNo,FDate,FStockID,ICInvBackup.FStatus,FBillerID,FCheckerID,FCheckDate,
t_User.FName CreateName,temp.FName CheckName,t_Stock.FName CheckWareHouse
from ICInvBackup left join t_Stock on ICInvBackup.FStockID=t_Stock.FItemID
left join t_User on ICInvBackup.FBillerID=t_User.FUserID
left join t_User temp on ICInvBackup.FCheckerID=temp.FUserID where ICInvBackup.FBillNo like '%" + cOrderNumber + "%' order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
private void SetLotNoSourceAndRecentVendor()
{
if (!biSave.Enabled)
{
return;
}
var wf = new WmsFunction(BaseStructure.KisConstring);
var cmd = new SqlCommand("select FBatchNo,FQty from ICInventory where FitemID=@FItemID and FQty>0 order by FBatchNo desc");
cmd.Parameters.AddWithValue("@FItemID", _FitemId);
txtcLotNo.DataSource = wf.GetSqlTable(cmd);
}
private void RefreshData(string cOrderNumber)
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,ICInvBackup.FBillNo,FDate,FStockID,ICInvBackup.FStatus,FBillerID,FCheckerID,FCheckDate,
t_User.FName CreateName,temp.FName CheckName,t_Stock.FName CheckWareHouse
from ICInvBackup left join t_Stock on ICInvBackup.FStockID=t_Stock.FItemID
left join t_User on ICInvBackup.FBillerID=t_User.FUserID
left join t_User temp on ICInvBackup.FCheckerID=temp.FUserID where ICInvBackup.FBillNo like '%" + cOrderNumber + "%' order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
private void RefreshData(string cOrderNumber)
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,POInstock.FBillNo,FSupplyID,FDate,POInstock.FStatus,FBillerID,FCheckerID,FCheckDate,
t_Supplier.FName,t_User.FName CreateName,temp.FName CheckName
from POInstock inner join t_Supplier on POInstock.FSupplyID=t_Supplier.FItemID
inner join t_User on POInstock.FBillerID=t_User.FUserID
left join t_User temp on POInstock.FCheckerID=temp.FUserID where POInstock.FStatus in (1,2) and POInstock.FInterID in
(select distinct FInterID from POInStockEntry where FAuxConCommitQty = 0) and POOrder.FBillNo like '%" + cOrderNumber + "%' order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
private void RefreshData(string cOrderNumber)
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,POInstock.FBillNo,FSupplyID,FDate,POInstock.FStatus,FBillerID,FCheckerID,FCheckDate,
t_Supplier.FName,t_User.FName CreateName,temp.FName CheckName
from POInstock inner join t_Supplier on POInstock.FSupplyID=t_Supplier.FItemID
inner join t_User on POInstock.FBillerID=t_User.FUserID
left join t_User temp on POInstock.FCheckerID=temp.FUserID where POInstock.FStatus in (1,2) and POInstock.FInterID in
(select distinct FInterID from POInStockEntry where FAuxConCommitQty = 0) and POOrder.FBillNo like '%" + cOrderNumber + "%' order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
private void RefreshData()
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,ICStockBIll.FBillNo,FDCStockID,FSCStockID,FDate,ICStockBIll.FStatus,FBillerID,FCheckerID,FCheckDate,
t_User.FName CreateName,temp.FName CheckName,t_Stock.FName StoreWareHouse,tStock.FName DeliveryWareHouse
from ICStockBIll left join t_Stock on ICStockBIll.FDCStockID=t_Stock.FItemID
left join t_Stock tStock on ICStockBIll.FSCStockID=tStock.FItemID
left join t_User on ICStockBIll.FBillerID=t_User.FUserID
left join t_User temp on ICStockBIll.FCheckerID=temp.FUserID
where ICStockBIll.FTranType=41
order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
/// <summary>
/// 获取原料批号所有被使用的产成品序列号
/// </summary>
private void Query_RmTrackingUseInProduct()
{
if (string.IsNullOrEmpty(biRmcInvCode.EditValue.ToString()) ||
string.IsNullOrEmpty(biRmLotNo.EditValue.ToString()))
return;
uGridRawMaterial.Text = string.Format("原料编码 {0} 原料批号：{1}", biRmcInvCode.EditValue, biRmLotNo.EditValue);
var cmd = new SqlCommand("Query_RmTrackingUseInProduct") {CommandType = CommandType.StoredProcedure};
cmd.Parameters.AddWithValue("@cInvCode", biRmcInvCode.EditValue);
cmd.Parameters.AddWithValue("@FBatchNo", biRmLotNo.EditValue);
var wf = new WmsFunction(BaseStructure.WmsCon);
uGridRawMaterial.DataSource = wf.GetSqlTable(cmd);
MessageBox.Show(@"成功查询", @"成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void RefreshData()
{
var cmd =
new SqlCommand(
@"select top 100 FInterID,ICStockBIll.FBillNo,FDCStockID,FSCStockID,FDate,ICStockBIll.FStatus,FBillerID,FCheckerID,FCheckDate,
t_User.FName CreateName,temp.FName CheckName,t_Stock.FName StoreWareHouse,tStock.FName DeliveryWareHouse
from ICStockBIll left join t_Stock on ICStockBIll.FDCStockID=t_Stock.FItemID
left join t_Stock tStock on ICStockBIll.FSCStockID=tStock.FItemID
left join t_User on ICStockBIll.FBillerID=t_User.FUserID
left join t_User temp on ICStockBIll.FCheckerID=temp.FUserID
where ICStockBIll.FTranType=41
order by FInterID desc");
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridCheck.DataSource = wmf.GetSqlTable(cmd);
}
private void uGridCheck_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e)
{
if (e.Cell.Row == null || e.Cell.Row.Index < 0)
return;
_cOrderNumber = e.Cell.Row.Cells["FBillNo"].Value.ToString();
_iRowNo = e.Cell.Row.Index;
if (!int.TryParse(e.Cell.Row.Cells["FinterID"].Value.ToString(), out _FinterID))
return;
var cmd =
new SqlCommand(
@"select POInstockEntry.FItemID,POInstockEntry.FEntryID,FShortNumber,FNumber,FModel,FName,FQty
from POInstockEntry inner join t_ICItem on POInstockEntry.FItemID=t_ICItem.FItemID
where FInterID=@FinterID and FAuxConCommitQty = 0");
cmd.Parameters.AddWithValue("@FinterID", _FinterID);
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridChecks.DataSource = wmf.GetSqlTable(cmd);
}
private void BaseRoleFunction_Load(object sender, EventArgs e)
{
uGridRole_Function.DisplayLayout.ValueLists.Add("roleList");
uGridRole_Function.DisplayLayout.ValueLists.Add("functionList");
//设置连接并载入数据
roleFunctionTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bFunctionTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bRoleTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bFunctionTableAdapter.Fill(baseDs.BFunction);
var wf = new WmsFunction(BaseStructure.WmsCon);
uGridRole.DataSource = wf.GetSqlTable("SELECT * from View_RoleAndUser");
SetFunctionDropDownList();
//SetRoleDropDownList();
}
private void uGridShiftDetail_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e)
{
var wf = new WmsFunction(BaseStructure.WmsCon);
var cmd = new SqlCommand("select * from RmLabel where cInvCode=@cInvCode and cLotNo=@cLotNo");
cmd.Parameters.AddWithValue("@cInvCode", e.Cell.Row.Cells["cInvCode"].Value.ToString());
cmd.Parameters.AddWithValue("@cLotNo", e.Cell.Row.Cells["FBatchNo"].Value.ToString());
var dt = wf.GetSqlTable(cmd);
if (dt == null || dt.Rows.Count < 1)
{
MessageBox.Show(@"当前批号，未在原料标签打印记录中，请手动在原料标签打印中，打印!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PrintDialogRm("print", e.Cell.Row, dt);
}
/// <summary>
/// 获取原料批号所有被使用的产成品序列号
/// </summary>
private void Query_RmTrackingUseInProduct()
{
if (string.IsNullOrEmpty(biRmcInvCode.EditValue.ToString()) ||
string.IsNullOrEmpty(biRmLotNo.EditValue.ToString()))
{
return;
}
uGridRawMaterial.Text = string.Format("原料编码 {0} 原料批号：{1}", biRmcInvCode.EditValue, biRmLotNo.EditValue);
var cmd = new SqlCommand("Query_RmTrackingUseInProduct")
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@cInvCode", biRmcInvCode.EditValue);
cmd.Parameters.AddWithValue("@FBatchNo", biRmLotNo.EditValue);
var wf = new WmsFunction(BaseStructure.WmsCon);
uGridRawMaterial.DataSource = wf.GetSqlTable(cmd);
MessageBox.Show(@"成功查询", @"成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void uGridCheck_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e)
{
if (e.Cell.Row == null || e.Cell.Row.Index < 0)
{
return;
}
_cOrderNumber = e.Cell.Row.Cells["FBillNo"].Value.ToString();
_iRowNo = e.Cell.Row.Index;
if (!int.TryParse(e.Cell.Row.Cells["FinterID"].Value.ToString(), out _FinterID))
{
return;
}
var cmd =
new SqlCommand(
@"select POInstockEntry.FItemID,POInstockEntry.FEntryID,FShortNumber,FNumber,FModel,FName,FQty
from POInstockEntry inner join t_ICItem on POInstockEntry.FItemID=t_ICItem.FItemID
where FInterID=@FinterID and FAuxConCommitQty = 0");
cmd.Parameters.AddWithValue("@FinterID", _FinterID);
var wmf = new WmsFunction(BaseStructure.KisConstring);
uGridChecks.DataSource = wmf.GetSqlTable(cmd);
}
private void SetRecentVendor()
{
if (!biSave.Enabled)
{
return;
}
var cmdRecentVendor = new SqlCommand("select top 1 FSupplyID,FKFDate from vwICBill_1 where FNumber=@FNumber and FBatchNo=@FBatchNo");
var wf = new WmsFunction(BaseStructure.KisConstring);
cmdRecentVendor.Parameters.AddWithValue("@FNumber", txtcInvCode.Text);
cmdRecentVendor.Parameters.AddWithValue("@FBatchNo", txtcLotNo.Text);
var dtTemp = wf.GetSqlTable(cmdRecentVendor);
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
txtcVendor.Text = dtTemp.Rows[0]["FSupplyID"].ToString();
var cDate = dtTemp.Rows[0]["FKFDate"].ToString();
DateTime dTemp;
if (DateTime.TryParse(cDate, out dTemp))
{
dtpdDate.Value = dTemp;
}
}
}
private void SetLotNoSourceAndRecentVendor()
{
if(!biSave.Enabled)
return;
var wf = new WmsFunction(BaseStructure.KisConstring);
var cmd = new SqlCommand("select FBatchNo,FQty from ICInventory where FitemID=@FItemID and FQty>0 order by FBatchNo desc");
cmd.Parameters.AddWithValue("@FItemID", _FitemId);
txtcLotNo.DataSource = wf.GetSqlTable(cmd);
}
private void BaseRoleFunction_Load(object sender, EventArgs e)
{
uGridRole_Function.DisplayLayout.ValueLists.Add("roleList");
uGridRole_Function.DisplayLayout.ValueLists.Add("functionList");
//设置连接并载入数据
roleFunctionTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bFunctionTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bRoleTableAdapter.Connection.ConnectionString = BaseStructure.WmsCon;
bFunctionTableAdapter.Fill(baseDs.BFunction);
var wf = new WmsFunction(BaseStructure.WmsCon);
uGridRole.DataSource = wf.GetSqlTable("SELECT * from View_RoleAndUser");
SetFunctionDropDownList();
//SetRoleDropDownList();
}
private void uGridShiftDetail_DoubleClickCell(object sender, Infragistics.Win.UltraWinGrid.DoubleClickCellEventArgs e)
{
var wf = new WmsFunction(BaseStructure.WmsCon);
var cmd = new SqlCommand("select * from RmLabel where cInvCode=@cInvCode and cLotNo=@cLotNo");
cmd.Parameters.AddWithValue("@cInvCode", e.Cell.Row.Cells["cInvCode"].Value.ToString());
cmd.Parameters.AddWithValue("@cLotNo", e.Cell.Row.Cells["FBatchNo"].Value.ToString());
var dt = wf.GetSqlTable(cmd);
if (dt==null||dt.Rows.Count<1)
{
MessageBox.Show(@"当前批号，未在原料标签打印记录中，请手动在原料标签打印中，打印!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PrintDialogRm("print", e.Cell.Row, dt);
}
private void GetProduct()
{
var cmd = new SqlCommand("Select * from Bom");
var wf = new WmsFunction(BaseStructure.WmsCon);
BomList = wf.GetSqlTable(cmd);
txtcInvCode.DataSource = BomList;
var cmdVendor = new SqlCommand("select FNumber,FName from t_Department order by FNumber");
wf.Constr = BaseStructure.KisConstring;
txtcDept.DataSource = wf.GetSqlTable(cmdVendor);
}
private DataTable GetPrintData()
{
var cmd = new SqlCommand("select * from View_ProductLabel where cSerialNumber=@cSerialNumber");
cmd.Parameters.AddWithValue("@cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
var wf=new WmsFunction(BaseStructure.WmsCon);
return wf.GetSqlTable(cmd);
}
private void SetRecentVendor()
{
if (!biSave.Enabled)
return;
var cmdRecentVendor = new SqlCommand("select top 1 FSupplyID,FKFDate from vwICBill_1 where FNumber=@FNumber and FBatchNo=@FBatchNo");
var wf = new WmsFunction(BaseStructure.KisConstring);
cmdRecentVendor.Parameters.AddWithValue("@FNumber", txtcInvCode.Text);
cmdRecentVendor.Parameters.AddWithValue("@FBatchNo", txtcLotNo.Text);
var dtTemp = wf.GetSqlTable(cmdRecentVendor);
if(dtTemp!=null&&dtTemp.Rows.Count>0)
{
txtcVendor.Text = dtTemp.Rows[0]["FSupplyID"].ToString();
var cDate = dtTemp.Rows[0]["FKFDate"].ToString();
DateTime dTemp;
if(DateTime.TryParse(cDate,out dTemp))
{
dtpdDate.Value = dTemp;
}
}
}
