private void QueryData()
{
string strWhere = " Where 1=1";
if (txt_inventoryCode.Text.Trim() != "")
{
strWhere += string.Format(" And A.InventoryCode='{0}'", txt_inventoryCode.Text.Trim());
}
if (txt_ReelId.Text.Trim() != "")
{
string reelid = string.Empty;
strWhere += string.Format(" And B.ReelId='{0}'", txt_ReelId.Text.Trim());
}
if (cbo_houseName.Text != "")
{
strWhere += string.Format(" And A.HouseCode='{0}'", cbo_houseName.SelectedValue.ToString());
}
if (cbo_status.Text != "")
{
if (cbo_status.Text == "未盘")
{
strWhere += string.Format(" And B.Status='1'");
}
else if (cbo_status.Text == "已盘")
{
strWhere += string.Format(" And B.Status='0'");
}
}
DataTable dt = Bll_Inventory_ti.QueryDetail(strWhere);
dgv_inventoryManager.DataSource = dt;
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_save_Click(object sender, EventArgs e)
{
obj = new T_Inventory_ti();
if (cbo_houseName.SelectedValue.ToString() != string.Empty)//仓库
{
obj.HouseCode = cbo_houseName.SelectedValue.ToString().Trim();
obj.HouseName = cbo_houseName.Text.Trim();
}
if (cbo_areaName.SelectedValue.ToString() != "-1")//库区
{
obj.StorageArea = cbo_areaName.SelectedValue.ToString();
}
if (cbo_PN.Text.ToString() != string.Empty)//料号
{
obj.PN = cbo_PN.Text.ToString().Trim();
}
string varMsg = string.Empty;
bool isSucess = Bll_Inventory_ti.Insert(obj, out varMsg);
if (isSucess)
{
this.result = DialogResult.OK;
this.Close();
}
else
{
MsgBox.Error(varMsg);
return;
}
}
/// <summary>
/// 盘点汇总
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_inventorycollect_Click(object sender, EventArgs e)
{
if (dgv_inventory.CurrentRow.Cells["Status"].Value.ToString() != "盘点中")
{
MsgBox.Error("仅盘点中的单据可进行汇总!");
QueryData();
return;
}
//盘点单据号
string inventoryCode = dgv_inventory.CurrentRow.Cells["InventoryCode"].Value.ToString();
//获得差异数
DataTable dt_DifferQty = Bll_Inventory_ti.CalculateDifferQty(inventoryCode);
//获得盘盈盘亏单号
string inventoryNumber = Bll_Inventory_ti.GetInventoryNumber();
foreach (DataRow row in dt_DifferQty.Rows)
{
string flag = string.Empty;
string varDifferQty = string.Empty;
if (Common.Helper.SqlInput.ChangeNullToInt(row["差异数"], 0) > 0)//盘盈 0
{
flag = "0";
varDifferQty = row["差异数"].ToString();
}
else if (Common.Helper.SqlInput.ChangeNullToInt(row["差异数"], 0) == 0)//
{
flag = "";
varDifferQty = row["差异数"].ToString();
}
else if (Common.Helper.SqlInput.ChangeNullToInt(row["差异数"], 0) < 0)//盘亏 1
{
flag = "1";
varDifferQty = row["差异数"].ToString();
}
//盘点汇总
if (!Bll_Inventory_ti.Update_Inventory_Status(varDifferQty, inventoryCode, row["PN"].ToString(), flag, inventoryNumber))
{
MsgBox.Error("盘点汇总失败");
return;
}
}
//删除未盘料盘的SerialNumber
Bll_Inventory_ti.DeleteUnInventory(inventoryCode);
QueryData();//刷新
new PubUtils().ShowNoteOKMsg("汇总成功");
}
private void QueryData()
{
string strWhere = " Where 1=1";
if (txt_inventoryCode.Text.Trim() != "")
{
strWhere += string.Format(" And A.InventoryCode='{0}'", txt_inventoryCode.Text.Trim());
}
if (txt_PN.Text.Trim() != "")
{
strWhere += string.Format(" And B.PN='{0}'", txt_PN.Text.Trim());
}
if (cbo_houseName.Text != "")
{
strWhere += string.Format(" And A.HouseCode='{0}'", cbo_houseName.SelectedValue.ToString());
}
DataTable dt = Bll_Inventory_ti.Query(strWhere);
dgv_inventoryDetail.DataSource = dt;
}
private void QueryData()
{
string strWhere = " Where 1=1";
if (txt_inventoryCode.Text.Trim() != string.Empty)
{
strWhere += string.Format("And A.InventoryCode='{0}'", txt_inventoryCode.Text.Trim());
}
if (txt_PN.Text.Trim() != string.Empty)
{
strWhere += string.Format(" And A.PN='{0}'", txt_PN.Text.Trim());
}
if (cbo_houseName.Text != string.Empty)
{
strWhere += string.Format(" And A.HouseCode='{0}'", cbo_houseName.SelectedValue.ToString());
}
if (cbo_status.Text != "")
{
switch (cbo_status.Text)
{
case "开立":
strWhere += "And A.Status='0'";
break;
case "盘点中":
strWhere += "And A.Status='1'";
break;
case "完成":
strWhere += "And A.Status='2'";
break;
default:
break;
}
}
DataTable dt = Bll_Inventory_ti.Select(strWhere);
dgv_inventory.DataSource = dt;
}
private void QueryData()
{
string strWhere = "where 1=1";
if (txt_inventoryCode.Text != string.Empty)
{
strWhere += string.Format("And A.InventoryCode='{0}'", txt_inventoryCode.Text.Trim());
}
if (txt_InventoryNumber.Text != string.Empty)
{
strWhere += string.Format("And A.InventoryNumber='{0}'", txt_InventoryNumber.Text.Trim());
}
if (txt_PN.Text != string.Empty)
{
strWhere += string.Format("And B.PN='{0}'", txt_PN.Text.Trim());
}
if (cbo_flag.Text != string.Empty)
{
switch (cbo_flag.Text)
{
case "盘盈":
strWhere += "And A.Flag='0'";
break;
case "盘亏":
strWhere += "And A.Flag='1'";
break;
default:
break;
}
}
DataTable dtCollectInfo = Bll_Inventory_ti.QueryCollectInfo(strWhere);
dgv_inventoryManager.DataSource = dtCollectInfo;
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_delete_Click(object sender, EventArgs e)
{
if (dgv_inventory.CurrentRow == null)
{
MsgBox.Error("请先选中行！");
return;
}
if (dgv_inventory.CurrentRow.Cells["Status"].Value.ToString() != "开立")
{
MsgBox.Error("仅【开立】中盘点单可以删除");
return;
}
DialogResult result = MsgBox.Question("确认删除！");
if (result == DialogResult.OK)
{
bool isSucess = Bll_Inventory_ti.Delete(dgv_inventory.CurrentRow.Cells["InventoryCode"].Value.ToString());
if (isSucess)
{
QueryData();
new PubUtils().ShowNoteOKMsg("删除成功！");
}
}
}
