private void ResetDepProp()
{
if (isToolWin)
{
propForm.Hide();
propForm = null;
toolWin.Close(vsSaveChanges.vsSaveChangesNo);
isToolWin = false;
propForm.FirstLoad = true;
}
_connString = "";
projPath = "";
proc = null;
}
protected void OnSave_Click(object sender, DirectEventArgs e)
{
try
{
string InvCategory = Common.GetComboBoxValue(cbInvCategory);
if (InvCategory == "0")
{
InvCategory = "1";
}
if (txt_price2.Text == "")
{
txt_price2.Text = "0";
}
if (txt_cost2.Text == "")
{
txt_cost2.Text = "0";
}
string sSQL = "INSERT INTO inventory_stock (invs_category,invs_ctg,invs_name,invs_inamt,invs_outamt,invs_invamt,invs_minstock,invs_lastupdate,invs_lastusr,price,cost,invs_status) ";
sSQL += "VALUES('" + InvCategory + "',";
sSQL += "'" + txt_ctg2.Text + "',";
sSQL += "'" + txt_name2.Text + "','0','0','0',";
sSQL += "'" + txt_safeqty2.Text + "',";
sSQL += "'" + DateTime.Now.ToString("yyyy-MM-dd") + "',";
sSQL += "'" + Session["USER_NAME"].ToString() + "',";
sSQL += "'" + txt_price2.Text + "',";
sSQL += "'" + txt_cost2.Text + "','Y')";
db.Excute(sSQL);
LoadGridPanelStock();
Common._NotificationShow("材料入庫,存盘成功!");
txt_ctg2.Text = "";
txt_name2.Text = "";
txt_safeqty2.Text = "";
txt_price2.Text = "";
txt_cost2.Text = "";
}
catch (Exception ex)
{
Common._ErrorMsgShow("材料入庫,存盘失败");
}
Window2.Close();
}
protected void Cancel(object sender, AjaxEventArgs e)
{
Window2.Close();
}
public void Close(vsSaveChanges SaveChanges)
{
_window.Close(SaveChanges);
}
