protected void action_Actioning(string Action) { eTable etable; string sql = ""; string ID = ""; switch (Action) { case "": litBody.Text = "无"; break; case "add": etable = new eTable("Demo_Persons"); etable.Fields.Add("FullName", "测试1"); etable.Fields.Add("Account", "test"); etable.Fields.Add("PassWord", eBase.GetMD5("123456", 16)); etable.Add(); litBody.Text = "添加成功,ID=" + etable.ID + "<br>\r\n"; litBody.Text += "所影响行:" + etable.Rows.ToString(); break; case "edit": sql = "select ID from Demo_Persons where delTag=0 order by ID desc"; //修改最后一条记录 ID = eOleDB.getValue(sql); etable = new eTable("Demo_Persons"); etable.Fields.Add("FullName", "修改后的姓名"); etable.Where.Add("ID=" + ID); etable.Update(); litBody.Text = "修改成功,ID=" + ID + "<br>\r\n"; litBody.Text += "所影响行:" + etable.Rows.ToString(); break; case "del": sql = "select ID from Demo_Persons where delTag=0 order by ID desc"; ID = eOleDB.getValue(sql); //要删除记录的ID etable = new eTable("Demo_Persons"); etable.Where.Add("id=" + ID); //etable.DeleteTrue();//真正删除 etable.Delete(); //假删除 litBody.Text = "删除成功,ID=" + ID + "<br>\r\n"; litBody.Text += "所影响行:" + etable.Rows.ToString(); break; } }
protected void Page_Load(object sender, EventArgs e) { Type type = HttpContext.Current.Handler.GetType();//CurrentHandler System.Reflection.FieldInfo fi = type.GetField("UserArea"); if (fi != null) { UserArea = fi.GetValue(Activator.CreateInstance(type)).ToString(); } act = eParameters.QueryString("act"); if (act.Length == 0) { act = eParameters.Request("act").ToLower(); } if (act.Length == 0) { return; } parentID = eParameters.QueryString("id"); eUser user = new eUser(UserArea); switch (act) { case "save": #region 保存 eTable tb = new eTable("Demo_Customs_PartOne", user); string json = eParameters.Form("eformdata_" + parentModelID); eJson jmodel = new eJson(json); jmodel.Convert = true; jmodel = jmodel.GetCollection("eformdata_" + parentModelID); eJson jrow = jmodel.Collection[0]; tb.Fields.Add("DZ", jrow.GetValue("ma_f1")); tb.Fields.Add("gddh", jrow.GetValue("ma_f2")); string tmp = jrow.GetValue("id"); if (tmp.Length > 0) { parentID = tmp; } string id = eOleDB.getValue("select PartOneID from Demo_Customs_PartOne where CustomID='" + parentID + "'"); if (id.Length == 0) { tb.Fields.Add("CustomID", parentID); tb.Add(); } else { tb.Where.Add("CustomID='" + parentID + "'"); tb.Update(); } #endregion break; case "del": eTable etb = new eTable("Demo_Customs_PartOne", user); etb.Where.Add("CustomID='" + parentID + "'"); etb.Delete(); break; default: #region 读取 DataTable dt = eOleDB.getDataTable("select dz,gddh from Demo_Customs_PartOne where CustomID='" + parentID + "' and delTag=0"); if (dt.Rows.Count > 0) { dz = dt.Rows[0]["DZ"].ToString(); gddh = dt.Rows[0]["GDDH"].ToString(); } #endregion break; } }
protected void Page_Load(object sender, EventArgs e) { Type type = HttpContext.Current.Handler.GetType();//CurrentHandler System.Reflection.FieldInfo fi = type.GetField("UserArea"); if (fi != null) { UserArea = fi.GetValue(Activator.CreateInstance(type)).ToString(); } act = eParameters.QueryString("act"); if (act.Length == 0) { act = eParameters.Request("act").ToLower(); } if (act.Length == 0) { return; } parentID = eParameters.QueryString("id"); eUser user = new eUser(UserArea); eTable etb; switch (act) { case "save": #region 保存 string jsonstr = eParameters.Form("eformdata_" + parentModelID); eJson json = new eJson(jsonstr); json.Convert = true; json = json.GetCollection("eformdata_" + parentModelID).GetCollection()[0]; json = json.GetCollection("eformdata_" + modelid); foreach (eJson jrow in json.GetCollection()) { string _ID = jrow.GetValue("ID"); string _Delete = jrow.GetValue("Delete"); string _xm = jrow.GetValue("m2_f1"); string _xb = jrow.GetValue("m2_f2"); string _dh = jrow.GetValue("m2_f3"); etb = new eTable("Demo_Customs_PartMore", user); if (_Delete.ToLower() == "true") { etb.Where.Add("PartMoreID='" + _ID + "'"); etb.Delete(); } else { etb.Fields.Add("XM", _xm); etb.Fields.Add("XB", _xb); etb.Fields.Add("DH", _dh); if (_ID.Length == 0) //添加 { etb.Fields.Add("CustomID", parentID); etb.Add(); } else //修改 { etb.Where.Add("PartMoreID='" + _ID + "'"); etb.Update(); } } } #endregion break; case "del": etb = new eTable("Demo_Customs_PartMore", user); etb.Where.Add("CustomID='" + parentID + "'"); etb.Delete(); break; } }