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;
}
}
