protected void Page_Load(object sender, EventArgs e)
{
if (Request["deleteFile"] == null)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
}
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelID"] != null)
{
valObj.SetValue(valObj.KeyID, Request["DelID"]);
int re = BLLTable <ITableImplement> .Factory(conn).Delete(valObj);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
ITableImplement cond = valObj;
cond.In(AttributeItem.Factory(cond.DataBaseTable.IDField), Request["DelKeyIDS"]);
int re = BLLTable <ITableImplement> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
valObj.SetValue(valObj.KeyID, Request["FieldKeyID"]);
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
valObj.SetValue(lstCol[i], Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <ITableImplement> .Factory(conn).Update(valObj, valObj.KeyID);
Response.Write("修改记录信息成功");
}
//删除本地文件
if (Request["deleteFile"] != null)
{
//string filepath=WebHelper.GetAppPath() + Request["fileName"];
string filepath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + Request["fileName"];;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
}
//分页AJAX请求
if (Request["paging"] != null)
{
int pageSize = 10; int pageIndex = 1; int count1 = -1;
pageIndex = Convert.ToInt32(HttpUtil.GetReqStrValue("pageIndex"));
int num = Convert.ToInt32(HttpUtil.GetReqStrValue("num"));;
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//父表的id
object id1 = HttpUtil.GetReqStrValue("id1");
string tableName1 = "关系表1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
// foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
//{
DataBaseTableRelation dr1 = valObj.DataBaseTable.SubTable_ChaZhao[num];
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List <Relation> lstRel = new List <Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List <ITableImplement> lstCond = new List <ITableImplement>();
lstCond.Add(cond2);
List <ITableImplement> lstOther = new List <ITableImplement>();
//显示明显表的 父表的信息
//value2.setConn(conn).setModule("WEC_QC_CARS");
List <ITableImplement> list2 = BLLTable <ITableImplement> .Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex, ref count1);
// BLLTable.SQL_Test.ToString();
if (list2.Count > 0)
{
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
}
}
}
}
catch (Exception ex)
{
}
Response.Write(sb.ToString());
}
//下载文件
if (Request["download"] != null)
{
string filename = Request["filename"];
string fullpath = Request.PhysicalApplicationPath + filename;
Response.ContentType = "APPLICATION/OCTET-STREAM";
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename.Substring(filename.LastIndexOf("/") + 1));
FileStream fs = new FileStream(fullpath, FileMode.Open);
int len = (int)fs.Length;
byte[] buf = new byte[len];
int count;
int sum = 0;
while ((count = fs.Read(buf, 0, len)) > 0)
{
sum += count;
Response.OutputStream.Write(buf, 0, count);
}
}
Response.End();
}