ASP.NET关于重复产品插入提示“重复插入”该怎么修改
string pc_select=Pc_Select.SelectedItem.Text.ToString();
string price=Price.Text.ToString().Trim();
string numbers=Numbers.Text.ToString().Trim();
string company_select=Company_Select.SelectedItem.Text.ToString().Trim();
//string selltimes=SellTimes.Text.ToString().Trim();
//string discount=Discount.Text.ToString().Trim();
string prices = Price.Text.ToString().Trim();
//string deduct=Deduct.Text.ToString().Trim();
//string pricedifference=PriceDifference.Text.ToString().Trim();
string text=Texts.Text.ToString().Trim();
bool ADD;
if((price=="") ||(!GetDB.IsNum(price))){this.RegisterStartupScript("a1","<script language=javascript>alert('单价不能为空或者格式不正确！');document.all('Price').focus();<"+"/"+"script>");ADD=false;}
else if((numbers=="")||(!GetDB.IsNum(numbers))){this.RegisterStartupScript("b1","<script language=javascript>alert('数量不能为空或者格式不正确！');document.all('Numbers').focus();<"+"/"+"script>");ADD=false;}
else if(company_select==""){this.RegisterStartupScript("c1","<script language=javascript>alert('请添写客户名称！');document.all('Company_Select').focus();<"+"/"+"script>");ADD=false;}
//else if(selltimes==""){this.RegisterStartupScript("f1","<script language=javascript>alert('请选择购机时间！');document.all('SellTimes').focus();<"+"/"+"script>");ADD=false;}
//else if((discount=="") ||(!GetDB.IsNum(discount))){this.RegisterStartupScript("h1","<script language=javascript>alert('时尚扣点不能为空或者格式不正确！');document.all('Discount').focus();<"+"/"+"script>");ADD=false;}
//else if ((prices == "") || (!GetDB.IsNum(prices))) { this.RegisterStartupScript("i1", "<script language=javascript>alert('供价不能为空或者格式不正确！');document.all('Prices').focus();<" + "/" + "script>"); ADD = false; }
//else if((deduct=="") ||(!GetDB.IsNum(deduct))){this.RegisterStartupScript("j2","<script language=javascript>alert('提成不能为空或者格式不正确！');document.all('Deduct').focus();<"+"/"+"script>");ADD=false;}
else ADD=true;
//if(pricedifference=="") pricedifference="0";
//else if(!GetDB.IsNum(pricedifference)) {this.RegisterStartupScript("j3","<script language=javascript>alert('补差格式不正确！');document.all('Deduct').focus();<"+"/"+"script>");ADD=false;}
GetDB DD=new GetDB();
string SQL="Select * From Clients Where F_Name=N'"+company_select+"'";
string tel=DD.UserTest(SQL,"F_Tel");
string address=DD.UserTest(SQL,"F_Add");
if(ADD)
{
try
{
DataRow[] rs=DT.Select();
int num = rs.Length + 1;
DR = DT.NewRow();
DR[0] = num;
DR[1] = pc_select;
DR[2] = double.Parse(price);
DR[3] = numbers;
DR[4] = double.Parse(price) * double.Parse(numbers);
DR[5] = company_select;
//DR[6]=selltimes;
DR[6] = tel;
DR[7] = address;
//DR[9]=discount;
DR[8] = prices;
//DR[11]=deduct;
//DR[12]=pricedifference;
DR[9] = text;
DT.Rows.Add(DR);
DG.DataSource = DT;
DG.DataBind();
}
catch
{
Response.Write("<script language=javascript>alert('错误编号 [Stock-Add-1]');</script>");
}
finally
{
Price.Text="";
Numbers.Text="";
Company_Select.SelectedIndex = Company_Select.Items.IndexOf(Company_Select.Items.FindByText(company_select));
Company_Select.Visible=false;
CompanyTB.Visible=false;
//SellTimes.Text=selltimes;
//SellTimes.Visible=false;
BuyTimeTB.Visible=false;
Brs.Visible=false;
//Discount.Text="";
Prices.Text = "";
//Deduct.Text="";
//PriceDifference.Text="";
Texts.Text="";
}
}
}
