/// <summary>
/// 分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable <MySqlUser> Seach(MySqlUserCondition.Search condition)
{
var page = new Pager <MySqlUserCondition.Search>()
{
Condition = condition,
UnionText = @"
SELECT * FROM t_d_user
UNION ALL
SELECT * FROM t_d_user",
Table = "alluser",
Key = "id",
Order = string.Empty,
Field = "*",
WhereAction = (Condition, Where, Paramters) =>
{
if (Condition.Id > 0)
{
Where.Append("AND ID = :ID ");
Paramters.Add(base.CreateParameter(":ID", Condition.Id));
}
}
};
var result = base.GetResultByPager <MySqlUser, MySqlUserCondition.Search>(page);
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable <SysUser> Seach(SysUserCondition.Search condition)
{
var page = new Pager <SysUserCondition.Search>()
{
Condition = condition,
Table = "sys_user",
Key = "user_id",
Order = string.Empty,
Field = "*",
WhereAction = (Condition, Where, Paramters) =>
{
if (!string.IsNullOrEmpty(Condition.UserName))
{
Where.Append("AND user_name LIKE @user_name ");
Paramters.Add(base.CreateParameter("@user_name", string.Concat("%", Condition.UserName, "%")));
}
if (!string.IsNullOrEmpty(Condition.UserEmail))
{
Where.Append("AND user_email LIKE @user_email ");
Paramters.Add(base.CreateParameter("@user_email", string.Concat("%", Condition.UserEmail, "%")));
}
if (!string.IsNullOrEmpty(Condition.UserMobile))
{
Where.Append("AND user_mobile LIKE @user_mobile ");
Paramters.Add(base.CreateParameter("@user_mobile", string.Concat("%", Condition.UserMobile, "%")));
}
}
};
var result = base.GetResultByPager <SysUser, SysUserCondition.Search>(page);
return(result);
}
/// <summary>
/// 添加参数
/// </summary>
/// <param name="paramter"></param>
/// <returns></returns>
public DbQuery AddParam(DbParameter paramter)
{
if (paramter != null)
{
Paramters.Add(paramter);
}
return(this);
}
/// <summary>
/// 添加参数
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
/// <returns></returns>
public DbQuery AddParam(string name, object value)
{
var param = Command.CreateParameter();
param.ParameterName = name;
param.Value = value;
Paramters.Add(param);
return(this);
}
public static void Exec(string module, System.Collections.Specialized.NameValueCollection urlParameters)
{
Paramters parameters = new Paramters();
foreach (string str in urlParameters.AllKeys)
{
parameters.AddValue(str, urlParameters[str]);
}
switch (module.ToUpper())
{
case "SMS":
AMTANGEE.Remote.DefaultHandler.SMS sms = new AMTANGEE.Remote.DefaultHandler.SMS();
sms.Exec(parameters);
break;
case "CALL":
AMTANGEE.Remote.DefaultHandler.Call call = new AMTANGEE.Remote.DefaultHandler.Call();
call.Exec(parameters);
break;
case "PROJECT":
AMTANGEE.Remote.DefaultHandler.Project project = new AMTANGEE.Remote.DefaultHandler.Project();
project.Exec(parameters);
break;
case "GENERAL":
AMTANGEE.Remote.DefaultHandler.General general = new AMTANGEE.Remote.DefaultHandler.General();
general.Exec(parameters);
break;
case "DOCUMENT":
AMTANGEE.Remote.DefaultHandler.Document document = new AMTANGEE.Remote.DefaultHandler.Document();
document.Exec(parameters);
break;
case "APPOINTMENT":
AMTANGEE.Remote.DefaultHandler.Appointment appointment = new Remote.DefaultHandler.Appointment();
appointment.Exec(parameters);
break;
case "CONTACT":
AMTANGEE.Remote.DefaultHandler.Contact contact = new Remote.DefaultHandler.Contact();
contact.Exec(parameters);
break;
case "EMAIL":
AMTANGEE.Remote.DefaultHandler.Email email = new Remote.DefaultHandler.Email();
email.Exec(parameters);
break;
}
}
public JsonResult SetReport(int ReportId)
{
Paramters par = new Paramters();
var ddlFields = new List <string>();
if ((ReportId) != 0)
{
ddlFields = LoadCriteria(ReportId);
if (ddlFields == null)
{
TempData["error"] = "no item found";
return(null);
}
}
Load_Parameter(ReportId);
par.RepCriteria = Session["CriteriaCap"].ToString();
par.RepCriteria_val = Session["Criteria"].ToString();
//Session["Criterialist"] = Criterialist;
par.Criterialist = ddlFields;
return(Json(par, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable <OracleUser> Seach(OracleUserCondition.Search condition)
{
var page = new Pager <OracleUserCondition.Search>()
{
Condition = condition,
Table = "t_d_user",
Order = string.Empty,
Field = "*",
WhereAction = (Where, Paramters) =>
{
if (condition.Id > 0)
{
Where.Append("AND ID = :ID ");
Paramters.Add(base.CreateParameter(":ID", condition.Id));
}
}
};
var result = base.GetResultByPager <OracleUser, OracleUserCondition.Search>(page);
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable <SysUser> UnionSeach(SysUserCondition.Search condition)
{
var page = new Pager <SysUserCondition.Search>()
{
Condition = condition,
UnionText = @"WITH alluser AS
(
SELECT * FROM sys_user
UNION ALL
SELECT * FROM sys_user
)",
Table = "alluser",
Order = string.Empty,
Field = "*",
WhereAction = (Where, Paramters) =>
{
if (!string.IsNullOrEmpty(condition.UserName))
{
Where.Append("AND user_name LIKE @user_name ");
Paramters.Add(base.CreateParameter("@user_name", string.Concat("%", condition.UserName, "%")));
}
if (!string.IsNullOrEmpty(condition.UserEmail))
{
Where.Append("AND user_email LIKE @user_email ");
Paramters.Add(base.CreateParameter("@user_email", string.Concat("%", condition.UserEmail, "%")));
}
if (!string.IsNullOrEmpty(condition.UserMobile))
{
Where.Append("AND user_mobile LIKE @user_mobile ");
Paramters.Add(base.CreateParameter("@user_mobile", string.Concat("%", condition.UserMobile, "%")));
}
}
};
var result = base.GetResultByPager <SysUser, SysUserCondition.Search>(page);
return(result);
}
public void Signal(Paramters param)
{
int newLevel = param.objectHealth.Level;
int oldLevel = param.oldHealthLevel;
//compare the levels to each other (this finds directionality of the change
int changeDirection = newLevel.CompareTo(newLevel);
bool triggerTypeMatchesChangeDirection =
(this.type == EType.onAnyChange) ||
(this.type == EType.onIncreasing && changeDirection > 0) ||
(this.type == EType.onDecreasing && changeDirection < 0);
//check if we have crossed the threshold (shortcut this by first checking that the direction counts as crossing the threshold)
bool thresholdCrossed = triggerTypeMatchesChangeDirection &&
threshold.CompareTo(newLevel) != threshold.CompareTo(oldLevel);
if (thresholdCrossed)
{
param.objectHealth.SendMessage(eventMessage);
}
}
/// <summary>
/// 设置请求参数值
/// </summary>
/// <returns></returns>
protected override void SetRequestParamter()
{
this.ContentType = "multipart/form-data;charset=utf-8;boundary=" + BoundaryLine;
using (Stream reqStream = request.GetRequestStream())
{
byte[] itemBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + BoundaryLine + "\r\n");
byte[] endBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + BoundaryLine + "--\r\n");
// 组装文本请求参数
string textTemplate = "Content-Disposition:form-data;name=\"{0}\"\r\nContent-Type:text/plain\r\n\r\n{1}";
IEnumerator <KeyValuePair <string, string> > textEnum = Paramters.GetEnumerator();
while (textEnum.MoveNext())
{
string textEntry = string.Format(textTemplate, textEnum.Current.Key, textEnum.Current.Value);
byte[] itemBytes = Encoding.UTF8.GetBytes(textEntry);
reqStream.Write(itemBoundaryBytes, 0, itemBoundaryBytes.Length);
reqStream.Write(itemBytes, 0, itemBytes.Length);
}
// 组装文件请求参数
string fileTemplate = "Content-Disposition:form-data;name=\"{0}\";filename=\"{1}\"\r\nContent-Type:{2}\r\n\r\n";
IEnumerator <KeyValuePair <string, string> > fileEnum = FileItems.GetEnumerator();
while (fileEnum.MoveNext())
{
string key = fileEnum.Current.Key;
string fullName = fileEnum.Current.Value;
string fileName = Path.GetFileName(fullName);
string fileEntry = string.Format(fileTemplate, key, fileName, HttpHepler.GetContentType(Path.GetExtension(fileName)));
byte[] itemBytes = Encoding.UTF8.GetBytes(fileEntry);
reqStream.Write(itemBoundaryBytes, 0, itemBoundaryBytes.Length);
reqStream.Write(itemBytes, 0, itemBytes.Length);
byte[] fileBytes = FileHelper.GetFileBytes(fullName);
reqStream.Write(fileBytes, 0, fileBytes.Length);
}
reqStream.Write(endBoundaryBytes, 0, endBoundaryBytes.Length);
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns></returns>
public IEnumerable <ShtSacrifice> Seach(ShtSacrificeCondition.Search condition)
{
var page = new Pager <ShtSacrificeCondition.Search>
{
Condition = condition,
Table = "sht_sacrifice a",
Order = "a.scfe_createtime DESC",
Field = "*",
WhereAction = (Where, Paramters) =>
{
if (!string.IsNullOrWhiteSpace(condition.ScfeName))
{
Paramters.Add(base.CreateParameter("@scfe_name", string.Concat("%", condition.ScfeName, "%")));
Where.Append("AND a.scfe_name LIKE @scfe_name ");
}
if (!string.IsNullOrWhiteSpace(condition.ScfeUnitName))
{
Paramters.Add(base.CreateParameter("@scfe_unit_name", string.Concat("%", condition.ScfeUnitName, "%")));
Where.Append("AND a.scfe_unit_name LIKE @scfe_unit_name ");
}
if (condition.ScfeCateId != null && condition.ScfeCateId.Value > 0)
{
Paramters.Add(base.CreateParameter("@scfe_cate_id", condition.ScfeCateId.Value));
Where.Append("AND a.scfe_cate_id = @scfe_cate_id ");
}
if (!string.IsNullOrWhiteSpace(condition.ScfeCateName))
{
Paramters.Add(base.CreateParameter("@scfe_cate_name", string.Concat("%", condition.ScfeCateName, "%")));
Where.Append("AND a.scfe_cate_name LIKE @scfe_cate_name ");
}
if (!string.IsNullOrWhiteSpace(condition.ScfeImage))
{
Paramters.Add(base.CreateParameter("@scfe_image", string.Concat("%", condition.ScfeImage, "%")));
Where.Append("AND a.scfe_image LIKE @scfe_image ");
}
if (condition.ScfePrice != null && condition.ScfePrice.Value > 0)
{
Paramters.Add(base.CreateParameter("@scfe_price", condition.ScfePrice.Value));
Where.Append("AND a.scfe_price = @scfe_price ");
}
if (condition.ScfeGold != null && condition.ScfeGold.Value > 0)
{
Paramters.Add(base.CreateParameter("@scfe_gold", condition.ScfeGold.Value));
Where.Append("AND a.scfe_gold = @scfe_gold ");
}
if (condition.ScfeStatus != null && condition.ScfeStatus.Value > 0)
{
Paramters.Add(base.CreateParameter("@scfe_status", condition.ScfeStatus.Value));
Where.Append("AND a.scfe_status = @scfe_status ");
}
if (condition.ScfeUpdatetimeBegin != null)
{
Paramters.Add(base.CreateParameter("@scfe_updatetime_begin", condition.ScfeUpdatetimeBegin.Value.ToString("yyyy-MM-dd HH:mm:ss")));
Where.Append(" AND a.scfe_updatetime >= @scfe_updatetime_begin ");
}
if (condition.ScfeUpdatetimeEnd != null)
{
Paramters.Add(base.CreateParameter("@scfe_updatetime_end", condition.ScfeUpdatetimeEnd.Value.ToString("yyyy-MM-dd HH:mm:ss")));
Where.Append(" AND a.scfe_updatetime <= @scfe_updatetime_end ");
}
if (condition.ScfeCreatetimeBegin != null)
{
Paramters.Add(base.CreateParameter("@scfe_createtime_begin", condition.ScfeCreatetimeBegin.Value.ToString("yyyy-MM-dd HH:mm:ss")));
Where.Append(" AND a.scfe_createtime >= @scfe_createtime_begin ");
}
if (condition.ScfeCreatetimeEnd != null)
{
Paramters.Add(base.CreateParameter("@scfe_createtime_end", condition.ScfeCreatetimeEnd.Value.ToString("yyyy-MM-dd HH:mm:ss")));
Where.Append(" AND a.scfe_createtime <= @scfe_createtime_end ");
}
}
};
var result = base.GetResultByPager <ShtSacrifice, ShtSacrificeCondition.Search>(page);
return(result);
}
public ActionResult GetParameters(Paramters paramters)
{
return(Json(new { ok = "ok" }));
}
private void Load_Parameter(long RepID)
{
string strTmp;
string[] arrTmp;
List <string> ddlLink = new List <string>();
List <string> lstCriteria = new List <string>();
DataSet dsDic = new DataSet();
Paramters rep_par = new Paramters();
SqlDataAdapter daObject = new SqlDataAdapter(("SELECT ObjectTitle, UseAndOnly,ByBranch,CriteriaFields,CriteriaFieldsCaptions,SortFieldsList,Criteria" + "FieldsUnique,CriteriaFieldsTypes,CriteriaFieldsOperators,CriteriaFieldsSources FROM Objects WHERE ObjectID=" + RepID), DataTools.GetConnectionStr());
Session["ReportID"] = RepID;
daObject.Fill(dtObject);
Session["dtObject"] = dtObject;
rep_par.RepTitle = dtObject.Rows[0]["ObjectTitle"].ToString();
strTmp = ((dtObject.Rows[0]["CriteriaFields"].ToString()) == null ? "" : dtObject.Rows[0]["CriteriaFields"].ToString()).Replace("\r\n", "");
arrTmp = strTmp.Split(';');
string[] arrtmp2 = (string[])arrTmp.Clone();
for (int i = 0; (i <= (arrtmp2.Length - 1)); i++)
{
if ((DataTools.GetStrPart(DataTools.ReadField(dtObject.Rows[0]["CriteriaFieldsCaptions"]), i) != ""))
{
arrtmp2[i] = DataTools.GetStrPart(DataTools.ReadField(dtObject.Rows[0]["CriteriaFieldsCaptions"]), i);
}
}
strTmp = string.Join(";", arrtmp2);
dsDic = DataTools.GetDic(strTmp);
strTmp = "";
for (int i = 0; (i <= (arrTmp.Length - 1)); i++)
{
strTmp = "";
foreach (DataRow dr in dsDic.Tables[0].Rows)
{
if ((dr[0].ToString() == arrtmp2[i]))
{
strTmp = dr["LatinCap"].ToString();
break;
}
}
ddlFields.Add(((strTmp == "") ? arrTmp[i] : strTmp));
}
ddlLink.Add("AND");
if (!(bool)dtObject.Rows[0]["UseAndOnly"])
{
ddlLink.Add("OR");
}
DataTable dtCrit = new DataTable();
Session["Criteria"] = "";
Session["CriteriaCap"] = "";
dtCrit = DataTools.DLookUp(DataTools.GetConnectionStr(), "UsersRecent", "Criteria", ("UserName='******' AND ObjectID=" + RepID))), "", "", "AccessDate DESC", 1);
if ((dtCrit.Rows.Count > 0))
{
string CritFromTbl = dtCrit.Rows[0][0].ToString();
if (CritFromTbl != null && (CritFromTbl.Trim() != ""))
{
arrTmp = CritFromTbl.ToString().Split(';');
for (int i = 0; (i <= (arrTmp.Length - 1)); i++)
{
ValidateLine(DataTools.GetStrSerial(dtObject.Rows[0]["CriteriaFields"].ToString(), DataTools.GetStrPart(arrTmp[i], 0, "^^^")), DataTools.GetStrPart(arrTmp[i], 1, "^^^"), DataTools.GetStrPart(arrTmp[i], 2, "^^^"), DataTools.GetStrPart(arrTmp[i], 3, "^^^"), DataTools.GetStrPart(arrTmp[i], 4, "^^^"), ref strTmp);
lstCriteria.Add(DataTools.GetStrPart(Session["CriteriaCap"].ToString(), i));
//Session["lstCriteria"] = (DataTools.GetStrPart(Session["Criteria"].ToString(), i));
//Session["criteria_val"] = (DataTools.GetStrPart(Session["CriteriaCap"].ToString(), i));
}
}
}
}
public void ViewReport(Paramters reportparameter)
{
_ReportID = reportparameter.ReportID;
_RepCriteria = reportparameter.RepCriteria;
_RepDest = reportparameter.RepDest;
_RepSort = reportparameter.RepSort;
_RepTitle = reportparameter.RepTitle;
_RepCap = reportparameter.RepCap;
_RepLan = reportparameter.RepLanguage;
if (IsPostBack())
{
PrepareReport();
if ((_RepLan == "Arabic"))
{
//RTL(rpt);
}
if ((_RepDest == 0))
{
Session["dsReports"] = dsReport;
//Cache["rpt" + ReportID] = rpt;
}
DataTools.dbExecute((" INSERT INTO UsersRecent(UserName,ObjectID,Criteria,AccessDate)VALUES('" + (DataTools.GetUserName() + ("'," + (_ReportID + (",'" + (_RepCriteria + "',getdate())")))))), DataTools.GetConnectionStr());
}
else
{
//rpt = Cache[("rpt" + ReportID)];
_RepDest = long.Parse(Session["RepDest"].ToString());
}
//try
//{
var Criterialist = new List <string>();
if ((Request.HttpMethod == "POST"))
{
DataTools.dbExecute((" INSERT INTO UsersRecent(UserName,ObjectID,Criteria,AccessDate)VALUES('" + (DataTools.GetUserName() + ("'," + (_ReportID + (",'" + (_RepCriteria + "',getdate())")))))), DataTools.GetConnectionStr());
switch (_RepDest)
{
case 0:
this.HttpContext.Session["rptSource"] = rpt;
break;
case 1:
ExportReport((_RepTitle + ".pdf"), CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
break;
case 2:
ExportReport((_RepTitle + ".xls"), CrystalDecisions.Shared.ExportFormatType.Excel);
break;
case 3:
ExportReport((_RepTitle + ".xls"), CrystalDecisions.Shared.ExportFormatType.ExcelRecord);
break;
case 4:
ExportReport((_RepTitle + ".rtf"), CrystalDecisions.Shared.ExportFormatType.RichText);
break;
case 5:
ExportReport((_RepTitle + ".htm"), CrystalDecisions.Shared.ExportFormatType.HTML40);
break;
case 6:
ExportReport((_RepTitle + ".doc"), CrystalDecisions.Shared.ExportFormatType.WordForWindows);
break;
case 7:
ExportReport((_RepTitle + ".rpt"), CrystalDecisions.Shared.ExportFormatType.CrystalReport);
break;
case 11:
PrintReport();
break;
}
}
//return Json(Criterialist, JsonRequestBehavior.AllowGet);
//return RedirectToAction("ShowGenericRpt", "GenericReportViewer");
//}
//catch
//{
// return null;
//}
}
