110,536
社区成员
发帖
与我相关
我的任务
分享
trans = con.BeginTransaction();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
int gpID = int.Parse(((Label)GridView1.Rows[i].FindControl("Label1")).Text.ToString().Trim());
string gpName = ((Label)GridView1.Rows[i].FindControl("Label2")).Text.ToString().Trim();
int gjpgwid = int.Parse(lbl_dxfdx.Text.ToString().Trim());
string gpjpgw = ((Label)GridView1.Rows[i].FindControl("Label3")).Text.ToString().Trim();
int gpwlb = int.Parse(((TextBox)GridView1.Rows[i].FindControl("TextBox1")).Text.ToString().Trim());
float gszdf = float.Parse(((TextBox)GridView1.Rows[i].FindControl("TextBox2")).Text.ToString().Trim());
int gmzpc = int.Parse(((DropDownList)GridView1.Rows[i].FindControl("ddl_mzpc")).SelectedValue.ToString().Trim());
// int gmztj = int.Parse(((DropDownList)GridView1.Rows[i].FindControl("DropDownList2")).SelectedValue.ToString().Trim());
// HtmlSelect select = (HtmlSelect)GridView1.Rows[i].Cells[6].FindControl("Select_mztj");
int gmztj = int.Parse(((HtmlSelect)GridView1.Rows[i].FindControl("Select_mztj")).Value.ToString().Trim());
//int gvote =int.Parse(((RadioButtonList)GridView1.Rows[i].FindControl("rbtnlist_vote")).SelectedValue.ToString().Trim());//是否有效票
string sgdate = ((Label)GridView1.Rows[i].FindControl("lbl_date")).Text.ToString().Trim();
string name = Session["userName"].ToString().Trim(); ;
DateTime gdate = DateTime.Parse(sgdate);
string stime = gdate.ToString("yyyyMMdd");
string sortid = (name + stime + gjpgwid).ToString().Trim();
//string qstring1 = "select * from t_rbasedata where sortid='" + sortid + "'";
//DataTable dt = BaseDate.returnTable(qstring1);
//if (dt.Rows.Count > 0)
//{
// GridView1.Enabled = false;
// btn_save.Enabled = false;
// Response.Write("<script language = 'javascript'> alert('不能重复投票!') </script>");
// return;
//}
string InsertString = "INSERT INTO [t_rbasedata] ([sortID],[pID], [pName], [pjpgwid], [pjpgw], [pdblb], [pszdf], [pmzcp], [pmztj],[pdate]) VALUES ('" + sortid + "'," +
gpID + ",'" + gpName + "'," + gjpgwid + ",'" + gpjpgw + "'," + gpwlb + "," + gszdf + "," + gmzpc + "," + gmztj + ",'" + gdate + "')";
cmd.Connection = con;
cmd.CommandText = InsertString;
cmd.Transaction = trans;
//SqlCommand cmd = new SqlCommand(InsertString,con);
cmd.ExecuteNonQuery();
//HtmlSelect select = (HtmlSelect)GridView1.Rows[i].Cells[6].FindControl("Select_mztj");
}
trans.Commit();
我是想通过检测sortID这个字段是否存在来判断表中是否已有相同的记录,不知我有没有说清楚。 求大神解答下。数据库是sqlserver