三种方法保存动态增加的相同数据结构的数据

方法一：XML

首先，在前台把动态增加的表格中的数据赋给隐藏域，即：document.getElementById("datas").value=s;

其次，在后台编写“确定”按钮的点击事件，如下：

protected void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e){ DataTable dt = GetPAddTable(datas.Value); if (dt.Rows.Count <= 0) { return; } model.Add(dt);}public DataTable GetPAddTable(string datas){ DataTable dt = new DataTable(); try { dt.Columns.Add("stcd"); dt.Columns.Add("sid"); dt.Columns.Add("TS"); dt.Columns.Add("HD"); dt.Columns.Add("TType"); dt.Columns.Add("NT"); XmlDocument doc = new XmlDocument(); doc.LoadXml(datas); XmlNode root = doc.DocumentElement; for (int i = 0; i < root.ChildNodes.Count; i++)//行数 { XmlNode row = root.ChildNodes[i];//第i行 if (row != null) { DataRow dr = dt.NewRow(); dr["stcd"] = stcdval.Value; dr["sid"] = i.ToString(); if (row.ChildNodes[0].FirstChild.Value.Trim() != "*") dr["TS"] = System.Convert.ToDecimal(row.ChildNodes[0].FirstChild.Value); if (row.ChildNodes[1].FirstChild.Value.Trim() != "*") dr["HD"] = System.Convert.ToDecimal(row.ChildNodes[1].FirstChild.Value); if (row.ChildNodes[2].FirstChild.Value.Trim() != "*") dr["TType"] = row.ChildNodes[2].FirstChild.Value; if (row.ChildNodes[3].FirstChild.Value.Trim() != "*") { if (row.ChildNodes[3].FirstChild.Value.Contains("*")) { dt.Clear(); break; } else dr["NT"] = row.ChildNodes[3].FirstChild.Value; } dt.Rows.Add(dr); } } } catch { } return dt.Copy();}

再次，在model.cs文件里添加Add()方法，如下：

public int Add(DataTable dt){ int flag=0; string sql = "INSERT INTO GW_PADD_B (stcd,sid,TS,HD,TType,NT)"; sql += "values(@stcd,@sid,@TS,@HD,@TType,@NT)"; SqlParameter[] pr=new SqlParameter[6]; SqlConnection sqlconn = new SqlConnection(conn); sqlconn.Open(); SqlTransaction st = sqlconn.BeginTransaction(); try { for (int i = 0; i < dt.Rows.Count; i++) { pr[0] = new SqlParameter("@stcd", dt.Rows[i]["stcd"].ToString().Trim()); pr[1] = new SqlParameter("@sid", decimal.Parse(dt.Rows[i]["sid"].ToString())); if (dt.Rows[i]["TS"].ToString().Length > 0) pr[2] = new SqlParameter("@TS", decimal.Parse(dt.Rows[i]["TS"].ToString())); else pr[2] = new SqlParameter("@TS", DBNull.Value); if (dt.Rows[i]["HD"].ToString().Length > 0) pr[3] = new SqlParameter("@HD", decimal.Parse(dt.Rows[i]["HD"].ToString())); else pr[3] = new SqlParameter("@HD", DBNull.Value); pr[4] = new SqlParameter("@TType",dt.Rows[i]["TType"].ToString()); pr[5] = new SqlParameter("@NT", dt.Rows[i]["NT"].ToString().Trim()); flag += SqlHelper.ExecuteNonQuery(sqlst, CommandType.Text, sql, pr); } if (flag == dt.Rows.Count) { flag = 1; st.Commit(); } else { flag = 0; st.Rollback(); } } catch (Exception ex) { st.Rollback(); Console.Write(ex.ToString()); flag = -1; } finally { sqlconn.Close(); } return flag;}

 

方法二：List<>

首先，在后台编写“确定”按钮的点击事件，如下：

protected void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e){ List<JSZJSLEntity> dataList = GetRLst(); model.Add(dataList);}List<JSZJSLEntity> GetRLst(){ List<JSZJSLEntity> rLst = new List<JSZJSLEntity>(); JSZJSLEntity myRInfo = null; //实体 TextBox myDataBox = null; //前台文本控件 DropDownList myRemark = null; //前台下拉框控件 DropDownList myRemark2 = null; //前台下拉框控件 for (int i = 1; i < tbData.Rows.Count; i++) { myDataBox = (TextBox)tbData.Rows[i].Cells[1].FindControl(String.Format("txt_{0}", i.ToString())); myRemark = (DropDownList)tbData.Rows[i].Cells[2].FindControl(String.Format("drpRemark_1_{0}", i.ToString())); myRemark2 = (DropDownList)tbData.Rows[i].Cells[2].FindControl(String.Format("drpRemark_2_{0}", i.ToString())); if (String.IsNullOrEmpty(myDataBox.Text.Trim()) && String.IsNullOrEmpty(myRemark.SelectedValue) && String.IsNullOrEmpty(myRemark2.SelectedValue)) continue; myRInfo = new JSZJSLEntity(); myRInfo.STCD = tempSTCD.Value; myRInfo.DT = DateTime.Parse(tbData.Rows[i].Cells[0].InnerHtml); myRInfo.P = myDataBox == null || String.IsNullOrEmpty(myDataBox.Text.Trim()) ? -99999 : decimal.Parse(myDataBox.Text.Trim()); string strCD=string .Empty ; strCD = myRemark.SelectedValue.Trim(); strCD += "," + myRemark2.SelectedValue.Trim(); myRInfo.PRCD = strCD; rLst.Add(myRInfo); } return rLst;}

其次，在model.cs文件中添加Add()方法，如下：

public int Add(List<JSZJSLEntity> dataList) { int flag = 0; SqlConnection con = null; SqlTransaction tran = null; try { con = new SqlConnection(conn); con.Open(); tran = con.BeginTransaction(); foreach (JSZJSLEntity enty in dataList) { flag += Add(enty,tran); } if (flag == dataList.Count) { tran.Commit(); flag = 1; } else tran.Rollback(); } catch (Exception) { tran.Rollback(); } finally { tran.Dispose(); con.Close(); } return flag;}public int Add(JSZJSLEntity entity,SqlTransaction tran){ int flag = 0; string sql = "INSERT INTO HY_DP_C (STCD,DT,P,PRCD)"; sql += "values(@STCD,@DT,@P,@PRCD)"; SqlParameter[] pr = new SqlParameter[4]; pr[0] = new SqlParameter("@STCD", entity.STCD); pr[1] = new SqlParameter("@DT", entity.DT); pr[2] = new SqlParameter("@P", entity.P); pr[3] = new SqlParameter("@PRCD", entity.PRCD); try { SqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, pr); flag = 1; } catch (Exception ex) { Console.Write(ex.ToString()); flag = -1; } return flag;}

 

方法三：拼SQL语句

首先，在后台编写“确定”按钮的点击事件，如下： protected void ImageButton1_Click(object sender, ImageClickEventArgs e){ string AddText=null; mRainInfo = new MRainInfo(); //实体 mRainInfo.Name = Name.Text ; mRainInfo.Code = "140000"; mRainInfo.memo = txtDemo.Text; if (bMonth.SelectedValue == "") { if (flood140000.Text.Trim() != "" && flood140000.Text.Trim().Length != 0) { mRainInfo.Rain = decimal.Parse(flood140000.Text); } else { mRainInfo.Rain = -1; } } else { mRainInfo.Rain = -1; } if(avgMRain140000.Text.Trim()!="" && avgMRain140000.Text.Trim().Length!=0) { mRainInfo.avgRain=decimal.Parse(avgMRain140000.Text); } else { mRainInfo.avgRain = -1; } AddText += mRain.AddText(mRainInfo); model.Add(AddText);}

其次，在mRain.cs文件中添加AddText()方法，如下：

public string AddText(object info){ enty = (MRainInfo)info; string strField=null; string strValue=null; strField += "name,Code, Rain,avgRain,memo,addType"; strValue += "'"+enty.Name+"','"+enty.Code+"'"; if(enty.Rain!=-1) { strValue +=","+enty.Rain; } else { strValue +=",null"; } if(enty.avgRain!=-1) { strValue +=","+enty.avgRain; } else { strValue +=",null"; } strValue +=",'"+enty.memo+"'"; strValue += ",'" + enty.addType + "'"; string strSql = "INSERT INTO t_b_MRain (" + strField +") VALUES (" + strValue + ");"; return strSql;}

再次，在model.cs文件中添加Add()方法，如下：

public bool ModifyDate(string updatetext){ SqlConnection sqlconn = new SqlConnection(this.connectionstr.ToString()); sqlconn.Open(); SqlCommand sqlcomm = sqlconn.CreateCommand(); SqlTransaction sqltrans=sqlconn.BeginTransaction();; sqlcomm.Connection = sqlconn; sqlcomm.Transaction = sqltrans; try { sqlcomm.CommandText = updatetext.ToString(); sqlcomm.ExecuteNonQuery(); sqltrans.Commit(); sqlconn.Close(); return true; } catch(SqlException e) { e.ToString(); sqltrans.Rollback(); return false; } }