/// <summary>
/// 获取所有数据
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sql"></param>
/// <returns></returns>
public IList GetAllData(object args, string sql)
{
ExecSqlQuery queryEr = MVCNHibernateHelp.BuildSqlQuery(args, sql);
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(sql);
return(GetData(queryEr, sqlPart));
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <param name="request"></param>
/// <param name="queryEr"></param>
/// <param name="sql"></param>
/// <returns></returns>
public IList GetAllData(MVCRequest request, IDictionary <string, object> args, string sql)
{
ExecSqlQuery queryEr = MVCNHibernateHelp.BuildSqlQuery(args, sql);
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(request, sql);
return(GetData(queryEr, sqlPart));
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sqlPart"></param>
/// <returns></returns>
public IList GetData(ExecSqlQuery queryEr, SqlPart sqlPart)
{
queryEr.Sql = SqlPartHelp.ConvertToSqlString(sqlPart);
IList listData = Ht.ExecuteFind(queryEr);
return(listData);
}
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
try
{
if (Session["9100USER"].ToString() != "")
{
string sql = Session["9100USER"] as string;
SqlBgy.SelectCommand = sql;
SqlBgy.DataBind();
}
}
catch
{ }
try
{
if (Session["9100PART"].ToString() != "")
{
string sql = Session["9100PART"] as string;
SqlPart.SelectCommand = sql;
SqlPart.DataBind();
}
}
catch
{ }
}
/// <summary>
/// 将sql+request表达的部分，重新构建sql，考虑NHibernate参数为:的情况
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static SqlPart RefactorToSqlPart(string sql)
{
string sqlCopy = sql.Replace(":", "@");
SqlPart sqlPart = MVCRequestHelp.RefactorToSqlPart(sqlCopy);
sqlPart = ConvertSqlPart(sqlPart);
return(sqlPart);
}
/// <summary>
/// 将sqlPart中各部分:代表的参数名替换成@
/// </summary>
/// <param name="sqlPart"></param>
/// <returns></returns>
public static SqlPart ConvertSqlPart(SqlPart sqlPart)
{
SqlPart sqlPart1 = new SqlPart()
{
FieldsSqlPart = sqlPart.FieldsSqlPart.Replace("@", ":"), //参数符号替回来，如果传进来的是 @，正好替成:
FromSqlPart = sqlPart.FromSqlPart.Replace("@", ":"),
WhereSqlPart = sqlPart.WhereSqlPart.Replace("@", ":"),
OrderSqlPart = sqlPart.OrderSqlPart.Replace("@", ":")
};
return(sqlPart1);
}
public void TestCompoundExpression()
{
new ConcreteScalarSqlExpression <long>(
Sql,
Sql.Int(1)
.Concat(SqlPart.FromString("+"))
.Concat(Sql.Int(2))
.Tokens
)
.ToEmbeddedString()
.ShouldEqual("1 + 2");
}
//protected void ASPxCallbackPanel4_Callback(object sender, CallbackEventArgsBase e)
//{
// string[] param = e.Parameter.Split(',');
// string pcode = param[0];
// string qad = param[1];
// dataConn theDataConn = new dataConn(" select FUNC_GET_PLANSITE（'" + pcode + "','D'）from dual");
// theDataConn.OpenConn();
// string gQadSite = theDataConn.GetValue();
// if (qad == "false" || qad == "null")//若未勾选，显示所有实零件//|| qad == "null"
// {
// string sql = "select distinct pt_part part from copy_pt_mstr where pt_phantom=0";
// Session["9100PART"] = sql;
// SqlPart.SelectCommand = sql;
// SqlPart.DataBind();
// }
// else if (qad == "true")//若勾选，显示非QAD零件
// {
// string sql = "select distinct pt_part part from atpubkflpart where part_type='1' and gzdd='" + pcode + "' ";
// Session["9100PART"] = sql;
// //DataTable dt = dc.GetTable(sql);
// SqlPart.SelectCommand = sql;
// SqlPart.DataBind();
// }
//}
//protected void ASPxCallbackPanel3_Callback(object sender, CallbackEventArgsBase e)
//{
// string[] param = e.Parameter.Split(',');
// string pcode = param[0];
// string qad = param[1];
// // string strPmCode = ASPxGridView1.GetRowValues(ASPxGridView1.EditingRowVisibleIndex, new string[] { "PARAMETER_CODE" }).ToString();
// dataConn theDataConn = new dataConn(" select FUNC_GET_PLANSITE（'" + pcode + "','D'）from dual");
// theDataConn.OpenConn();
// string gQadSite = theDataConn.GetValue();
// if (gQadSite != "")
// {
// string sql = "select distinct in_user1 bgy from copy_in_mstr where upper(in_site)='" + gQadSite + "'";
// Session["9100USER"] = sql;
// SqlBgy.SelectCommand = sql;
// SqlBgy.DataBind();
// }
//}
protected void txtPart_Init(object sender, EventArgs e)
{
try
{
if (Session["9100PART"].ToString() != "")
{
string sql = Session["9100PART"] as string;
SqlPart.SelectCommand = sql;
SqlPart.DataBind();
}
}
catch
{ }
}
/// <summary>
/// 获取行数
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sqlPart"></param>
/// <returns></returns>
public int GetCount(ExecSqlQuery queryEr, SqlPart sqlPart)
{
int total = 0;
ExecSqlQuery countQuery = new ExecSqlQuery();
countQuery.Sql = SqlPartHelp.GetCountSql(sqlPart);
countQuery.ParamerList.AddRange(queryEr.ParamerList);
IList listCountData = Ht.ExecuteFind(countQuery);
if (listCountData != null && listCountData.Count > 0)
{
int.TryParse(Convert.ToString((listCountData[0] as Hashtable)["total"]), out total);
}
return(total);
}
/// <summary>
/// 获取EasyUIRequest对应的分页数据
/// </summary>
/// <param name="request"></param>
/// <param name="queryEr"></param>
/// <returns></returns>
public MVCPagerData GetPagerData(MVCRequest request, ExecSqlQuery queryEr)
{
#region 数据部分
string sql = queryEr.Sql;
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(request, sql);
IList listData = GetData(queryEr, sqlPart);
#endregion
#region count行数部分
//默认行数
int total = GetCount(queryEr, sqlPart);
#endregion
return(new MVCPagerData {
rows = listData, total = total
});
}
internal void Init()
{
this.Parameters = new Dictionary <string, object>();
this.SourceInfos = new Dictionary <object, SourceInfo>();
this.ColumnInfos = new Dictionary <MemberInfo, ColumnInfo>();
this.JoinInfos = new Dictionary <SourceInfo, List <JoinInfo> >();
this.AnonymousMemberMapper = new Dictionary <MemberInfo, MemberInfo>();
this.AnonymousTypeMapper = new Dictionary <Type, List <Type> >();
this.ParamIndex = 0;
this.SourceIndex = 0;
this.Size = null;
this.Skip = null;
this.SqlPart = new Dictionary <SqlPartEnum, List <string> >();
var e = Enum.GetValues(typeof(SqlPartEnum));
foreach (SqlPartEnum item in e)
{
SqlPart.Add(item, new List <string>());
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theUserName = theUserManager.getUserName();
theProgramCode = "inv9100";
if (!IsPostBack)
{
//Session["9100PART"] = "";
//Session["9100USER"] = "";
dataConn theDataConn1 = new dataConn(" select FUNC_GET_PLANSITE（'E','D'）from dual");
theDataConn1.OpenConn();
string gQadSite1 = theDataConn1.GetValue();
if (gQadSite1 != "")
{
string sql1 = "select distinct in_user1 bgy from copy_in_mstr where upper(in_site)='" + gQadSite1 + "'";
Session["9100USER"] = sql1;
SqlBgy.SelectCommand = sql1;
SqlBgy.DataBind();
sql1 = "select distinct pt_part part from copy_pt_mstr where pt_phantom=0";
Session["9100PART"] = sql1;
SqlPart.SelectCommand = sql1;
SqlPart.DataBind();
}
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit3.Date = DateTime.Now.AddDays(1);
}
initCode();
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", str2 = "", str = "";
string pcode = Request["PCode"].ToString().Trim();
string qad = Request["QAD"].ToString().Trim();
dataConn theDataConn = new dataConn(" select FUNC_GET_PLANSITE（'" + pcode + "','D'）from dual");
theDataConn.OpenConn();
string gQadSite = theDataConn.GetValue();
if (gQadSite != "")
{
string sql = "select distinct in_user1 bgy from copy_in_mstr where upper(in_site)='" + gQadSite + "'";
Session["9100USER"] = sql;
SqlBgy.SelectCommand = sql;
SqlBgy.DataBind();
}
if (qad == "false" || qad == "null")//若未勾选，显示所有实零件//|| qad == "null"
{
string sql = "select distinct pt_part part from copy_pt_mstr where pt_phantom=0";
Session["9100PART"] = sql;
SqlPart.SelectCommand = sql;
SqlPart.DataBind();
}
else if (qad == "true")//若勾选，显示非QAD零件
{
string sql = "select distinct part from atpubkflpart where part_type='1' and gzdd='" + pcode + "' ";
Session["9100PART"] = sql;
SqlPart.SelectCommand = sql;
SqlPart.DataBind();
}
this.Response.Write(str);
this.Response.End();
}
if (Request["opFlag"] == "getEditSeries2")
{
string str2 = "";
string part = Request["PART"].ToString().Trim();
string qad = Request["QAD"].ToString().Trim();
if (qad == "false" || qad == "null")//若未勾选
{
string sql = "select pt_desc2 from copy_pt_mstr where upper(pt_part)='" + part.ToUpper() + "'";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count == 0)
{
str2 = " ";
this.Response.Write(str2);
this.Response.End();
return;
}
str2 = dt.Rows[0][0].ToString();
}
else if (qad == "true")//若勾选
{
string sql = "select part_desc from atpubkflpart where upper(pt_part)='" + part.ToUpper() + "' ";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count == 0)
{
str2 = " ";
this.Response.Write(str2);
this.Response.End();
return;
}
str2 = dt.Rows[0][0].ToString();
}
this.Response.Write(str2);
this.Response.End();
}
setCondition();
Query();
}
