public string Search_Exp()
{
FrmBill frmBill = new FrmBill(this.FrmID);
GEEntitys rpts = new GEEntitys(this.FrmID);
string name = "数据导出";
string filename = frmBill.Name + "_" + BP.DA.DataType.CurrentDataTimeCNOfLong + ".xls";
string filePath = ExportDGToExcel(Search_Data(), rpts.GetNewEntity, null, null, filename);
return(filePath);
}
void btn_Click(object sender, EventArgs e)
{
GEEntitys rpts = (GEEntitys)BP.DA.ClassFactory.GetEns(this.EnsName);
GEEntity rpt = (GEEntity)rpts.GetNewEntity;
Flow fl = new Flow(this.FK_Flow);
Button btn = (Button)sender;
if (btn.ID == "Btn_Excel")
{
QueryObject qo = new QueryObject(rpts);
qo.AddWhere(WorkAttr.Rec, WebUser.No);
qo.addAnd();
if (BP.SystemConfig.AppCenterDBType == DBType.Access)
{
qo.AddWhere("Mid(RDT,1,10) >='" + this.DT_F + "' AND Mid(RDT,1,10) <='" + this.DT_T + "' ");
}
else
{
qo.AddWhere("" + BP.SystemConfig.AppCenterDBSubstringStr + "(RDT,1,10) >='" + this.DT_F + "' AND " + BP.SystemConfig.AppCenterDBSubstringStr + "(RDT,1,10) <='" + this.DT_T + "' ");
}
this.Pub2.BindPageIdx(qo.GetCount(), this.PageSize, this.PageIdx, "?FK_Flow=" + this.FK_Flow + "&EnsName=" + this.EnsName);
qo.DoQuery();
try
{
//this.ExportDGToExcel(ens.ToDataTableDescField(), this.HisEn.EnDesc);
this.ExportDGToExcel(rpts.ToDataTableDesc(), fl.Name);
}
catch (Exception ex)
{
try
{
this.ExportDGToExcel(rpts.ToDataTableDescField(), fl.Name);
}
catch
{
this.ToErrorPage("数据没有正确导出可能的原因之一是:系统管理员没正确的安装Excel组件，请通知他，参考安装说明书解决。@系统异常信息：" + ex.Message);
}
}
return;
}
this.Session["DF"] = this.Pub1.GetTextBoxByID("TB_F").Text;
this.Session["DT"] = this.Pub1.GetTextBoxByID("TB_T").Text;
this.Response.Redirect("FlowSearchMyWork.aspx?FK_Flow=" + this.FK_Flow + "&EnsName=" + this.EnsName, true);
}
/// <summary>
/// 得到一个实体
/// </summary>
/// <param name="className">类名称</param>
/// <returns>En</returns>
public static Entities GetEns(string className)
{
if (className.Contains(".") == false)
{
GEEntitys myens = new GEEntitys(className);
return(myens);
}
if (Htable_Ens == null || Htable_Ens.Count == 0)
{
Htable_Ens = new Hashtable();
string cl = "BP.En.Entities";
ArrayList al = ClassFactory.GetObjects(cl);
Htable_Ens.Clear();
foreach (Entities en in al)
{
if (en.ToString() == null)
{
continue;
}
try
{
Htable_Ens.Add(en.ToString(), en);
}
catch
{
}
}
}
Entities ens = Htable_Ens[className] as Entities;
#warning 会清除 cash 中的数据。
//if (ens != null)
// ens.Clear();
return(ens);
}
protected void Page_Load(object sender, EventArgs e)
{
Flow fl = new Flow(this.FK_Flow);
this.Page.Title = fl.Name;
GEEntitys rpts = (GEEntitys)BP.DA.ClassFactory.GetEns(this.EnsName);
GEEntity rpt = (GEEntity)rpts.GetNewEntity;
QueryObject qo = new QueryObject(rpts);
try
{
qo.AddWhere(GERptAttr.FlowEmps, " LIKE ", "'%@" + WebUser.No + "%'");
qo.addAnd();
qo.AddWhere("" + BP.SystemConfig.AppCenterDBSubstringStr + "(RDT,1,10) >='" + this.DT_F + "' AND " + BP.SystemConfig.AppCenterDBSubstringStr + "(RDT,1,10) <='" + this.DT_T + "' ");
this.Pub2.BindPageIdx(qo.GetCount(), this.PageSize, this.PageIdx, "FlowSearchMyWork.aspx?EnsName=" + this.EnsName + "&FK_Flow=" + this.FK_Flow);
qo.DoQuery("OID", this.PageSize, this.PageIdx);
}
catch (Exception ex)
{
if (this.Request.QueryString["error"] == null)
{
fl.CheckRpt();
this.Response.Redirect(this.Request.RawUrl + "&error=1", true);
return;
}
throw ex;
}
// this.Response.Write(qo.SQL);
// 生成页面数据。
Attrs attrs = BP.WF.Glo.AttrsOfRpt; // rpt.EnMap.Attrs;
int colspan = 2;
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
colspan++;
}
this.Pub1.AddTable("width='100%' align=left ");
this.Pub1.AddCaptionLeft("流程查询:" + fl.Name);
this.Pub1.AddTRSum();
this.Pub1.Add("<TD colspan=" + colspan + " class=ToolBar><b>发生日期 从:</b>");
TextBox tb = new TextBox();
tb.ID = "TB_F";
tb.Columns = 10;
tb.Text = this.DT_F;
tb.Attributes["onfocus"] = "WdatePicker();";
this.Pub1.Add(tb);
this.Pub1.AddB(" 到:");
tb = new TextBox();
tb.ID = "TB_T";
tb.Text = this.DT_T;
tb.Columns = 10;
this.Pub1.Add(tb);
this.Pub1.AddB(" ");
Button btn = new Button();
btn.Text = "查询";
btn.CssClass = "Btn";
btn.ID = "Btn_Search";
btn.Click += new EventHandler(btn_Click);
tb.Attributes["onfocus"] = "WdatePicker();";
this.Pub1.Add(btn);
btn = new Button();
btn.Text = "导出Excel";
btn.CssClass = "Btn";
btn.ID = "Btn_Excel";
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
this.Pub1.Add(" </TD>");
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDTitle("序");
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
this.Pub1.AddTDTitle("nowarp=true", attr.Desc);
}
this.Pub1.AddTDTitle("nowarp=true", "操作");
this.Pub1.AddTREnd();
int idx = 0;
bool is1 = false;
foreach (GEEntity en in rpts)
{
idx++;
is1 = this.Pub1.AddTR(is1);
this.Pub1.AddTD(idx);
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
if (attr.Key == "Title")
{
this.Pub1.AddTD("<a href=\"./../WF/WFRpt.aspx?WorkID=" + en.GetValIntByKey("OID") + "&FID=" + en.GetValByKey("FID") + "&FK_Flow=" + this.FK_Flow + "\" target=bk >" + en.GetValStrByKey(attr.Key) + "</a>");
continue;
}
if (attr.Key == "WFState")
{
switch (en.GetValIntByKey(attr.Key))
{
case 0:
this.Pub1.AddTD("进行中");
break;
case 1:
this.Pub1.AddTD("完成");
break;
}
continue;
}
switch (attr.MyDataType)
{
case DataType.AppBoolean:
this.Pub1.AddTD(en.GetValBoolStrByKey(attr.Key));
break;
case DataType.AppFloat:
case DataType.AppDouble:
this.Pub1.AddTD(en.GetValFloatByKey(attr.Key));
break;
case DataType.AppInt:
if (attr.UIContralType == UIContralType.DDL)
{
this.Pub1.AddTD(en.GetValRefTextByKey(attr.Key));
}
else
{
this.Pub1.AddTD(en.GetValIntByKey(attr.Key));
}
break;
case DataType.AppMoney:
this.Pub1.AddTDMoney(en.GetValDecimalByKey(attr.Key));
break;
default:
this.Pub1.AddTD(en.GetValStringByKey(attr.Key));
break;
}
}
this.Pub1.AddTD("<a href=\"./../WF/WFRpt.aspx?WorkID=" + en.GetValIntByKey("OID") + "&FID=" + en.GetValByKey("FID") + "&FK_Flow=" + this.FK_Flow + "\" target=bk >报告</a>-<a href=\"./../WF/Chart.aspx?WorkID=" + en.GetValIntByKey("OID") + "&FID=" + en.GetValByKey("FID") + "&FK_Flow=" + this.FK_Flow + "\" target=bk >轨迹</a>");
this.Pub1.AddTREnd();
}
this.Pub1.AddTRSum();
this.Pub1.AddTD("");
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
this.Pub1.AddTD();
continue;
}
this.Pub1.AddTD();
this.Pub1.AddTREnd();
this.Pub1.AddTableEnd();
}
public string ImpData_Done()
{
HttpFileCollection files = context.Request.Files;
if (files.Count == 0)
{
return("err@请选择要导入的数据信息。");
}
string errInfo = "";
string ext = ".xls";
string fileName = System.IO.Path.GetFileName(files[0].FileName);
if (fileName.Contains(".xlsx"))
{
ext = ".xlsx";
}
//设置文件名
string fileNewName = DateTime.Now.ToString("yyyyMMddHHmmssff") + ext;
//文件存放路径
string filePath = BP.Sys.SystemConfig.PathOfTemp + "\\" + fileNewName;
files[0].SaveAs(filePath);
//从excel里面获得数据表.
DataTable dt = BP.DA.DBLoad.ReadExcelFileToDataTable(filePath);
//删除临时文件
System.IO.File.Delete(filePath);
if (dt.Rows.Count == 0)
{
return("err@无导入的数据");
}
//获得entity.
FrmBill bill = new FrmBill(this.FrmID);
GEEntitys rpts = new GEEntitys(this.FrmID);
GERpt en = new GERpt(this.FrmID);
string noColName = ""; //实体列的编号名称.
string nameColName = ""; //实体列的名字名称.
BP.En.Map map = en.EnMap;
Attr attr = map.GetAttrByKey("BillNo");
noColName = attr.Desc; //
String codeStruct = bill.EnMap.CodeStruct;
attr = map.GetAttrByKey("Title");
nameColName = attr.Desc; //
//定义属性.
Attrs attrs = map.Attrs;
int impWay = this.GetRequestValInt("ImpWay");
#region 清空方式导入.
//清空方式导入.
int count = 0; //导入的行数
int changeCount = 0; //更新的行数
String successInfo = "";
if (impWay == 0)
{
rpts.ClearTable();
foreach (DataRow dr in dt.Rows)
{
string no = dr[noColName].ToString();
string name = dr[nameColName].ToString();
//判断是否是自增序列，序列的格式
if (!DataType.IsNullOrEmpty(codeStruct))
{
no = no.PadLeft(System.Int32.Parse(codeStruct), '0');
}
GERpt myen = new BP.WF.Data.GERpt(this.FrmID);
myen.SetValByKey("BillNo", no);
if (myen.Retrieve("BillNo", no) == 1)
{
errInfo += "err@编号[" + no + "][" + name + "]重复.";
continue;
}
//给实体赋值
errInfo += SetEntityAttrVal(no, dr, attrs, myen, dt, 0);
count++;
successInfo += " <span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的导入成功</span><br/>";
}
}
#endregion 清空方式导入.
#region 更新方式导入
if (impWay == 1 || impWay == 2)
{
foreach (DataRow dr in dt.Rows)
{
string no = dr[noColName].ToString();
string name = dr[nameColName].ToString();
//判断是否是自增序列，序列的格式
if (!DataType.IsNullOrEmpty(codeStruct))
{
no = no.PadLeft(System.Int32.Parse(codeStruct), '0');
}
GERpt myen = rpts.GetNewEntity as GERpt;
myen.SetValByKey("BillNo", no);
if (myen.Retrieve("BillNo", no) == 1)
{
//给实体赋值
errInfo += SetEntityAttrVal(no, dr, attrs, myen, dt, 1);
changeCount++;
successInfo += " <span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的更新成功</span><br/>";
continue;
}
//给实体赋值
errInfo += SetEntityAttrVal(no, dr, attrs, myen, dt, 0);
count++;
successInfo += " <span>" + noColName + "为" + no + "," + nameColName + "为" + name + "的导入成功</span><br/>";
}
}
#endregion
return("errInfo=" + errInfo + "@Split" + "count=" + count + "@Split" + "successInfo=" + successInfo + "@Split" + "changeCount=" + changeCount);
}
public DataTable Search_Data()
{
DataSet ds = new DataSet();
#region 查询语句
MapData md = new MapData(this.FrmID);
//取出来查询条件.
BP.Sys.UserRegedit ur = new UserRegedit();
ur.MyPK = WebUser.No + "_" + this.FrmID + "_SearchAttrs";
ur.RetrieveFromDBSources();
GEEntitys rpts = new GEEntitys(this.FrmID);
Attrs attrs = rpts.GetNewEntity.EnMap.Attrs;
QueryObject qo = new QueryObject(rpts);
#region 关键字字段.
string keyWord = ur.SearchKey;
if (md.GetParaBoolen("IsSearchKey") && DataType.IsNullOrEmpty(keyWord) == false && keyWord.Length >= 1)
{
Attr attrPK = new Attr();
foreach (Attr attr in attrs)
{
if (attr.IsPK)
{
attrPK = attr;
break;
}
}
int i = 0;
string enumKey = ","; //求出枚举值外键.
foreach (Attr attr in attrs)
{
switch (attr.MyFieldType)
{
case FieldType.Enum:
enumKey = "," + attr.Key + "Text,";
break;
case FieldType.FK:
continue;
default:
break;
}
if (attr.MyDataType != DataType.AppString)
{
continue;
}
//排除枚举值关联refText.
if (attr.MyFieldType == FieldType.RefText)
{
if (enumKey.Contains("," + attr.Key + ",") == true)
{
continue;
}
}
if (attr.Key == "FK_Dept")
{
continue;
}
i++;
if (i == 1)
{
/* 第一次进来。 */
qo.addLeftBracket();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere(attr.Key, " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? (" CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : (" '%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere(attr.Key, " LIKE ", " '%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
continue;
}
qo.addOr();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere(attr.Key, " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? ("CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : ("'%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere(attr.Key, " LIKE ", "'%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
}
qo.MyParas.Add("SKey", keyWord);
qo.addRightBracket();
}
else
{
qo.AddHD();
}
#endregion 关键字段查询
#region 时间段的查询
if (md.GetParaInt("DTSearchWay") != (int)DTSearchWay.None && DataType.IsNullOrEmpty(ur.DTFrom) == false)
{
string dtFrom = ur.DTFrom; // this.GetTBByID("TB_S_From").Text.Trim().Replace("/", "-");
string dtTo = ur.DTTo; // this.GetTBByID("TB_S_To").Text.Trim().Replace("/", "-");
//按日期查询
if (md.GetParaInt("DTSearchWay") == (int)DTSearchWay.ByDate)
{
qo.addAnd();
qo.addLeftBracket();
dtTo += " 23:59:59";
qo.SQL = md.GetParaString("DTSearchKey") + " >= '" + dtFrom + "'";
qo.addAnd();
qo.SQL = md.GetParaString("DTSearchKey") + " <= '" + dtTo + "'";
qo.addRightBracket();
}
if (md.GetParaInt("DTSearchWay") == (int)DTSearchWay.ByDateTime)
{
//取前一天的24：00
if (dtFrom.Trim().Length == 10) //2017-09-30
{
dtFrom += " 00:00:00";
}
if (dtFrom.Trim().Length == 16) //2017-09-30 00:00
{
dtFrom += ":00";
}
dtFrom = DateTime.Parse(dtFrom).AddDays(-1).ToString("yyyy-MM-dd") + " 24:00";
if (dtTo.Trim().Length < 11 || dtTo.Trim().IndexOf(' ') == -1)
{
dtTo += " 24:00";
}
qo.addAnd();
qo.addLeftBracket();
qo.SQL = md.GetParaString("DTSearchKey") + " >= '" + dtFrom + "'";
qo.addAnd();
qo.SQL = md.GetParaString("DTSearchKey") + " <= '" + dtTo + "'";
qo.addRightBracket();
}
}
#endregion 时间段的查询
#region 外键或者枚举的查询
//获得关键字.
AtPara ap = new AtPara(ur.Vals);
foreach (string str in ap.HisHT.Keys)
{
var val = ap.GetValStrByKey(str);
if (val.Equals("all"))
{
continue;
}
qo.addAnd();
qo.addLeftBracket();
qo.AddWhere(str, ap.GetValStrByKey(str));
qo.addRightBracket();
}
#endregion 外键或者枚举的查询
#endregion 查询语句
qo.addOrderBy("OID");
return(qo.DoQueryToTable());
}
public string Search_Init()
{
DataSet ds = new DataSet();
#region 查询显示的列
MapAttrs mapattrs = new MapAttrs();
mapattrs.Retrieve(MapAttrAttr.FK_MapData, this.FrmID, MapAttrAttr.Idx);
DataRow row = null;
DataTable dt = new DataTable("Attrs");
dt.Columns.Add("KeyOfEn", typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Width", typeof(int));
dt.Columns.Add("UIContralType", typeof(int));
dt.Columns.Add("LGType", typeof(int));
//设置标题、单据号位于开始位置
foreach (MapAttr attr in mapattrs)
{
string searchVisable = attr.atPara.GetValStrByKey("SearchVisable");
if (searchVisable == "0")
{
continue;
}
if (attr.UIVisible == false)
{
continue;
}
row = dt.NewRow();
row["KeyOfEn"] = attr.KeyOfEn;
row["Name"] = attr.Name;
row["Width"] = attr.UIWidthInt;
row["UIContralType"] = attr.UIContralType;
row["LGType"] = attr.LGType;
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
#endregion 查询显示的列
#region 查询语句
MapData md = new MapData(this.FrmID);
//取出来查询条件.
BP.Sys.UserRegedit ur = new UserRegedit();
ur.MyPK = WebUser.No + "_" + this.FrmID + "_SearchAttrs";
ur.RetrieveFromDBSources();
GEEntitys rpts = new GEEntitys(this.FrmID);
Attrs attrs = rpts.GetNewEntity.EnMap.Attrs;
QueryObject qo = new QueryObject(rpts);
#region 关键字字段.
string keyWord = ur.SearchKey;
if (md.GetParaBoolen("IsSearchKey") && DataType.IsNullOrEmpty(keyWord) == false && keyWord.Length >= 1)
{
Attr attrPK = new Attr();
foreach (Attr attr in attrs)
{
if (attr.IsPK)
{
attrPK = attr;
break;
}
}
int i = 0;
string enumKey = ","; //求出枚举值外键.
foreach (Attr attr in attrs)
{
switch (attr.MyFieldType)
{
case FieldType.Enum:
enumKey = "," + attr.Key + "Text,";
break;
case FieldType.FK:
continue;
default:
break;
}
if (attr.MyDataType != DataType.AppString)
{
continue;
}
//排除枚举值关联refText.
if (attr.MyFieldType == FieldType.RefText)
{
if (enumKey.Contains("," + attr.Key + ",") == true)
{
continue;
}
}
if (attr.Key == "FK_Dept")
{
continue;
}
i++;
if (i == 1)
{
/* 第一次进来。 */
qo.addLeftBracket();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere(attr.Key, " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? (" CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : (" '%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere(attr.Key, " LIKE ", " '%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
continue;
}
qo.addOr();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere(attr.Key, " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? ("CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : ("'%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere(attr.Key, " LIKE ", "'%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
}
qo.MyParas.Add("SKey", keyWord);
qo.addRightBracket();
}
else
{
qo.AddHD();
}
#endregion 关键字段查询
#region 时间段的查询
if (md.GetParaInt("DTSearchWay") != (int)DTSearchWay.None && DataType.IsNullOrEmpty(ur.DTFrom) == false)
{
string dtFrom = ur.DTFrom; // this.GetTBByID("TB_S_From").Text.Trim().Replace("/", "-");
string dtTo = ur.DTTo; // this.GetTBByID("TB_S_To").Text.Trim().Replace("/", "-");
//按日期查询
if (md.GetParaInt("DTSearchWay") == (int)DTSearchWay.ByDate)
{
qo.addAnd();
qo.addLeftBracket();
dtTo += " 23:59:59";
qo.SQL = md.GetParaString("DTSearchKey") + " >= '" + dtFrom + "'";
qo.addAnd();
qo.SQL = md.GetParaString("DTSearchKey") + " <= '" + dtTo + "'";
qo.addRightBracket();
}
if (md.GetParaInt("DTSearchWay") == (int)DTSearchWay.ByDateTime)
{
//取前一天的24：00
if (dtFrom.Trim().Length == 10) //2017-09-30
{
dtFrom += " 00:00:00";
}
if (dtFrom.Trim().Length == 16) //2017-09-30 00:00
{
dtFrom += ":00";
}
dtFrom = DateTime.Parse(dtFrom).AddDays(-1).ToString("yyyy-MM-dd") + " 24:00";
if (dtTo.Trim().Length < 11 || dtTo.Trim().IndexOf(' ') == -1)
{
dtTo += " 24:00";
}
qo.addAnd();
qo.addLeftBracket();
qo.SQL = md.GetParaString("DTSearchKey") + " >= '" + dtFrom + "'";
qo.addAnd();
qo.SQL = md.GetParaString("DTSearchKey") + " <= '" + dtTo + "'";
qo.addRightBracket();
}
}
#endregion 时间段的查询
#region 外键或者枚举的查询
//获得关键字.
AtPara ap = new AtPara(ur.Vals);
foreach (string str in ap.HisHT.Keys)
{
var val = ap.GetValStrByKey(str);
if (val.Equals("all"))
{
continue;
}
qo.addAnd();
qo.addLeftBracket();
qo.AddWhere(str, ap.GetValStrByKey(str));
qo.addRightBracket();
}
#endregion 外键或者枚举的查询
#endregion 查询语句
//获得行数.
ur.SetPara("RecCount", qo.GetCount());
ur.Save();
qo.DoQuery("OID", this.PageSize, this.PageIdx);
DataTable mydt = rpts.ToDataTableField();
mydt.TableName = "DT";
ds.Tables.Add(mydt); //把数据加入里面.
return(BP.Tools.Json.ToJson(ds));
}
/// <summary>
/// 单据初始化
/// </summary>
/// <returns></returns>
public string RefBill_Init()
{
DataSet ds = new DataSet();
#region 查询显示的列
MapAttrs mapattrs = new MapAttrs();
mapattrs.Retrieve(MapAttrAttr.FK_MapData, this.FrmID, MapAttrAttr.Idx);
DataRow row = null;
DataTable dt = new DataTable("Attrs");
dt.Columns.Add("KeyOfEn", typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Width", typeof(int));
dt.Columns.Add("UIContralType", typeof(int));
dt.Columns.Add("LGType", typeof(int));
//设置标题、单据号位于开始位置
foreach (MapAttr attr in mapattrs)
{
string searchVisable = attr.atPara.GetValStrByKey("SearchVisable");
if (searchVisable == "0")
{
continue;
}
if (attr.UIVisible == false)
{
continue;
}
row = dt.NewRow();
row["KeyOfEn"] = attr.KeyOfEn;
row["Name"] = attr.Name;
row["Width"] = attr.UIWidthInt;
row["UIContralType"] = attr.UIContralType;
row["LGType"] = attr.LGType;
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
#endregion 查询显示的列
#region 查询语句
MapData md = new MapData(this.FrmID);
GEEntitys rpts = new GEEntitys(this.FrmID);
Attrs attrs = rpts.GetNewEntity.EnMap.Attrs;
QueryObject qo = new QueryObject(rpts);
#region 关键字字段.
string keyWord = this.GetRequestVal("SearchKey");
if (DataType.IsNullOrEmpty(keyWord) == false && keyWord.Length >= 1)
{
qo.addLeftBracket();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere("Title", " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? (" CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : (" '%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere("Title", " LIKE ", " '%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
qo.addOr();
if (SystemConfig.AppCenterDBVarStr == "@" || SystemConfig.AppCenterDBVarStr == "?")
{
qo.AddWhere("BillNo", " LIKE ", SystemConfig.AppCenterDBType == DBType.MySQL ? ("CONCAT('%'," + SystemConfig.AppCenterDBVarStr + "SKey,'%')") : ("'%'+" + SystemConfig.AppCenterDBVarStr + "SKey+'%'"));
}
else
{
qo.AddWhere("BillNo", " LIKE ", "'%'||" + SystemConfig.AppCenterDBVarStr + "SKey||'%'");
}
qo.MyParas.Add("SKey", keyWord);
qo.addRightBracket();
}
else
{
qo.AddHD();
}
#endregion 关键字段查询
#region 时间段的查询
string dtFrom = this.GetRequestVal("DTFrom");
string dtTo = this.GetRequestVal("DTTo");
if (DataType.IsNullOrEmpty(dtFrom) == false)
{
//取前一天的24：00
if (dtFrom.Trim().Length == 10) //2017-09-30
{
dtFrom += " 00:00:00";
}
if (dtFrom.Trim().Length == 16) //2017-09-30 00:00
{
dtFrom += ":00";
}
dtFrom = DateTime.Parse(dtFrom).AddDays(-1).ToString("yyyy-MM-dd") + " 24:00";
if (dtTo.Trim().Length < 11 || dtTo.Trim().IndexOf(' ') == -1)
{
dtTo += " 24:00";
}
qo.addAnd();
qo.addLeftBracket();
qo.SQL = " RDT>= '" + dtFrom + "'";
qo.addAnd();
qo.SQL = "RDT <= '" + dtTo + "'";
qo.addRightBracket();
}
#endregion 时间段的查询
qo.DoQuery("OID", this.PageSize, this.PageIdx);
#endregion
DataTable mydt = rpts.ToDataTableField();
mydt.TableName = "DT";
ds.Tables.Add(mydt); //把数据加入里面.
return(BP.Tools.Json.ToJson(ds));
}