关于网友提出的“C#库存简单问题”问题疑问,本网通过在网上对“C#库存简单问题”有关的相关答案进行了整理,供用户进行参考,详细问题解答如下:
问题:C#库存简单问题
描述:c#
protected void Button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(Session["snum"]) > Convert.ToInt32(Session["waringup"]))
{
Response.Write("");
Response.End();
}
string CommodityId = this.CommodityId.Text.ToString();
string CompanyId = this.CompanyId.Value.ToString();
int Number = Math.Abs(Convert.ToInt32(this.Number.Text));
int Pirce = Math.Abs(Convert.ToInt32(this.Pirce.Text));
string SettlementType = this.SettlementType.Text.ToString();
int Payment = Math.Abs(Convert.ToInt32(Request["Payment"]));
int FactPayment = Math.Abs(Convert.ToInt32(this.FactPayment.Text));
int NotPayment = Math.Abs(Convert.ToInt32(Request["NotPayment"]));
string ManageMan = this.ManageMan.Text.ToString();
string Username = Convert.ToString(Session["username"]);
string AddTime = Convert.ToString(DateTime.Now);
string Type = "进货信息";
//计算输入的金额是否正确
if (Number<0)
{
Response.Write("");
Response.End();
}
if (Number * Pirce < Payment)
{
Response.Write("");
Response.End();
}
SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
strcon.Open();
OrderTime1.Text = DateTime.Now.ToString();
SqlCommand scd = new SqlCommand("insert into tb_Stock (CommodityId,CompanyId,Number,Pirce,StockDate,SettlementType,Payment,FactPayment,NotPayment,ManageMan,Username,AddTime,Type)values('" + CommodityId + "','" + CompanyId + "','" + Number + "','" + Pirce + "','" + OrderTime1.Text + "','" + SettlementType + "','" + Payment + "','" + FactPayment + "','" + NotPayment + "','" + ManageMan + "','" + Username + "','" + AddTime + "','" + Type + "')", strcon);
scd.ExecuteNonQuery();
strcon.Close();
Response.Write("