protected void Page_Load(object sender, EventArgs e)
{
dr = eOleDB.getDataTable("select * from a_eke_sysModels where ModelID='" + modelid + "'").Select()[0];
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:6px;\">");
Response.Write("<b>搜索</b><br>");
Response.Write("设置列表搜索条件。");
Response.Write("</div> ");
}
Response.Write("<div style=\"margin:6px 0px 8px 0px;\">");
Response.Write(" 搜索列数：<input type=\"text\" value=\"" + dr["searchcolumncount"].ToString() + "\" oldvalue=\"" + dr["searchcolumncount"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'searchcolumncount');\" />");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(107);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("</div> ");
eList datalist = new eList("a_eke_sysModelConditions");
datalist.Where.Add("delTag=0 and ModelID='" + modelid + "'");
datalist.OrderBy.Add("show desc,px,addTime");
Rep.ItemDataBound += new RepeaterItemEventHandler(Rep_ItemDataBound);
datalist.Bind(Rep);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;//不输出，要在获取后设，不然取不到内容。
Response.Write(sw.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:8px;\">");
Response.Write("<b>导出</b><br>");
Response.Write("设置模块导出到Excel的列及宽度。");
Response.Write("</div> ");
}
eList datalist = new eList("a_eke_sysModelItems");
datalist.Where.Add("ModelID='" + modelid + "' and delTag=0");
datalist.OrderBy.Add("showExport desc,ExportOrder, addTime");
datalist.Bind(Rep);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;
Response.Write(sw.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
configName = eOleDB.getValue("select configName from ProductConfigs where ProductConfigID='" + PId + "'");
string sql = "";
if (act.Length == 0)
{
eList elist = new eList("a_eke_sysCheckUps");
elist.Where.Add("ModelID='" + PId + "' ");
elist.OrderBy.Add("px,addTime");
elist.Bind(Rep);
}
else
{
#region 获取数据
if (act == "getdata")
{
Response.Clear();
List();
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;
Response.Write(sw.ToString());
Response.End();
}
#endregion
#region 流程
#region 添加
if (act == "addcheckup")
{
eOleDB.Execute("insert into a_eke_sysCheckUps (ModelID) values ('" + PId + "')");
eJson json = new eJson();
json.Add("success", "1");
json.Add("message", "添加成功");
//Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
Response.Write(json.ToString());
Response.End();
}
#endregion
#region 修改动作
if (act == "setcheckup")
{
//拖动排序
if (item.ToLower() == "setorders")
{
string ids = eParameters.Form("ids");
string[] arr = ids.Split(",".ToCharArray());
for (int i = 0; i < arr.Length; i++)
{
value = (i + 1).ToString();
eOleDB.Execute("update a_eke_sysCheckUps set px='" + value + "' where ModelID='" + PId + "' and CheckupID='" + arr[i] + "'");
}
Response.End();
}
if (item.ToLower() == "px" && (value.Length == 0 || value == "0"))
{
value = "999999";
}
if (item.ToLower() == "backprocess")
{
value = eBase.decode(value);
}
eOleDB.Execute("update a_eke_sysCheckUps set " + item + "='" + value + "' where ModelID='" + PId + "' and CheckupID='" + eParameters.QueryString("CheckupID") + "'");
Response.End();
}
#endregion
#region 除
if (act == "delcheckup")
{
eOleDB.Execute("delete from a_eke_sysCheckUps where CheckupID='" + eParameters.QueryString("CheckupID") + "'");
Response.End();
}
#endregion
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:6px;\">");
Response.Write("<b>布局</b><br>");
Response.Write("为表单添加选项卡、面板、列显示顺序、跨行、跨列等。<br>");
Response.Write("建议完成表单所有功能再为表单布局。");
Response.Write("</div> ");
}
eList elist = new eList("a_eke_sysModelTabs");
elist.Where.Add("ModelID='" + modelid + "'");
elist.OrderBy.Add("px,addTime");
elist.Bind(RepTags);
eList elistg = new eList("a_eke_sysModelPanels");
elistg.Where.Add("ModelID='" + modelid + "'");
elistg.OrderBy.Add("px,addTime");
RepGroups.ItemDataBound += new RepeaterItemEventHandler(RepGroups_ItemDataBound);
elistg.Bind(RepGroups);
/*
* eList datalist = new eList("a_eke_sysModelItems");
* datalist.Where.Add("ModelID='" + modelid + "' and showadd=1");
* datalist.OrderBy.Add("case when ModelTabID Is Null then 1 else 0 end,case when ModelPanelID Is Null then 1 else 0 end ,addorder");
* RepColumns.ItemDataBound += new RepeaterItemEventHandler(RepColumns_ItemDataBound);
* datalist.Bind(RepColumns);
*/
#region 所有列
string sql = "SELECT d.mc as modelName,a.MC, a.ModelItemID,a.ModelTabID,a.ModelPanelID,a.addrowspan,a.addcolspan,a.addorder FROM a_eke_sysModelItems a ";
sql += " inner join a_eke_sysModels d on d.ModelID=a.ModelID ";
sql += " left join a_eke_sysModelTabs b on a.ModelTabID=b.ModelTabID ";
sql += " left join a_eke_sysModelPanels c on a.ModelPanelID=c.ModelPanelID ";
sql += " where a.ModelID='" + modelid + "' and a.showAdd=1 and a.controlType<>'hidden' ";
sql += " order by ISNULL(b.px,999999),ISNULL(c.px,999999),a.AddOrder, a.PX ";
sql = "select * from ";
sql += " (";
sql += " SELECT d.mc as modelName,a.MC, a.ModelItemID,a.ModelTabID,a.ModelPanelID,a.addrowspan,a.addcolspan,a.addorder,ISNULL(b.px,999999)as bpx,ISNULL(c.px,999999) as cpx,a.PX,a.addTime FROM a_eke_sysModelItems a ";
sql += " inner join a_eke_sysModels d on d.ModelID=a.ModelID";
sql += " left join a_eke_sysModelTabs b on a.ModelTabID=b.ModelTabID ";
sql += " left join a_eke_sysModelPanels c on a.ModelPanelID=c.ModelPanelID ";
sql += " where a.ModelID='" + modelid + "' and a.delTag=0 and a.showAdd=1 and a.controlType<>'hidden' ";
sql += " union ";
sql += " SELECT d.mc as modelName,a.MC, a.ModelItemID,a.ModelTabID,a.ModelPanelID,a.addrowspan,a.addcolspan,a.addorder,ISNULL(b.px,999999)as bpx,ISNULL(c.px,999999) as cpx,a.PX,a.addTime FROM a_eke_sysModelItems a ";
sql += " inner join a_eke_sysModels d on d.ModelID=a.ModelID";
sql += " left join a_eke_sysModelTabs b on a.ModelTabID=b.ModelTabID ";
sql += " left join a_eke_sysModelPanels c on a.ModelPanelID=c.ModelPanelID ";
sql += " where d.delTag=0 and d.ParentID ='" + modelid + "' and d.JoinMore=0 and a.showAdd=1 and a.controlType<>'hidden' ";
sql += " ) as t";
sql += " order by t.bpx,t.cpx,t.AddOrder,t.px,t.addTime";
// eBase.Writeln(sql);
DataTable dt = eOleDB.getDataTable(sql);
RepColumns.ItemDataBound += new RepeaterItemEventHandler(RepColumns_ItemDataBound);
RepColumns.DataSource = dt;
RepColumns.DataBind();
#endregion
#region 子模块
sql = "SELECT ModelID,ModelTabID,ModelPanelID,MC FROM a_eke_sysModels";
sql += " where ParentID='" + modelid + "' and JoinMore=1 and delTag=0";
sql += " order by addTime";
DataTable tb = eOleDB.getDataTable(sql);
RepModels.ItemDataBound += new RepeaterItemEventHandler(RepModels_ItemDataBound);
RepModels.DataSource = tb;
RepModels.DataBind();
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
DataRow dr = eOleDB.getDataTable("select b.Type as bType, a.* from a_eke_sysModels a left join a_eke_sysModels b on a.ParentID=b.ModelID where a.ModelID='" + modelid + "'").Select()[0];
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:6px;\">");
Response.Write("<b>列表</b><br>");
Response.Write("设置列表相关参数；显示列是否显示、显示顺序、显示宽度、高度、点击排序、自定义显示等相关参数。");
Response.Write("</div> ");
}
if (dr["bType"].ToString() == "1" && dr["JoinMore"].ToString() == "True")
{
Response.Write("窗口宽度：");
Response.Write("<input type=\"text\" value=\"" + dr["width"].ToString() + "\" oldvalue=\"" + dr["width"].ToString() + "\" class=\"edit\" style=\"width:90px;\" onBlur=\"setModel(this,'width');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(84);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 窗口高度：");
Response.Write("<input type=\"text\" value=\"" + dr["height"].ToString() + "\" oldvalue=\"" + dr["height"].ToString() + "\" class=\"edit\" style=\"width:90px;\" onBlur=\"setModel(this,'height');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(85);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 最少行数：");
Response.Write("<input type=\"text\" value=\"" + dr["minCount"].ToString() + "\" oldvalue=\"" + dr["minCount"].ToString() + "\" class=\"edit\" style=\"width:90px;\" onBlur=\"setModel(this,'mincount');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(86);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 最多行数：");
Response.Write("<input type=\"text\" value=\"" + dr["maxCount"].ToString() + "\" oldvalue=\"" + dr["maxCount"].ToString() + "\" class=\"edit\" style=\"width:90px;\" onBlur=\"setModel(this,'maxcount');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(87);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write("<br>");
}
Response.Write("<input type=\"checkbox\" name=\"customheight\" id=\"customheight\" onclick=\"setModel(this,'customheight');\"" + (dr["customheight"].ToString() == "True" ? " checked" : "") + " /><label for=\"customheight\">拖动行高</label>");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(88);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
//Response.Write("<input type=\"checkbox\" name=\"customwidth\" id=\"customwidth\" onclick=\"setModel(this,'customwidth');\"" + (dr["customwidth"].ToString() == "True" ? " checked" : "") + " /><label for=\"customwidth\">拖动列宽</label>");
Response.Write("<input type=\"checkbox\" name=\"customshow\" id=\"customshow\" onclick=\"setModel(this,'customshow');\"" + (dr["customshow"].ToString() == "True" ? " checked" : "") + " /><label for=\"customshow\">列显示隐藏菜单</label>"); //
//Response.Write("<input type=\"checkbox\" name=\"custommove\" id=\"custommove\" onclick=\"setModel(this,'custommove');\"" + (dr["custommove"].ToString() == "True" ? " checked" : "") + " /><label for=\"custommove\">拖动行位置</label>");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(89);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 默认分页大小：<input type=\"text\" value=\"" + dr["PageSize"].ToString() + "\" oldvalue=\"" + dr["PageSize"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'pagesize');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(90);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 默认分页大小(M)：<input type=\"text\" value=\"" + dr["mPageSize"].ToString() + "\" oldvalue=\"" + dr["mPageSize"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'mpagesize');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(91);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 默认行高：<input type=\"text\" value=\"" + dr["LineHeight"].ToString() + "\" oldvalue=\"" + dr["LineHeight"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'lineheight');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(92);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write(" 默认行高(M)：<input type=\"text\" value=\"" + dr["mLineHeight"].ToString() + "\" oldvalue=\"" + dr["mLineHeight"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'mlineheight');\" />");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(93);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write("<br>补充自定义列：");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(94);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write("<br>\r\n");
Response.Write("<textarea name=\"textarea\" style=\"width:90%;\" rows=\"4\" onBlur=\"setModel(this,'listfields');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["ListFields"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(dr["ListFields"].ToString()) + "</textarea>");
Response.Write("<br>\r\n");
//string value = eOleDB.getValue("select CondValue from a_eke_sysConditions where ModelID='" + modelid + "' and RoleID is null and UserID is null and delTag=0");
//Response.Write("模块条件：<br>");
//Response.Write("<input type=\"text\" value=\"" + System.Web.HttpUtility.HtmlEncode(value) + "\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(value) + "\" class=\"edit\" style=\"width:90%;\" onBlur=\"setModel(this,'modelcondition');\" /><br>");
//Response.Write("完整自定义列表查询：<br>");
//Response.Write("<textarea name=\"textarea\" style=\"width:90%;\" rows=\"4\" onBlur=\"setModel(this,'listsql');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["ListSQL"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(dr["ListSQL"].ToString()) + "</textarea><br>\r\n");
Response.Write("默认条件：");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(95);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write("<br>\r\n");
Response.Write("<input type=\"text\" value=\"" + System.Web.HttpUtility.HtmlEncode(dr["defaultcondition"].ToString()) + "\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["defaultcondition"].ToString()) + "\" class=\"edit\" style=\"width:90%;\" onBlur=\"setModel(this,'defaultcondition');\" />");
Response.Write("<br>\r\n");
Response.Write("默认排序：");
if (eBase.showHelp()) Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(96);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
Response.Write("<br>\r\n");
Response.Write("<input type=\"text\" value=\"" + System.Web.HttpUtility.HtmlEncode(dr["defaultorderby"].ToString()) + "\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["defaultorderby"].ToString()) + "\" class=\"edit\" style=\"width:90%;\" onBlur=\"setModel(this,'defaultorderby');\" />");
Response.Write("<br>\r\n");
eList datalist = new eList("a_eke_sysModelItems");
datalist.Where.Add("ModelID='" + modelid + "' and delTag=0");
datalist.OrderBy.Add("showlist desc,listorder,px");
datalist.Bind(Rep);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;//不输出，要在获取后设，不然取不到内容。
Response.Write(sw.ToString());
Response.End();
}
private void OpenToolStripMenuItem_Click(object sender, EventArgs exxx)
{
BrakeReading = false;
list_id = 0;
bool isParse = int.TryParse(textBox2.Text, out list_id);
if (!isParse)
{
MessageBox.Show("Please specify the list!");
return;
}
LastList = list_id;
bool tryparse2 = int.TryParse(textBox4.Text, out int version);
if (!tryparse2)
{
MessageBox.Show("Please specify an element version!");
return;
}
bool tryparse3 = int.TryParse(textBox3.Text, out int countx);
OpenFileDialog eLoad = new OpenFileDialog
{
Filter = "Elements File (*.data)|*.data|All Files (*.*)|*.*",
RestoreDirectory = false
};
if (eLoad.ShowDialog() == System.Windows.Forms.DialogResult.OK && File.Exists(eLoad.FileName))
{
GC.Collect();
sameFile = eLoad.FileName;
try
{
Blocked = true;
LastAddress = textBox1.Text;
eLC = new eListCollection();
eLC.progress_bar += Progress_bar;
eList[] Li = new eList[0];
Li = eLC.LoadEmptyConfigs(version);
eLC.Lists = Li;
listBox_items.Rows.Clear();
using (FileStream fs = File.OpenRead(eLoad.FileName))
{
using (BinaryReader br = new BinaryReader(fs))
{
int pos = Convert.ToInt32(textBox1.Text.ToUpper().Trim().Normalize(), 16);
br.BaseStream.Seek(pos, SeekOrigin.Begin);
for (int l = list_id; l < list_id + 1; l++)
{
eLC.Lists[l].elementValues = new SortedList <int, SortedList <int, object> >();
eLC.Lists[l].elementPosition = new SortedList <int, int>();
for (int e = 0; e < (tryparse3 && countx > 0 ? countx : 999999); e++)
{
eLC.Lists[l].elementValues[e] = new SortedList <int, object>();
Application.DoEvents();
Progress_bar("Read :" + e + "/" + 99999, e, 99999);
try
{
for (int f = 0; f < eLC.Lists[l].elementTypes.Length; f++)
{
eLC.Lists[l].elementValues[e][f] = eLC.ReadValue(br, eLC.Lists[l].elementTypes[f]);
if (eLC.Lists[l].elementFields[f] == "Name")
{
int id = Int32.Parse(eLC.Lists[l].elementValues[e][0].ToString());
bool isNegative = (id & (1 << 31)) != 0;
if (isNegative)
{
break;
}
listBox_items.Rows.Add(new object[] { id.ToString(), eLC.Lists[l].GetValue(e, f) });
if (checkBox1.Checked)
{
Application.DoEvents();
listBox_items.Rows[e].Selected = true;
listBox_items.CurrentCell = listBox_items.Rows[e].Cells[0];
}
}
}
eLC.Lists[l].elementPosition[e] = (Int32)br.BaseStream.Position;
textBox5.Text = eLC.Lists[l].elementPosition[e].ToString("X4").ToUpper();
}
catch
{
break;
}
if (BrakeReading)
{
break;
}
}
}
BrakeReading = false;
Blocked = false;
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
}
private void OpenSameFile()
{
list_id = 0;
bool isParse = int.TryParse(textBox2.Text, out list_id);
if (!isParse)
{
MessageBox.Show("Please specify the list!");
return;
}
bool tryparse2 = int.TryParse(textBox4.Text, out int version);
if (!tryparse2)
{
MessageBox.Show("Please specify an element version!");
return;
}
bool tryparse3 = int.TryParse(textBox3.Text, out int countx);
if (sameFile != null)
{
GC.Collect();
try
{
Blocked = true;
eLC = new eListCollection();
eList[] Li = new eList[0];
Li = eLC.LoadEmptyConfigs(version);
eLC.Lists = Li;
listBox_items.Rows.Clear();
using (FileStream fs = File.OpenRead(sameFile))
{
using (BinaryReader br = new BinaryReader(fs))
{
int pos = Convert.ToInt32(textBox1.Text.ToUpper().Trim().Normalize(), 16);
br.BaseStream.Seek(pos, SeekOrigin.Begin);
for (int l = list_id; l < list_id + 1; l++)
{
eLC.Lists[l].elementValues = new SortedList <int, SortedList <int, object> >();
eLC.Lists[l].elementPosition = new SortedList <int, int>();
for (int e = 0; e < (tryparse3 && countx > 0 ? countx : 999999); e++)
{
eLC.Lists[l].elementValues[e] = new SortedList <int, object>();
Application.DoEvents();
Progress_bar("Read :" + e + "/" + 99999, e, 99999);
try
{
for (int f = 0; f < eLC.Lists[l].elementTypes.Length; f++)
{
eLC.Lists[l].elementValues[e][f] = eLC.ReadValue(br, eLC.Lists[l].elementTypes[f]);
if (eLC.Lists[l].elementFields[f] == "Name")
{
int id = Int32.Parse(eLC.Lists[l].elementValues[e][0].ToString());
bool isNegative = (id & (1 << 31)) != 0;
if (isNegative)
{
break;
}
listBox_items.Rows.Add(new object[] { id.ToString(), eLC.Lists[l].GetValue(e, f) });
if (checkBox1.Checked)
{
Application.DoEvents();
listBox_items.Rows[e].Selected = true;
listBox_items.CurrentCell = listBox_items.Rows[e].Cells[0];
}
}
}
eLC.Lists[l].elementPosition[e] = (Int32)br.BaseStream.Position;
textBox5.Text = eLC.Lists[l].elementPosition[e].ToString("X4").ToUpper();
}
catch
{
break;
}
if (BrakeReading)
{
break;
}
}
}
BrakeReading = false;
Blocked = false;
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:8px;\">");
Response.Write("<b>动作</b><br>");
Response.Write("模块扩展功能需要执行的SQL语句。<br>");
Response.Write("</div> ");
}
eList elist = new eList("a_eke_sysActions");
elist.Where.Add("ModelID='" + modelid + "' ");
elist.OrderBy.Add("addTime");
elist.Bind(Rep);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;//不输出，要在获取后设，不然取不到内容。
Response.Write(sw.ToString());
DataTable tb = eOleDB.getDataTable("select AddSQL,EditSQL,DeleteSQL from a_eke_sysModels where ModelID='" + modelid + "'");
if (tb.Rows.Count > 0)
{
Response.Write("<dl class=\"ePanel\">\r\n");
Response.Write("<dt><h1 onclick=\"showPanel(this);\"><a href=\"javascript:;\" class=\"cur\" onfocus=\"this.blur();\"></a>添加完成执行SQL</h1></dt>\r\n");
Response.Write("<dd style=\"display:none;\">");
if (eBase.showHelp())
{
Response.Write("<img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(127);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;\">");
}
Response.Write(" <textarea name=\"textarea\" style=\"width:95%;\" cols=\"100\" rows=\"10\" onBlur=\"setModel(this,'addsql');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["AddSQL"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["AddSQL"].ToString()) + "</textarea><br>\r\n");
Response.Write("</dd>\r\n");
Response.Write("</dl>\r\n");
Response.Write("<dl class=\"ePanel\">\r\n");
Response.Write("<dt><h1 onclick=\"showPanel(this);\"><a href=\"javascript:;\" class=\"cur\" onfocus=\"this.blur();\"></a>修改完成执行SQL</h1></dt>\r\n");
Response.Write("<dd style=\"display:none;\">");
if (eBase.showHelp())
{
Response.Write("<img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(128);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;\">");
}
Response.Write(" <textarea name=\"textarea\" style=\"width:95%;\" cols=\"100\" rows=\"10\" onBlur=\"setModel(this,'editsql');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["EditSQL"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["EditSQL"].ToString()) + "</textarea><br>\r\n");
Response.Write("</dd>\r\n");
Response.Write("</dl>\r\n");
Response.Write("<dl class=\"ePanel\">\r\n");
Response.Write("<dt><h1 onclick=\"showPanel(this);\"><a href=\"javascript:;\" class=\"cur\" onfocus=\"this.blur();\"></a>删除完成执行SQL</h1></dt>\r\n");
Response.Write("<dd style=\"display:none;\">");
if (eBase.showHelp())
{
Response.Write("<img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(129);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;\">");
}
Response.Write(" <textarea name=\"textarea\" style=\"width:95%;\" cols=\"100\" rows=\"10\" onBlur=\"setModel(this,'deletesql');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["DeleteSQL"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(tb.Rows[0]["DeleteSQL"].ToString()) + "</textarea><br>\r\n");
Response.Write("</dd>\r\n");
Response.Write("</dl>\r\n");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
#region 1.不分页
eList elist1 = new eList("Demo_Persons");
elist1.Fields.Add("ID");//不添加则是取所有字段
elist1.Fields.Add("FullName,Height,addTime");
elist1.Rows = 3;
elist1.Where.Add("delTag=0");
elist1.OrderBy.Add("id desc");
elist1.Bind(Repeater1);
#endregion
#region 2.自定义分页
string ParaName = "pg";
int pg = (Request.QueryString["pg"] == null ? 1 : Convert.ToInt32(Request.QueryString["pg"]));
eList elist2 = new eList("Demo_Persons");
elist2.OrderBy.Add("id");
elist2.PageSize = 2;
elist2.Page = pg;
elist2.Bind(Repeater2);
string allkeys = eParameters.getAllKeys(ParaName);
string filename = eBase.getAspxFileName();
StringBuilder sb = new StringBuilder();
sb.Append("共<font color=\"#cc0000\">" + elist2.RecordsCount.ToString() + "</font>条数据 ");
sb.Append("分<font color=\"#cc0000\">" + elist2.PageCount.ToString() + "</font>页显示 ");
sb.Append("每页显示<font color=\"#cc0000\">" + elist2.PageSize.ToString() + "</font>条 ");
sb.Append("当前第<font color=\"#cc0000\">" + elist2.Page.ToString() + "</font>页 ");
if (pg < 2)
{
sb.Append("首页 上一页 ");
}
else
{
sb.Append("<a href=\"" + filename + "?" + (allkeys.Length > 0 ? allkeys + "&" : "") + ParaName + "=1\">首页</a> ");
sb.Append("<a href=\"" + filename + "?" + (allkeys.Length > 0 ? allkeys + "&" : "") + ParaName + "=" + (pg - 1).ToString() + "\">上一页</a> ");
}
if (pg < elist2.PageCount)
{
sb.Append("<a href=\"" + filename + "?" + (allkeys.Length > 0 ? allkeys + "&" : "") + ParaName + "=" + (pg + 1).ToString() + "\">下一页</a> ");
sb.Append("<a href=\"" + filename + "?" + (allkeys.Length > 0 ? allkeys + "&" : "") + ParaName + "=" + elist2.PageCount.ToString() + "\">尾页</a>");
}
else
{
sb.Append("下一页 尾页");
}
litPage.Text = sb.ToString();
#endregion
#region 3.分页控件
eList elist3 = new eList("Demo_Persons");
elist3.OrderBy.Add("id");
elist3.Bind(Repeater3, ePageControl1);
#endregion
#region 4.分页eListControl控件
eList elist4 = new eList("Demo_Persons");
elist4.OrderBy.Add("id");
elist4.Bind(eListControl1, ePageControl2);
#endregion
}
public Evil.Env genEnv(eList args)
{
return(new Evil.Env(env, fparams, args));
}
public eValue apply(eList args)
{
return(fn(args));
}
public eHashMap(eList lst)
{
value = new Dictionary <String, eValue>();
assoc_BANG(lst);
}
internal frmShowList(eList type)
{
Type = type;
InitializeComponent();
Forms.frmSC.ZZZSetPCKBEvs(this);
}
protected void Page_Load(object sender, EventArgs e)
{
DataRow dr = eOleDB.getDataTable("select * from a_eke_sysModels where ModelID='" + modelid + "'").Select()[0];
if (eBase.showHelp())
{
Response.Write("<div class=\"tips\" style=\"margin-bottom:6px;\">");
Response.Write("<b>基本设置</b><br>管理列在表单的添加、编辑、查看的基本参数。");
Response.Write("</div> ");
}
Response.Write(" 表单列数：<input type=\"text\" value=\"" + dr["AddColumnCount"].ToString() + "\" oldvalue=\"" + dr["AddColumnCount"].ToString() + "\" class=\"edit\" style=\"width:40px;\" onBlur=\"setModel(this,'addcolumncount');\" />");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(61);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("<br>");
//Response.Write(" 保存文本：<input type=\"text\" value=\"" + System.Web.HttpUtility.HtmlEncode(dr["TextFields"].ToString()) + "\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["TextFields"].ToString()) + "\" class=\"edit\" style=\"width:540px;\" onBlur=\"setModel(this,'textfields');\" />");
//Response.Write(" 模块权限：<input type=\"text\" value=\"" + System.Web.HttpUtility.HtmlEncode(dr["Power"].ToString()) + "\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["Power"].ToString()) + "\" class=\"edit\" style=\"width:540px;\" onBlur=\"setModel(this,'power');\" />");
Response.Write(" 保存文本：");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(62);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("<br>");
Response.Write("<textarea reload=\"true\" id=\"model_textfields\" jsonformat=\"[{"text":"表单Name","value":"frmName"},{"text":"字段编码","value":"Field"}]\" name=\"textarea\" style=\"width:80%;display:none;\" rows=\"2\" onBlur=\"setModel(this,'textfields');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["TextFields"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(dr["TextFields"].ToString()) + "</textarea>");
Response.Write("<img src=\"images/jsonedit.jpg\" style=\"cursor:pointer;margin-right:5px;\" align=\"absmiddle\" onclick=\"Json_Edit('model_textfields');\">");
Response.Write(getJsonText(dr["TextFields"].ToString(), "Field"));
Response.Write("<br>\r\n");
Response.Write(" 模块权限：");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(63);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("<br>");
Response.Write("<textarea reload=\"true\" id=\"model_power\" jsonformat=\"[{"text":"文本","value":"text"},{"text":"值","value":"value"}]\" name=\"textarea\" style=\"width:80%;display:none;\" rows=\"2\" onBlur=\"setModel(this,'power');\" oldvalue=\"" + System.Web.HttpUtility.HtmlEncode(dr["Power"].ToString()) + "\">" + System.Web.HttpUtility.HtmlEncode(dr["Power"].ToString()) + "</textarea>");
Response.Write("<img src=\"images/jsonedit.jpg\" style=\"cursor:pointer;margin-right:5px;\" align=\"absmiddle\" onclick=\"Json_Edit('model_power');\">");
Response.Write(getJsonText(dr["Power"].ToString(), "text"));
Response.Write("<br>\r\n");
Response.Write("<div style=\"padding:10px 0px 10px 0px;\">");
Response.Write("<input type=\"button\" name=\"Submit\" value=\"同步编码\" onclick=\"copyCode();\" />");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(64);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("<input type=\"button\" name=\"Submit\" value=\"还原编码\" onclick=\"restoreCode();\" style=\"margin-left:20px;\" />");
if (eBase.showHelp())
{
Response.Write(" <img src=\"images/help.gif\" align=\"absmiddle\" border=\"0\" onclick=\"showHelp(65);\" title=\"查看帮助\" alt=\"查看帮助\" style=\"cursor:pointer;margin-bottom:4px;\">");
}
Response.Write("</div>");
eList datalist = new eList("a_eke_sysModelItems");
datalist.Where.Add("ModelID='" + modelid + "' and delTag=0 and (Custom=0 or len(ProgrameFile)>0)");
datalist.OrderBy.Add("showadd desc,addorder, PX, addTime");
datalist.Bind(Rep);
eList elist = new eList("a_eke_sysModelItems");
elist.Where.Add("ModelID='" + modelid + "' and Custom=1");
elist.OrderBy.Add("px,addTime");
elist.Bind(RepCustom);
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Rep.RenderControl(htw);
Rep.Visible = false;//不输出，要在获取后设，不然取不到内容。
Response.Write(sw.ToString());
Response.Write("<strong>自定义列：</strong><br />");
sw = new System.IO.StringWriter();
htw = new HtmlTextWriter(sw);
RepCustom.RenderControl(htw);
RepCustom.Visible = false;
Response.Write(sw.ToString());
Response.End();
}
