string str = ConfigurationSettings.AppSettings["dsn"];
SqlConnection con = new SqlConnection(str);
con.Open(); string sql = "select UseNum from InStore Where( ClassID= @ClassID)AND(UnitID=@UnitID)AND(ChanPinID= @ChanPinID )AND(GuiGeID=@GuiGeID)AND(EmpID=@EmpID)AND(RuChuID=1)";
SqlCommand com = new SqlCommand(sql, con);
com.Parameters.Add(new SqlParameter("@ClassID",SqlDbType .Int ));
com.Parameters["@ClassID"].Value = DropDownList1.Text;
com.Parameters.Add(new SqlParameter("@UnitID",SqlDbType.Int ));
com.Parameters["@UnitID"].Value = DropDownList2.Text;
com.Parameters.Add(new SqlParameter("@ChanPinID",SqlDbType .Int ));
com.Parameters["@ChanPinID"].Value = DropDownList3.Text;
com.Parameters.Add(new SqlParameter("@GuiGeID",SqlDbType.Int ));
com.Parameters["@GuiGeID"].Value = DropDownList5.Text;
com.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.Int));
com.Parameters["@EmpID"].Value = DropDownList6.Text;
com.Parameters.Add(new SqlParameter("@UpTime", SqlDbType.DateTime ));
com.Parameters["@UpTime"].Value = UpTimeTxt.Text;
com.Parameters.Add(new SqlParameter("@UsePrice", SqlDbType.Money ));
com.Parameters["@UsePrice"].Value = UsePriceTxt.Text;
com.Parameters.Add(new SqlParameter("@RuChuID", SqlDbType.Int));
com.Parameters["@RuChuID"].Value = DropDownList4.Text;
com.Parameters.Add(new SqlParameter("@UseNum", SqlDbType.Int));
com.Parameters["@UseNum"].Value = UseNumTxt.Text;
SqlDataReader myreader=com.ExecuteReader() ;
int aa=0;// 记录数
if (myreader.Read()) ??????为啥不为真啊!
{
bijiao = (int)myreader["UseNum"];
aa++;
}
string SqlInse="INSERT INTO InStore (Uptime, ClassID, UnitID, SupID, UsePrice, UseNum, RuChuID, GuiGeID, ChanPinID) VALUES ( @Uptime, @ClassID, @UnitID, @SupID, @UsePrice, @UseNum, @RuChuID, @GuiGeID, @ChanPinID)"; if (Convert .ToInt32 (UseNumTxt.Text) < bijiao)
{
Response.Redirect("kucunbugou.aspx"); //转一个页面,提示库存数不够。
}
else
{ SqlCommand cominsert = new SqlCommand(SqlInse, con);
cominsert.ExecuteNonQuery();
}
con.Close(); }问题;bijiao为我想要的数值?
SqlConnection con = new SqlConnection(str);
con.Open(); string sql = "select UseNum from InStore Where( ClassID= @ClassID)AND(UnitID=@UnitID)AND(ChanPinID= @ChanPinID )AND(GuiGeID=@GuiGeID)AND(EmpID=@EmpID)AND(RuChuID=1)";
SqlCommand com = new SqlCommand(sql, con);
com.Parameters.Add(new SqlParameter("@ClassID",SqlDbType .Int ));
com.Parameters["@ClassID"].Value = DropDownList1.Text;
com.Parameters.Add(new SqlParameter("@UnitID",SqlDbType.Int ));
com.Parameters["@UnitID"].Value = DropDownList2.Text;
com.Parameters.Add(new SqlParameter("@ChanPinID",SqlDbType .Int ));
com.Parameters["@ChanPinID"].Value = DropDownList3.Text;
com.Parameters.Add(new SqlParameter("@GuiGeID",SqlDbType.Int ));
com.Parameters["@GuiGeID"].Value = DropDownList5.Text;
com.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.Int));
com.Parameters["@EmpID"].Value = DropDownList6.Text;
com.Parameters.Add(new SqlParameter("@UpTime", SqlDbType.DateTime ));
com.Parameters["@UpTime"].Value = UpTimeTxt.Text;
com.Parameters.Add(new SqlParameter("@UsePrice", SqlDbType.Money ));
com.Parameters["@UsePrice"].Value = UsePriceTxt.Text;
com.Parameters.Add(new SqlParameter("@RuChuID", SqlDbType.Int));
com.Parameters["@RuChuID"].Value = DropDownList4.Text;
com.Parameters.Add(new SqlParameter("@UseNum", SqlDbType.Int));
com.Parameters["@UseNum"].Value = UseNumTxt.Text;
SqlDataReader myreader=com.ExecuteReader() ;
int aa=0;// 记录数
if (myreader.Read()) ??????为啥不为真啊!
{
bijiao = (int)myreader["UseNum"];
aa++;
}
string SqlInse="INSERT INTO InStore (Uptime, ClassID, UnitID, SupID, UsePrice, UseNum, RuChuID, GuiGeID, ChanPinID) VALUES ( @Uptime, @ClassID, @UnitID, @SupID, @UsePrice, @UseNum, @RuChuID, @GuiGeID, @ChanPinID)"; if (Convert .ToInt32 (UseNumTxt.Text) < bijiao)
{
Response.Redirect("kucunbugou.aspx"); //转一个页面,提示库存数不够。
}
else
{ SqlCommand cominsert = new SqlCommand(SqlInse, con);
cominsert.ExecuteNonQuery();
}
con.Close(); }问题;bijiao为我想要的数值?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货