private void btnQry_Click(object sender, EventArgs e)
{
string strWheresql = " where IsEnable=0 ";
string strMaterialGuid = "";
if (txtMaterialGuid.Tag != null)
{
if (txtMaterialGuid.Tag.ToString() != "")
{
strMaterialGuid = txtMaterialGuid.Tag.ToString();
strWheresql = strWheresql + " and MaterialGuid='" + strMaterialGuid + "'";
}
}
string strMaterialType = "";
if (txtMaterialType.Tag != null)
{
if (txtMaterialType.Tag.ToString() != "")
{
strMaterialType = txtMaterialType.Tag.ToString();
strWheresql = strWheresql + " and ClassID='" + strMaterialType + "'";
}
}
StockYJManage StockYJManage = new StockYJManage();
gridControl1.DataSource = StockYJManage.GetStockYJData(strWheresql);
}
private void btnBomQry_Click(object sender, EventArgs e)
{
if (txtMaterialGuid.Text.Trim() == "")
{
ShowAlertMessage("请选择物料！");
return;
}
StockYJManage StockYJManage = new StockYJManage();
gridControl1.DataSource = StockYJManage.sp_GetMaterialBomData_BomQry2(txtMaterialGuid.Text.Trim());
}
private void btnQry_Click(object sender, EventArgs e)
{
if (txtIncomeDepot.Text.Trim() == "")
{
ShowAlertMessage("请选择仓库！");
return;
}
StockYJManage StockYJManage = new StockYJManage();
gridControl1.DataSource = StockYJManage.sp_GetOneStorageSumDataByYJ2(txtIncomeDepot.Tag.ToString());
//string strMaterialGuid="";
//if (txtMaterialGuid.Tag !=null)
//{
// strMaterialGuid=txtMaterialGuid.Tag.ToString();
//}
// string strMaterialType="";
//if (txtMaterialType.Tag !=null)
//{
// strMaterialType=txtMaterialType.Tag.ToString();
//}
//StatReportManage StatReportManage = new StatReportManage();
//gridControl1.DataSource=StatReportManage.StockReport(strMaterialGuid, txtStorage.Tag.ToString(), strMaterialType, dtpEndDate.Text.Trim()+" 23:59:59");
////权限判断
//if (rightgroupManage.IsOperateRightByUserID(SysParams.UserID, "IsDisplayPrice", "IsDisplayPrice") == false)
//{
// gridView1.Columns["Price"].Visible = false;
// gridView1.Columns["MaterialMoney"].Visible = false;
// gridView1.Columns["Price2"].Visible = false;
// gridView1.Columns["MaterialMoney2"].Visible = false;
//}
}
private void btnBomQry_Click(object sender, EventArgs e)
{
if (txtMaterialGuid.Text.Trim() == "")
{
ShowAlertMessage("请选择物料！");
return;
}
if (txtIncomeDepot.Text.Trim() == "")
{
ShowAlertMessage("请选择仓库！");
return;
}
StockYJManage StockYJManage = new StockYJManage();
gridControl1.DataSource = StockYJManage.sp_GetOneStorageSumDataByYJ(txtMaterialGuid.Text.Trim(), txtIncomeDepot.Tag.ToString());
}
private void tsbSave_Click(object sender, EventArgs e)
{
txtMaterialName.Focus();
gridView1.UpdateCurrentRow();
List <StockYJ> lstStockYJ = new List <StockYJ>();
StockYJ StockYJ = new StockYJ();
for (int i = 0; i < gridView1.RowCount; i++)
{
DataRowView dr = (DataRowView)(gridView1.GetRow(i));
StockYJ = new StockYJ();
if (dr["StockYJGuid"].ToString().Trim() == "")
{
StockYJ.StockYJGuid = Guid.NewGuid().ToString();
}
else
{
StockYJ.StockYJGuid = dr["StockYJGuid"].ToString();
}
StockYJ.MaterialGuid = dr["MaterialGuid"].ToString();
StockYJ.StockYJDown = decimal.Parse(dr["StockYJDown"].ToString());
StockYJ.StockYJUp = decimal.Parse(dr["StockYJUp"].ToString());
StockYJ.BomSum = decimal.Parse(dr["BomSum"].ToString());
lstStockYJ.Add(StockYJ);
}
StockYJManage StockYJManage = new StockYJManage();
StockYJManage.InsertData(lstStockYJ);
ShowAlertMessage("数据保存成功");
}
