public QcmaininfoModelList GetModels(string QualityCode, string Status, string Sourcing, string CustomerCode,
int BfGmmm, int AfGmmm, string MaterialGroup, string DyeMethod, string Pattern, string Finish, string Con, string Creator, string CustomerQualityId,
string Sales, string SalesTeam, DateTime BeginCreateDate, DateTime EndCreateDate, int pageSize, int startPage, string orderByField)
{
QcmaininfoModelGen qmg = new QcmaininfoModelGen();
qmg.QualityCode = QualityCode;
qmg.Status = Status == "-1" ? null : Status;
qmg.Sourcing = Sourcing == "-1" ? null : Sourcing;
qmg.MaterialGroup = MaterialGroup == "-1" ? null : MaterialGroup;
qmg.Pattern = Pattern == "-1" ? null : Pattern;;
qmg.DyeMethod = DyeMethod == "-1" ? null : DyeMethod;
qmg.Finishing = Finish == "-1" ? null : Finish;
qmg.Construction = Con == "-1" ? null : Con;
qmg.AfGmmm = AfGmmm;
qmg.BfGmmm = BfGmmm;
qmg.CustomerQaulityId = CustomerQualityId;
qmg.CreateDate = BeginCreateDate;
qmg.CreateEndDate = EndCreateDate;
qmg.Sales = Sales;
/// 添加对Show My Own的判断显示 by LYH 2014/2/20
if (Creator == null)
{
if (Convert.ToBoolean(HttpContext.Current.Session["ShowOwn"]))
{
if (HttpContext.Current.Session["userId"] != null)
{
Creator = HttpContext.Current.Session["userId"].ToString();
}
}
}
qmg.Creator = Creator;
qmg.SalesTeam = SalesTeam == "-1" ? null : SalesTeam;
qmg.PageSize = pageSize;
qmg.StartPage = startPage;
qmg.OrderByField = orderByField;
qmg.CustomerCode = CustomerCode == "-1" ? null : CustomerCode;
// edit by jack
HttpContext.Current.Session["GetModelListCondition"] = GetModelListCondition(qmg);
/*QcmaininfoModelList result = new QcmaininfoModelList();
* QcmaininfoModel list1 = new QcmaininfoModel();
* list1.QualityCode = "sdfsdf";
* result.Add(list1);
* return result;*/
return(qcMainManager.GetModelListOne(qmg));
}
public string GetModelListCondition(QcmaininfoModelGen model)
{
int flag = 0;
// 添加查询条件
StringBuilder sb = new StringBuilder("");
if (model.Pattern != "" && model.Pattern != null)
{
sb.Append("UPPER(A.Pattern)='" + model.Pattern.ToUpper() + "'");
flag++;
}
if (model.CreateDate != null && model.CreateDate != DateTime.MinValue)
{
//sunny 注销开始 时间格式不对，需要重新转换
// if (flag == 0)
// sb.Append("A.Create_Date>='" + model.CreateDate.ToString() + "'");
// else
// sb.Append(" and A.Create_Date>='" + model.CreateDate.ToString() + "'");
//sunny 注销结束
if (flag == 0)
{
sb.Append("A.Create_Date>= to_date('" + model.CreateDate.ToString() + "','yyyy-mm-dd,hh24:mi:ss')");
}
else
{
sb.Append(" and A.Create_Date>= to_date('" + model.CreateDate.ToString() + "','yyyy-mm-dd,hh24:mi:ss')");
}
flag++;
}
//Add by sunny 20171016当前系统对日期范围，只有起始时间，没有结束时间。
if (model.CreateEndDate != null && model.CreateEndDate != DateTime.MinValue)
{
if (flag == 0)
{
sb.Append("A.Create_Date<= to_date('" + model.CreateEndDate.ToString() + "','yyyy-mm-dd,hh24:mi:ss')");
}
else
{
sb.Append(" and A.Create_Date<= to_date('" + model.CreateEndDate.ToString() + "','yyyy-mm-dd,hh24:mi:ss')");
}
flag++;
}
if (model.Creator != "" && model.Creator != null)
{
if (flag == 0)
{
sb.Append("upper(A.Creator)='" + model.Creator.ToUpper() + "'");
}
else
{
sb.Append("and upper(A.Creator)='" + model.Creator.ToUpper() + "'");
}
flag++;
}
if (model.BfGmmm != null && model.BfGmmm != 0)
{
if (flag == 0)
{
sb.Append("A.BF_GMMM=" + model.BfGmmm.ToString());
}
else
{
sb.Append(" and A.BF_GMMM=" + model.BfGmmm.ToString());
}
flag++;
}
if (model.AfGmmm != null && model.AfGmmm != 0)
{
if (flag == 0)
{
sb.Append("A.AF_GMMM=" + model.AfGmmm.ToString());
}
else
{
sb.Append(" and A.AF_GMMM=" + model.AfGmmm.ToString());
}
flag++;
}
if (model.Status != "" && model.Status != null)
{
if (flag == 0)
{
sb.Append("UPPER(A.Status)='" + model.Status.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(A.Status)='" + model.Status.ToUpper() + "'");
}
flag++;
}
if (model.CustomerQaulityId != "" && model.CustomerQaulityId != null)
{
if (flag == 0)
{
sb.Append("UPPER(F.Customer_Quality_ID)='" + model.CustomerQaulityId.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(F.Customer_Quality_ID)='" + model.CustomerQaulityId.ToUpper() + "'");
}
flag++;
}
if (model.Sourcing != "" && model.Sourcing != null)
{
if (flag == 0)
{
sb.Append("UPPER(A.Sourcing)='" + model.Sourcing.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(A.Sourcing)='" + model.Sourcing.ToUpper() + "'");
}
flag++;
}
if (model.MaterialGroup != "" && model.MaterialGroup != null)
{
if (flag == 0)
{
sb.Append("UPPER(A.Material_Group)='" + model.MaterialGroup.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(A.Material_Group)='" + model.MaterialGroup.ToUpper() + "'");
}
flag++;
}
if (model.QualityCode != "" && model.QualityCode != null)
{
if (flag == 0)
{
sb.Append("UPPER(A.Quality_Code)='" + model.QualityCode.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(A.Quality_Code)='" + model.QualityCode.ToUpper() + "'");
}
flag++;
}
if (model.DyeMethod != "" && model.DyeMethod != null)
{
if (flag == 0)
{
sb.Append("UPPER(A.Dye_Method)='" + model.DyeMethod.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(A.Dye_Method)='" + model.DyeMethod.ToUpper() + "'");
}
flag++;
}
if (model.Sales != "" && model.Sales != null)
{
if (flag == 0)
{
sb.Append("upper(D.Sales)='" + model.Sales.ToUpper() + "'");
}
else
{
sb.Append(" and upper(D.Sales)='" + model.Sales.ToUpper() + "'");
}
flag++;
}
if (model.SalesTeam != "" && model.SalesTeam != null)
{
if (flag == 0)
{
sb.Append("UPPER(D.Sales_Group)='" + model.SalesTeam.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(D.Sales_Group)='" + model.SalesTeam.ToUpper() + "'");
}
flag++;
}
if (model.Construction != "" && model.Construction != null)
{
if (flag == 0)
{
sb.Append("UPPER(B.Construction)='" + model.Construction.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(B.Construction)='" + model.Construction.ToUpper() + "'");
}
flag++;
}
if (model.Finishing != "" && model.Finishing != null)
{
if (flag == 0)
{
sb.Append("UPPER(C.Finishing_Code)='" + model.Finishing.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(C.Finishing_Code)='" + model.Finishing.ToUpper() + "'");
}
flag++;
}
// 添加对customer条件的判断 by LYH 2014/2/25
if (model.CustomerCode != "" && model.CustomerCode != null)
{
if (flag == 0)
{
sb.Append("UPPER(D.BUYER_ID) = '" + model.CustomerCode.ToUpper() + "'");
}
else
{
sb.Append(" and UPPER(D.BUYER_ID) = '" + model.CustomerCode.ToUpper() + "'");
}
flag++;
}
if (flag == 0)
{
return("");
}
return(Server.UrlEncode(sb.ToString()));
/*if (tempSql.Contains("@CreateTime"))
* {
* csql1.AddInputParameter("CreateTime", DbType.DateTime, model.CreateDate);
* csql2.AddInputParameter("CreateTime", DbType.DateTime, model.CreateDate);
* }
* if (tempSql.Contains("@BfGmmm"))
* {
* csql1.AddInputParameter("BfGmmm", DbType.Int32, model.BfGmmm);
* csql2.AddInputParameter("BfGmmm", DbType.Int32, model.BfGmmm);
* }
* if (tempSql.Contains("@Pattern"))
* {
* csql1.AddInputParameter("Pattern", DbType.String, model.Pattern.ToUpper());
* csql2.AddInputParameter("Pattern", DbType.String, model.Pattern.ToUpper());
* }
* if (tempSql.Contains("@Status"))
* {
* csql1.AddInputParameter("Status", DbType.String, model.Status.ToUpper());
* csql2.AddInputParameter("Status", DbType.String, model.Status.ToUpper());
* }
* if (tempSql.Contains("@Sourcing"))
* {
* csql1.AddInputParameter("Sourcing", DbType.String, model.Sourcing.ToUpper());
* csql2.AddInputParameter("Sourcing", DbType.String, model.Sourcing.ToUpper());
* }
* if (tempSql.Contains("@CustomerQualityId"))
* {
* csql1.AddInputParameter("CustomerQualityId", DbType.String, model.CustomerQaulityId.ToUpper());
* csql2.AddInputParameter("CustomerQualityId", DbType.String, model.CustomerQaulityId.ToUpper());
* }
* if (tempSql.Contains("@MaterialGroup"))
* {
* csql1.AddInputParameter("MaterialGroup", DbType.String, model.MaterialGroup.ToUpper());
* csql2.AddInputParameter("MaterialGroup", DbType.String, model.MaterialGroup.ToUpper());
* }
* if (tempSql.Contains("@QualityCode"))
* {
* csql1.AddInputParameter("QualityCode", DbType.String, model.QualityCode.ToUpper());
* csql2.AddInputParameter("QualityCode", DbType.String, model.QualityCode.ToUpper());
* }
* if (tempSql.Contains("@Creator"))
* {
* csql1.AddInputParameter("Creator", DbType.String, model.Creator.ToUpper());
* csql2.AddInputParameter("Creator", DbType.String, model.Creator.ToUpper());
* }
* if (tempSql.Contains("@DyeMethod"))
* {
* csql1.AddInputParameter("DyeMethod", DbType.String, model.DyeMethod.ToUpper());
* csql2.AddInputParameter("DyeMethod", DbType.String, model.DyeMethod.ToUpper());
* }
* if (tempSql.Contains("@Salesed"))
* {
* csql1.AddInputParameter("Salesed", DbType.String, model.Sales.ToUpper());
* csql2.AddInputParameter("Salesed", DbType.String, model.Sales.ToUpper());
* }
* if (tempSql.Contains("@SalesTeam"))
* {
* csql1.AddInputParameter("SalesTeam", DbType.String, model.SalesTeam.ToUpper());
* csql2.AddInputParameter("SalesTeam", DbType.String, model.SalesTeam.ToUpper());
* }
* if (tempSql.Contains("@Construction"))
* {
* csql1.AddInputParameter("Construction", DbType.String, model.Construction.ToUpper());
* csql2.AddInputParameter("Construction", DbType.String, model.Construction.ToUpper());
* }
* if (tempSql.Contains("@Finishing"))
* {
* csql1.AddInputParameter("Finishing", DbType.String, model.Finishing.ToUpper());
* csql2.AddInputParameter("Finishing", DbType.String, model.Finishing.ToUpper());
* }
* // 添加对customer条件的判断 by LYH 2014/2/25
* if (tempSql.Contains("@CustomerCode"))
* {
* csql1.AddInputParameter("CustomerCode", DbType.String, model.CustomerCode.ToUpper());
* csql2.AddInputParameter("CustomerCode", DbType.String, model.CustomerCode.ToUpper());
* }*/
}