public void Run(IContext ctx)
{
System.Diagnostics.Trace.WriteLine("Split run");
resultSet = new DataSet();
DataTable table1 = new DataTable() { TableName = "Split1" };
table1.Columns.Add("X");
DataTable table2 = new DataTable() { TableName = "Split2" };
table2.Columns.Add("X");
var h = new ParamsHelper(data.Tables["params"]);
var tableName = h.GetValue<string>("Table Name");
//var attrs = typeof(Split).GetCustomAttributes<ParameterAttribute>();
DataTable src = ctx.Data.Tables[tableName];
if (src == null)
{
throw new Exception(string.Format("Алгоритм источник не имеет таблицы {0}", tableName));
}
var splitPart = h.GetValue<double>("SplitPart");
int cnt = (int)(src.Rows.Count * splitPart);
int i = 0;
foreach (DataRow r in src.Rows)
{
if (i < cnt)
{
DataRow rr = table1.NewRow();
rr[0] = r[0];
table1.Rows.Add(rr);
}
else
{
DataRow rr = table2.NewRow();
rr[0] = r[0];
table2.Rows.Add(rr);
}
i++;
}
resultSet.Tables.Add(table1);
resultSet.Tables.Add(table2);
}
public void Run(IContext ctx)
{
resultSet = new DataSet();
DataTable sequenceTable = new DataTable() { TableName = "ModifiedSequence" };
sequenceTable.Columns.Add("X");
var h = new ParamsHelper(data.Tables["params"]);
var attrs = typeof(Modification).GetCustomAttributes<ParameterAttribute>();
var tableName = h.GetValue<string>("Table Name");
var size = h.GetValue<int>("Size");
var start = h.GetValue<int>("Start");
var lambda = h.GetValue<double>("Lambda");
var type = h.GetValue<int>("TransformationType");
DataTable src = ctx.Data.Tables[tableName];
if (src == null)
{
var sb = new StringBuilder();
for (var i = 0; i < ctx.Data.Tables.Count; i++)
{
sb.AppendFormat(sb.Length > 0 ? "{0}, " : "{0}", ctx.Data.Tables[i].TableName);
}
throw new Exception(string.Format("No table '{0}' found in the input dataset. There is only '{1}' tables found", tableName, sb.ToString()));
}
double[] series = GetTableValues(src, 0);
//разбиение
var N = series.Length;
stat = new Statistic(N);
List<double> modified = new List<double>();
int negCount = 0;
transform(series, modified, start, Math.Min(start + size, N), type, lambda, out negCount);
for (int j = 0; j < modified.Count; j++)
{
DataRow row = sequenceTable.NewRow();
row["X"] = modified[j];
sequenceTable.Rows.Add(row);
}
resultSet.Tables.Add(sequenceTable);
}
private void Bind()
{
string sOrderCode = "";
if (!string.IsNullOrWhiteSpace(Request.QueryString["order"]))
{
sOrderCode = Server.HtmlEncode(Request.QueryString["order"]).Trim();
}
txtOrderCode.Value = sOrderCode;
if (string.IsNullOrEmpty(sOrderCode))
{
return;
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and OrderCode = @OrderCode";
SqlParameter parm = new SqlParameter("@OrderCode", SqlDbType.VarChar, 36);
parm.Value = sOrderCode;
parms.Add(parm);
List <PDAOrderScanDetailInfo> list = null;
PDAOrderScanDetail osdBll = new PDAOrderScanDetail();
list = osdBll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray());
rpData.DataSource = list;
rpData.DataBind();
ltrMyData.Text = "<div id=\"myDataForPage\" style=\"display:none;\">[{\"PageIndex\":\"" + pageIndex + "\",\"PageSize\":\"" + pageSize + "\",\"TotalRecord\":\"" + totalRecords + "\",\"QueryStr\":\"" + queryStr + "\"}]</div>";
}
/// <summary>
/// 是否存在对应数据
/// </summary>
/// <param name="name"></param>
/// <param name="companyId"></param>
/// <param name="Id"></param>
/// <returns></returns>
private bool IsExist(string name, Guid companyId, object Id)
{
Guid gId = Guid.Empty;
if (Id != null)
{
Guid.TryParse(Id.ToString(), out gId);
}
ParamsHelper parms = new ParamsHelper();
string cmdText = "select 1 from [ResidenceCommunity] where lower(CommunityName) = @CommunityName and PropertyCompanyId = @PropertyCompanyId";
if (gId != Guid.Empty)
{
cmdText = "select 1 from [ResidenceCommunity] where lower(CommunityName) = @CommunityName and PropertyCompanyId = @PropertyCompanyId and Id <> @Id ";
SqlParameter parm1 = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm1.Value = Guid.Parse(Id.ToString());
parms.Add(parm1);
}
SqlParameter parm = new SqlParameter("@CommunityName", SqlDbType.NVarChar, 50);
parm.Value = name.ToLower();
parms.Add(parm);
parm = new SqlParameter("@PropertyCompanyId", SqlDbType.UniqueIdentifier);
parm.Value = companyId;
parms.Add(parm);
object obj = SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms.ToArray());
if (obj != null)
{
return(true);
}
return(false);
}
/// <summary>
/// 是否存在对应数据
/// </summary>
/// <param name="name"></param>
/// <param name="numberId"></param>
/// <returns></returns>
public bool IsExist(string productName, string categoryId, string numberId)
{
bool isExist = false;
int totalCount = -1;
ParamsHelper parms = new ParamsHelper();
string cmdText = "select count(*) from [Product] where ProductName = @ProductName and CategoryId = @CategoryId";
if (!string.IsNullOrEmpty(numberId))
{
cmdText = "select count(*) from [Product] where ProductName = @ProductName and CategoryId = @CategoryId and ProductId <> @NumberID ";
SqlParameter parm1 = new SqlParameter("@NumberID", SqlDbType.VarChar, 40);
parm1.Value = numberId;
parms.Add(parm1);
}
SqlParameter parm = new SqlParameter("@ProductName", SqlDbType.NVarChar, 256);
parm.Value = productName;
parms.Add(parm);
parm = new SqlParameter("@CategoryId", SqlDbType.VarChar, 40);
parm.Value = categoryId;
parms.Add(parm);
object obj = SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms.ToArray());
if (obj != null)
{
totalCount = Convert.ToInt32(obj);
}
if (totalCount > 0)
{
isExist = true;
}
return(isExist);
}
private void GetSearchItem()
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
sqlWhere.Append("and AppName = @AppName ");
parms.Add(new SqlParameter("@AppName", Membership.ApplicationName));
if (!string.IsNullOrWhiteSpace(name))
{
sqlWhere.Append("and (u.UserName like @UserName or p.ProductName like @ProductName) ");
SqlParameter parm = new SqlParameter("@UserName", SqlDbType.NVarChar, 256);
parm.Value = "%" + name + "%";
parms.Add(parm);
parm = new SqlParameter("@ProductName", SqlDbType.NVarChar, 50);
parm.Value = "%" + name + "%";
parms.Add(parm);
}
}
private void GetRFIDList(HttpContext context, int pageIndex, int pageSize, string keyword)
{
var bll = new RFID();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
if (!string.IsNullOrWhiteSpace(keyword))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
parms = new ParamsHelper();
sqlWhere.Append("and (r.TID like @Keyword or r.EPC like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}
/// <summary>
/// 是否存在对应数据
/// </summary>
/// <param name="name"></param>
/// <param name="Id"></param>
/// <returns></returns>
private bool IsExist(string name, object Id)
{
bool isExist = false;
Guid gId = Guid.Empty;
if (!Guid.TryParse(Id.ToString(), out gId))
{
throw new ArgumentException("参数值无效", "Id");
}
ParamsHelper parms = new ParamsHelper();
string cmdText = "select 1 from [SitePoint] where PointName = @PointName ";
if (!gId.Equals(Guid.Empty))
{
cmdText = "select 1 from [SitePoint] where PointName = @PointName and Id <> @Id ";
SqlParameter parm1 = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm1.Value = gId;
parms.Add(parm1);
}
SqlParameter parm = new SqlParameter("@PointName", SqlDbType.NVarChar, 50);
parm.Value = name;
parms.Add(parm);
object obj = SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms.ToArray());
if (obj != null)
{
isExist = true;
}
return(isExist);
}
public DataPage <Blog> Search(PagedRequest <SearchBlogsFilter> request)
{
var totalCount = ParamsHelper.CreateOutputParameter("@TotalCount", SqlDbType.Int);
List <Blog> result = ExecuteReadList <Blog, BlogMapper>("dbo.Blogs_Search", new List <SqlParameter>
{
ParamsHelper.CreateInputParameter("@BlogID", SqlDbType.Int, request.Filter.BlogID),
ParamsHelper.CreateInputParameter("@Title", SqlDbType.NVarChar, request.Filter.Title),
ParamsHelper.CreateInputParameter("@FromDate", SqlDbType.Date, request.Filter.FromDate.HasValue ? request.Filter.FromDate.Value.ToUniversalTime().Date : (DateTime?)null),
ParamsHelper.CreateInputParameter("@ToDate", SqlDbType.DateTime, request.Filter.ToDate.HasValue ? request.Filter.ToDate.Value.ToUniversalTime().Date.AddDays(1).AddMilliseconds(-3) : (DateTime?)null),
ParamsHelper.CreateInputParameter("@OwnerUserID", SqlDbType.Int, request.Filter.OwnerUserID),
ParamsHelper.CreateInputParameter("@OrderBy", SqlDbType.NVarChar, request.OrderBy),
ParamsHelper.CreateInputParameter("@OrderDirection", SqlDbType.Char, request.GetOrderDirection()),
ParamsHelper.CreateInputParameter("@PageNumber", SqlDbType.Int, request.PageNumber),
ParamsHelper.CreateInputParameter("@RowsPerPage", SqlDbType.Int, request.RowsPerPage),
ParamsHelper.CreateInputParameter("@IsStrict", SqlDbType.Bit, request.Filter.IsStrictSearch),
ParamsHelper.CreateInputParameter("@IsDeleted", SqlDbType.Bit, request.Filter.IsDeleted),
totalCount
});
var pagedResult = new DataPage <Blog>(result, (int)totalCount.Value);
return(pagedResult);
}
public ResResultModel GetPandianAssetList(PdaPandianAssetModel model)
{
try
{
if (model == null)
{
return(ResResult.Response(false, "未找到任何参数", ""));
}
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 10)
{
model.PageSize = 10;
}
int totalRecord = 0;
var pandianId = Guid.Empty;
if (model.PandianId != null)
{
Guid.TryParse(model.PandianId.ToString(), out pandianId);
}
//if (pandianId.Equals(Guid.Empty)) return ResResult.Response(false, "参数PandianId值为“" + model.PandianId + "”不正确", "");
var status = Enum.GetName(typeof(EnumData.EnumPandianAssetStatus), model.Status);
//if (string.IsNullOrWhiteSpace(status)) return ResResult.Response(false, "参数Status值为“" + model.Status + "”不正确", "");
var sqlWhere = new StringBuilder(100);
var parms = new ParamsHelper();
SqlParameter parm = null;
if (!pandianId.Equals(Guid.Empty))
{
sqlWhere.Append("and PandianId = @PandianId ");
parm = new SqlParameter("@PandianId", SqlDbType.UniqueIdentifier);
parm.Value = pandianId;
parms.Add(parm);
}
if (model.Status > -1)
{
sqlWhere.Append("and pda.Status = @Status ");
parm = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
parm.Value = status;
parms.Add(parm);
}
var bll = new PandianAsset();
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere.ToString(), parms.ToArray());
var pdaList = new List <PdaPandianAssetInfo>();
foreach (var item in list)
{
var pdaModel = new PdaPandianAssetInfo();
pdaModel.PandianId = item.PandianId;
pdaModel.AssetId = item.AssetId;
pdaModel.Named = item.Named;
pdaModel.PandianUser = item.UserName;
pdaModel.TotalQty = list.Count;
pdaModel.Remark = item.Remark;
pdaModel.PandianAssetStatus = item.Status;
pdaModel.PictureUrl = "";
pdaModel.AssetName = item.AssetName;
pdaModel.Barcode = item.Barcode;
pdaModel.SNCode = item.SNCode;
pdaModel.Category = item.Category;
pdaModel.CategoryId = item.CategoryId;
pdaModel.SpecModel = item.SpecModel;
pdaModel.OwnedCompany = item.OwnedCompany;
pdaModel.UseCompany = item.UseCompany;
pdaModel.UseDepmt = item.UseDepmt;
pdaModel.Region = item.Region;
pdaModel.StoreLocation = item.StoreLocation;
pdaModel.UsePerson = item.UsePerson;
pdaModel.Unit = item.Unit;
pdaList.Add(pdaModel);
}
var totals = bll.GetTotal(pandianId);
var dgData = "{\"total\":" + pdaList.Count + ",\"rows\":" + JsonConvert.SerializeObject(pdaList) + ",\"footer\":[{\"TotalPan\":" + totals[0] + ",\"TotalYpan\":" + totals[1] + ",\"TotalNotPan\":" + totals[2] + "}]}";
return(ResResult.Response(true, "", dgData));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
private ProfileInfoCollection GetProfilesForQuery(SqlParameter[] args, ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords)
{
if (pageIndex < 0)
{
throw new ArgumentException(SecurityMessage.GetString(SecurityMessage.PageIndex_bad), "pageIndex");
}
if (pageSize < 1)
{
throw new ArgumentException(SecurityMessage.GetString(SecurityMessage.PageSize_bad), "pageSize");
}
long upperBound = (long)pageIndex * pageSize + pageSize - 1;
if (upperBound > Int32.MaxValue)
{
throw new ArgumentException(SecurityMessage.GetString(SecurityMessage.PageIndex_PageSize_bad), "pageIndex and pageSize");
}
ParamsHelper parms = new ParamsHelper();
parms.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
parms.Add(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int)authenticationOption));
parms.Add(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex));
parms.Add(CreateInputParam("@PageSize", SqlDbType.Int, pageSize));
foreach (SqlParameter arg in args)
{
parms.Add(arg);
}
ProfileInfoCollection profiles = new ProfileInfoCollection();
totalRecords = 0;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.StoredProcedure, "dbo.Aspnet_Profile_GetProfiles", parms.ToArray()))
{
if (reader != null)
{
while (reader.Read())
{
string username;
DateTime dtLastActivity, dtLastUpdated;
bool isAnon;
username = reader.GetString(0);
isAnon = reader.GetBoolean(1);
dtLastActivity = DateTime.SpecifyKind(reader.GetDateTime(2), DateTimeKind.Local);
dtLastUpdated = DateTime.SpecifyKind(reader.GetDateTime(3), DateTimeKind.Local);
int size = reader.GetInt32(4);
profiles.Add(new ProfileInfo(username, isAnon, dtLastActivity, dtLastUpdated, size));
}
totalRecords = profiles.Count;
if (reader.NextResult())
{
if (reader.Read())
{
totalRecords = reader.GetInt32(0);
}
}
}
}
return(profiles);
}
private void GetDatagridForServiceVote(HttpContext context)
{
context.Response.ContentType = "text/plain";
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
int.TryParse(context.Request.Form["page"], out pageIndex);
int.TryParse(context.Request.Form["rows"], out pageSize);
Guid serviceItemId = Guid.Empty;
if (!string.IsNullOrWhiteSpace(context.Request.Form["serviceItemId"]))
{
Guid.TryParse(context.Request.Form["serviceItemId"], out serviceItemId);
}
if (serviceItemId.Equals(Guid.Empty))
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
string keyword = context.Request.Form["keyword"];
string sqlWhere = string.Empty;
ParamsHelper parms = null;
if (!serviceItemId.Equals(Guid.Empty))
{
sqlWhere += "and sv.ServiceItemId = @ServiceItemId ";
SqlParameter parm = new SqlParameter("@ServiceItemId", SqlDbType.UniqueIdentifier);
parm.Value = serviceItemId;
if (parms == null)
{
parms = new ParamsHelper();
}
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(keyword))
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and (sv.Named like @Named or sv.Descr like @Descr) ";
SqlParameter parm = new SqlParameter("@Named", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword.Trim() + "%";
parms.Add(parm);
parm = new SqlParameter("@Descr", SqlDbType.NVarChar, 300);
parm.Value = "%" + keyword.Trim() + "%";
parms.Add(parm);
}
ServiceVote bll = new ServiceVote();
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray());
if (list == null || list.Count == 0)
{
ServiceItem siBll = new ServiceItem();
siBll.UpdateHasVote(serviceItemId, false);
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
StringBuilder sb = new StringBuilder();
foreach (var model in list)
{
sb.Append("{\"Id\":\"" + model.Id + "\",\"ServiceItemId\":\"" + model.ServiceItemId + "\",\"ServiceItemName\":\"" + model.ServiceItemName + "\",\"Named\":\"" + model.Named + "\",\"Descr\":\"" + model.Descr + "\",\"Sort\":\"" + model.Sort + "\",\"OriginalPicture\":\"" + model.OriginalPicture.Replace("~", "") + "\",\"BPicture\":\"" + model.BPicture + "\",\"MPicture\":\"" + model.MPicture + "\",\"SPicture\":\"" + model.SPicture + "\",\"OtherPicture\":\"" + model.OtherPicture + "\",\"LastUpdatedDate\":\"" + model.LastUpdatedDate.ToString("yyyy-MM-dd HH:mm") + "\"},");
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}");
}
public ResResultModel GetOrderMakeList(OrderMakeModel model)
{
try
{
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 1)
{
model.PageSize = 10;
}
int totalRecord = 0;
var bll = new OrderMake();
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
#region 构造查询条件
new Auth().CreateSearchItem(ref sqlWhere, ref parms);
if (!string.IsNullOrWhiteSpace(model.OrderCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and OrderCode like @OrderCode ");
var parm = new SqlParameter("@OrderCode", SqlDbType.VarChar, 36);
parm.Value = "%" + model.OrderCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(model.CustomerCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(400);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and CustomerCode like @CustomerCode ");
var parm = new SqlParameter("@CustomerCode", SqlDbType.VarChar, 36);
parm.Value = "%" + model.CustomerCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(model.StaffCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and StaffCode like @StaffCode ");
var parm = new SqlParameter("@StaffCode", SqlDbType.VarChar, 36);
parm.Value = "%" + model.StaffCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(model.PayWay))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(200);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and PayWay like @PayWay ");
var parm = new SqlParameter("@PayWay", SqlDbType.VarChar, 36);
parm.Value = "%" + model.PayWay + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(model.ServiceProduct))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and ServiceProduct like @ServiceProduct ");
var parm = new SqlParameter("@ServiceProduct", SqlDbType.VarChar, 36);
parm.Value = "%" + model.ServiceProduct + "%";
parms.Add(parm);
}
#region 开始与结束日期段
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(model.StartDate))
{
DateTime.TryParse(model.StartDate, out startDate);
}
if (!string.IsNullOrWhiteSpace(model.EndDate))
{
DateTime.TryParse(model.EndDate, out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate >= @StartDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate <= @EndDate) ");
var parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
#endregion
#endregion
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
return(ResResult.Response(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
private void GetSearch()
{
if (parms == null)
{
parms = new ParamsHelper();
}
string sStartDate = Request.QueryString["startDate"];
string sEndDate = Request.QueryString["endDate"];
txtStartDate.Value = sStartDate;
txtEndDate.Value = sEndDate;
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrEmpty(sStartDate))
{
if (!DateTime.TryParse(sStartDate, out startDate))
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Submit_Params_InvalidRegex, "开始日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (!string.IsNullOrEmpty(sEndDate))
{
if (!DateTime.TryParse(sEndDate, out endDate))
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Submit_Params_InvalidRegex, "截止日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (startDate > endDate)
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Request_DateTime_CompareToError, "开始日期", "截止日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (startDate != DateTime.MinValue || endDate != DateTime.MinValue)
{
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
sqlWhere += "and SendDate between @StartDate and @EndDate ";
parms.Add(new SqlParameter("@StartDate", startDate));
parms.Add(new SqlParameter("@EndDate", endDate));
}
else
{
if (startDate != DateTime.MinValue)
{
sqlWhere += "and SendDate >= @StartDate ";
parms.Add(new SqlParameter("@StartDate", startDate));
}
if (endDate != DateTime.MinValue)
{
sqlWhere += "and SendDate <= @EndDate ";
parms.Add(new SqlParameter("@EndDate", endDate));
}
}
}
}
/// <summary>
/// 格式化 最终输出到elk的核心部分
/// </summary>
/// <param name="logEvent"></param>
/// <param name="output"></param>
private static void FormatContent(LogEvent logEvent, TextWriter output)
{
if (logEvent == null)
{
throw new ArgumentNullException(nameof(logEvent));
}
if (output == null)
{
throw new ArgumentNullException(nameof(output));
}
output.Write('{');
// 读取相关配置
var logConfigRootDTOInfo = JsonConfigUtils.GetAppSettings <LogConfigRootDTO>(AppSettingsFileNameConfig.AppSettingsFileName, "LogFiedOutPutConfigs");
if (logConfigRootDTOInfo == null)
{
return;
}
// 写入所有的项目配置项的字段 在appsetting中配置的 输出elk节点的数据字段
foreach (var item in logConfigRootDTOInfo.ConfigsInfo)
{
switch (item.FiedName)
{
//case "orgid":
// WritePropertyAndValue(output, "method", HttpContextProvider.GetCurrent().Request.Method);
// output.Write(",");
// break;
default:
WritePropertyAndValue(output, item.FiedName, item.FiedValue);
output.Write(",");
break;
}
}
// 写入http对应的信息数据
if (HttpContextProvider.GetCurrent() != null && HttpContextProvider.GetCurrent().Request != null)
{
if (!string.IsNullOrEmpty(HttpContextProvider.GetCurrent().Request.Method))
{
WritePropertyAndValue(output, "method", HttpContextProvider.GetCurrent().Request.Method);
output.Write(",");
}
// 输出请求页面url
if (!string.IsNullOrEmpty(HttpContextProvider.GetCurrent().Request.Path))
{
WritePropertyAndValue(output, "requestUrl", HttpContextProvider.GetCurrent().Request.Path.ToString());
output.Write(",");
}
// 输出携带token
if (HttpContextProvider.GetCurrent().Request.Headers["Authorization"].FirstOrDefault() != null)
{
WritePropertyAndValue(output, "Authorization", HttpContextProvider.GetCurrent().Request.Headers["Authorization"].FirstOrDefault());
output.Write(",");
}
// 输出请求参数
if (!string.IsNullOrEmpty(HttpContextProvider.GetCurrent().Request.Method))
{
string contentFromBody = ParamsHelper.GetParams(HttpContextProvider.GetCurrent());
WritePropertyAndValue(output, "requestParam", contentFromBody);
output.Write(",");
}
// 输出请求方法类型
if (!string.IsNullOrEmpty(HttpContextProvider.GetCurrent().Request.Method))
{
WritePropertyAndValue(output, "method", HttpContextProvider.GetCurrent().Request.Method);
output.Write(",");
}
}
// 输出请求时间戳
WritePropertyAndValue(output, "timestamp", logEvent.Timestamp.ToString("o"));
output.Write(",");
// 输出日志级别
WritePropertyAndValue(output, "level", logEvent.Level.ToString());
output.Write(",");
// 输出log内容
WritePropertyAndValue(output, "executeResult", logEvent.MessageTemplate.Render(logEvent.Properties));
if (logEvent.Exception != null)
{
output.Write(",");
WritePropertyAndValue(output, "exception", logEvent.Exception.ToString());
}
WriteProperties(logEvent.Properties, output);
output.Write('}');
}
private void GetDatagridForServiceLink(HttpContext context)
{
context.Response.ContentType = "text/plain";
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
int.TryParse(context.Request.Form["page"], out pageIndex);
int.TryParse(context.Request.Form["rows"], out pageSize);
Guid serviceItemId = Guid.Empty;
if (!string.IsNullOrWhiteSpace(context.Request.Form["serviceItemId"]))
{
Guid.TryParse(context.Request.Form["serviceItemId"], out serviceItemId);
}
if (serviceItemId.Equals(Guid.Empty))
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
string keyword = context.Request.Form["keyword"];
string sqlWhere = string.Empty;
ParamsHelper parms = null;
if (!serviceItemId.Equals(Guid.Empty))
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and sl.ServiceItemId = @ServiceItemId ";
SqlParameter parm = new SqlParameter("@ServiceItemId", SqlDbType.UniqueIdentifier);
parm.Value = serviceItemId;
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(keyword))
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and (sl.Named like @Named or sl.Url like @Url) ";
SqlParameter parm = new SqlParameter("@Named", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@Url", SqlDbType.VarChar, 300);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
ServiceLink bll = new ServiceLink();
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray());
if (list == null || list.Count == 0)
{
ServiceItem siBll = new ServiceItem();
siBll.UpdateHasContent(serviceItemId, false);
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
StringBuilder sb = new StringBuilder();
foreach (var model in list)
{
Dictionary <string, string> dic = null;
if (!string.IsNullOrWhiteSpace(model.FileDirectory) && !string.IsNullOrWhiteSpace(model.RandomFolder) && !string.IsNullOrWhiteSpace(model.FileExtension))
{
EnumData.Platform platform = EnumData.Platform.Android;
dic = PictureUrlHelper.GetUrlByPlatform(model.FileDirectory, model.RandomFolder, model.FileExtension, platform);
}
string sOriginalPicture = dic == null ? "" : dic["OriginalPicture"];
string sBPicture = dic == null ? "" : dic["BPicture"];
string sMPicture = dic == null ? "" : dic["MPicture"];
string sSPicture = dic == null ? "" : dic["SPicture"];
sb.Append("{\"Id\":\"" + model.Id + "\",\"ServiceItemId\":\"" + model.ServiceItemId + "\",\"ServiceItemName\":\"" + model.ServiceItemName + "\",\"Named\":\"" + model.Named + "\",\"Url\":\"" + model.Url + "\",\"Sort\":\"" + model.Sort + "\",\"LastUpdatedDate\":\"" + model.LastUpdatedDate.ToString("yyyy-MM-dd HH:mm") + "\"");
sb.Append(",\"OriginalPicture\":\"" + sOriginalPicture + "\",\"BPicture\":\"" + sBPicture + "\",\"MPicture\":\"" + sMPicture + "\",\"SPicture\":\"" + sSPicture + "\"},");
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}");
}
private void ExportOrderMake(HttpContext context)
{
var bll = new OrderMake();
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
#region 构造查询条件
var sOrderCode = context.Request.QueryString["OrderCode"];
var sCustomerCode = context.Request.QueryString["CustomerCode"];
var sStaffCode = context.Request.QueryString["StaffCode"];
var sPayWay = context.Request.QueryString["PayWay"];
var sServiceProduct = context.Request.QueryString["ServiceProduct"];
var sStartDate = context.Request.QueryString["StartDate"];
var sEndDate = context.Request.QueryString["EndDate"];
if (!string.IsNullOrWhiteSpace(sOrderCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and OrderCode like @OrderCode ");
var parm = new SqlParameter("@OrderCode", SqlDbType.VarChar, 36);
parm.Value = parm.Value = "%" + sOrderCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(sCustomerCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(400);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and CustomerCode like @CustomerCode ");
var parm = new SqlParameter("@CustomerCode", SqlDbType.VarChar, 36);
parm.Value = parm.Value = "%" + sCustomerCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(sStaffCode))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and StaffCode like @StaffCode ");
var parm = new SqlParameter("@StaffCode", SqlDbType.VarChar, 36);
parm.Value = parm.Value = "%" + sStaffCode + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(sPayWay))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(200);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and PayWay like @PayWay ");
var parm = new SqlParameter("@PayWay", SqlDbType.VarChar, 36);
parm.Value = parm.Value = "%" + sPayWay + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(sServiceProduct))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and ServiceProduct like @ServiceProduct ");
var parm = new SqlParameter("@ServiceProduct", SqlDbType.VarChar, 36);
parm.Value = parm.Value = "%" + sServiceProduct + "%";
parms.Add(parm);
}
#region 开始与结束日期段
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(sStartDate))
{
DateTime.TryParse(sStartDate, out startDate);
}
if (!string.IsNullOrWhiteSpace(sEndDate))
{
DateTime.TryParse(sEndDate, out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate >= @StartDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate <= @EndDate) ");
var parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
#endregion
#endregion
var ds = bll.GetExportData(sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
var dt = ds.Tables[0];
OpenXmlHelper.Export(context, dt);
}
private void ExportDeviceBorrowRecord(HttpContext context)
{
try
{
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
#region 构造查询条件
var keyword = context.Request.QueryString["Keyword"];
if (!string.IsNullOrWhiteSpace(keyword))
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.Append("and (Customer like @Keyword or SerialNumber like @Keyword or DeviceModel like @Keyword or DevicePart like @Keyword or PartStatus like @Keyword or ProjectAbout like @Keyword or SaleMan like @Keyword or Register like @Keyword or Remark like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 20);
parm.Value = parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
var typeName = context.Request.QueryString["TypeName"];
if (!string.IsNullOrWhiteSpace(typeName))
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
sqlWhere.Append("and FunType=@FunType ");
var parm = new SqlParameter("@FunType", SqlDbType.NVarChar, 20);
parm.Value = parm.Value = typeName;
parms.Add(parm);
}
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["StartDate"]))
{
DateTime.TryParse(context.Request.QueryString["StartDate"], out startDate);
}
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["EndDate"]))
{
DateTime.TryParse(context.Request.QueryString["EndDate"], out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate >= @StartDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate <= @EndDate) ");
var parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
var backDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["BackDate"]))
{
DateTime.TryParse(context.Request.QueryString["BackDate"], out backDate);
}
if (backDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and BackDate = @BackDate ");
var parm = new SqlParameter("@BackDate", SqlDbType.DateTime);
parm.Value = backDate;
parms.Add(parm);
}
var isBack = false;
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["IsBack"]) && bool.TryParse(context.Request.QueryString["IsBack"], out isBack))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and IsBack = @IsBack ");
var parm = new SqlParameter("@IsBack", SqlDbType.Bit);
parm.Value = isBack;
parms.Add(parm);
}
#endregion
var bll = new InfoneDeviceBorrowRecord();
var dt = bll.GetDsExport(sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
OpenXmlHelper.Export(context, dt.Tables[0]);
}
catch (Exception ex)
{
context.Response.Write(ResResult.ResJsonString(false, ex.Message, ""));
}
}
private void GetJsonForDatagrid(HttpContext context)
{
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
if (!string.IsNullOrWhiteSpace(context.Request.Form["page"]))
{
int.TryParse(context.Request.Form["page"], out pageIndex);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["rows"]))
{
int.TryParse(context.Request.Form["rows"], out pageSize);
}
if (pageIndex < 1)
{
pageIndex = 1;
}
if (pageSize < 10)
{
pageSize = 10;
}
string keyword = context.Request.Form["keyword"];
string sCategoryId = context.Request.Form["categoryId"];
string sBrandId = context.Request.Form["brandId"];
string sqlWhere = "";
ParamsHelper parms = null;
if (!string.IsNullOrWhiteSpace(keyword))
{
keyword = keyword.Trim();
sqlWhere += "and (p.ProductName like @ProductName or c.CategoryName like @CategoryName or b.BrandName like @BrandName) ";
if (parms == null)
{
parms = new ParamsHelper();
}
SqlParameter parm = new SqlParameter("@ProductName", SqlDbType.NVarChar, 50);
parm.Value = keyword;
parms.Add(parm);
parm = new SqlParameter("@CategoryName", SqlDbType.NVarChar, 50);
parm.Value = keyword;
parms.Add(parm);
parm = new SqlParameter("@BrandName", SqlDbType.NVarChar, 50);
parm.Value = keyword;
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(sCategoryId))
{
Guid categoryId = Guid.Empty;
Guid.TryParse(sCategoryId, out categoryId);
if (!categoryId.Equals(Guid.Empty))
{
sqlWhere += "and c.Id = @CategoryId ";
if (parms == null)
{
parms = new ParamsHelper();
}
SqlParameter parm = new SqlParameter("@CategoryId", SqlDbType.UniqueIdentifier);
parm.Value = categoryId;
parms.Add(parm);
}
}
if (!string.IsNullOrWhiteSpace(sBrandId))
{
Guid brandId = Guid.Empty;
Guid.TryParse(sBrandId, out brandId);
if (!brandId.Equals(Guid.Empty))
{
sqlWhere += "and b.Id = @BrandId ";
if (parms == null)
{
parms = new ParamsHelper();
}
SqlParameter parm = new SqlParameter("@BrandId", SqlDbType.UniqueIdentifier);
parm.Value = brandId;
parms.Add(parm);
}
}
ProductItem bll = new ProductItem();
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray());
if (list == null || list.Count == 0)
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}");
}
private void GetSearchItem()
{
string sStartTime = Request.QueryString["startTime"];
string sEndTime = Request.QueryString["endTime"];
DateTime startTime = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(sStartTime))
{
DateTime.TryParse(sStartTime, out startTime);
}
DateTime endTime = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(sEndTime))
{
DateTime.TryParse(sEndTime, out endTime);
}
if (startTime != DateTime.MinValue && endTime != DateTime.MinValue)
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and LastUpdatedDate between @StartTime and @EndTime ";
SqlParameter parm = new SqlParameter("@StartTime", SqlDbType.DateTime);
parm.Value = startTime;
parms.Add(parm);
parm = new SqlParameter("@EndTime", SqlDbType.DateTime);
parm.Value = endTime;
parms.Add(parm);
}
else
{
if (startTime != DateTime.MinValue)
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and LastUpdatedDate >= @StartTime ";
SqlParameter parm = new SqlParameter("@StartTime", SqlDbType.DateTime);
parm.Value = startTime;
parms.Add(parm);
}
if (endTime != DateTime.MinValue)
{
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and LastUpdatedDate <= @EndTime ";
SqlParameter parm = new SqlParameter("@EndTime", SqlDbType.DateTime);
parm.Value = endTime;
parms.Add(parm);
}
}
}
private void GetSearchItem()
{
if (!string.IsNullOrWhiteSpace(parentType))
{
switch (parentType)
{
case "0":
orderBy = "ho.PropertyCompanyId";
break;
case "1":
orderBy = "ho.ResidenceCommunityId";
break;
case "2":
orderBy = "ho.ResidentialBuildingId";
break;
case "3":
orderBy = "ho.ResidentialUnitId";
break;
case "4":
orderBy = "ho.HouseId";
break;
case "5":
orderBy = "ho.Id";
break;
default:
break;
}
}
if (!string.IsNullOrWhiteSpace(keyword))
{
if (!string.IsNullOrWhiteSpace(parentType))
{
#region 关键字在当前所属中查找
switch (parentType)
{
case "0":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and pc.CompanyName like @CompanyName ";
SqlParameter parm = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
break;
case "1":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and rc.CommunityName like @CommunityName ";
SqlParameter parm1 = new SqlParameter("@CommunityName", SqlDbType.NVarChar, 30);
parm1.Value = "%" + keyword + "%";
parms.Add(parm1);
break;
case "2":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and rb.BuildingCode like @BuildingCode ";
SqlParameter parm2 = new SqlParameter("@BuildingCode", SqlDbType.NVarChar, 20);
parm2.Value = "%" + keyword + "%";
parms.Add(parm2);
break;
case "3":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and ru.UnitCode like @UnitCode ";
SqlParameter parm3 = new SqlParameter("@UnitCode", SqlDbType.VarChar, 30);
parm3.Value = "%" + keyword + "%";
parms.Add(parm3);
break;
case "4":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and h.HouseCode like @HouseCode ";
SqlParameter parm4 = new SqlParameter("@HouseCode", SqlDbType.VarChar, 20);
parm4.Value = "%" + keyword + "%";
parms.Add(parm4);
break;
case "5":
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere += "and ho.HouseOwnerName like @HouseOwnerName ";
SqlParameter parm5 = new SqlParameter("@HouseOwnerName", SqlDbType.NVarChar, 30);
parm5.Value = "%" + keyword + "%";
parms.Add(parm5);
break;
default:
break;
}
#endregion
}
else
{
sqlWhere += "and (pc.CompanyName like @CompanyName or rc.CommunityName like @CommunityName or rb.BuildingCode like @BuildingCode or ru.UnitCode like @UnitCode or h.HouseCode like @HouseCode or ho.HouseOwnerName like @HouseOwnerName)";
if (parms == null)
{
parms = new ParamsHelper();
}
SqlParameter parm = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@CommunityName", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@BuildingCode", SqlDbType.NVarChar, 20);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@UnitCode", SqlDbType.VarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@HouseCode", SqlDbType.VarChar, 20);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
parm = new SqlParameter("@HouseOwnerName", SqlDbType.NVarChar, 30);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
}
}
private void GetSearch()
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (!User.IsInRole("System"))
{
sqlWhere += "and u.Code = @UserName ";
parms.Add(new SqlParameter("@UserName", User.Identity.Name));
}
string sStartDate = Request.QueryString["startDate"];
string sEndDate = Request.QueryString["endDate"];
string sOrderCode = Request.QueryString["order"];
txtOrderCode.Value = sOrderCode;
txtStartDate.Value = sStartDate;
txtEndDate.Value = sEndDate;
if (!string.IsNullOrWhiteSpace(sOrderCode))
{
sqlWhere += "and o.Code like @OrderCode ";
parms.Add(new SqlParameter("@OrderCode", "%" + sOrderCode.Trim() + "%"));
}
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrEmpty(sStartDate))
{
if (!DateTime.TryParse(sStartDate, out startDate))
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Submit_Params_InvalidRegex, "开始日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (!string.IsNullOrEmpty(sEndDate))
{
if (!DateTime.TryParse(sEndDate, out endDate))
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Submit_Params_InvalidRegex, "截止日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (startDate > endDate)
{
MessageBox.Messager(Page, MessageContent.GetString(MessageContent.Request_DateTime_CompareToError, "开始日期", "截止日期"), MessageContent.AlertTitle_Error, "error");
return;
}
}
if (startDate != DateTime.MinValue || endDate != DateTime.MinValue)
{
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
sqlWhere += "and BusinessDate between @StartDate and @EndDate ";
parms.Add(new SqlParameter("@StartDate", startDate));
parms.Add(new SqlParameter("@EndDate", endDate));
}
else
{
if (startDate != DateTime.MinValue)
{
sqlWhere += "and BusinessDate >= @StartDate ";
parms.Add(new SqlParameter("@StartDate", startDate));
}
if (endDate != DateTime.MinValue)
{
sqlWhere += "and BusinessDate <= @EndDate ";
parms.Add(new SqlParameter("@EndDate", endDate));
}
}
}
}
private void GetInfoneDeviceBorrowRecordList(HttpContext context, int pageIndex, int pageSize, string keyword, string typeName)
{
var bll = new InfoneDeviceBorrowRecord();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
#region 构造查询条件
if (!string.IsNullOrWhiteSpace(keyword))
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.Append("and (Customer like @Keyword or SerialNumber like @Keyword or DeviceModel like @Keyword or DevicePart like @Keyword or PartStatus like @Keyword or ProjectAbout like @Keyword or SaleMan like @Keyword or Register like @Keyword or Remark like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 20);
parm.Value = parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(typeName))
{
if (parms == null)
{
parms = new ParamsHelper();
}
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
sqlWhere.Append("and FunType=@FunType ");
var parm = new SqlParameter("@FunType", SqlDbType.NVarChar, 20);
parm.Value = parm.Value = typeName;
parms.Add(parm);
}
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.Form["StartDate"]))
{
DateTime.TryParse(context.Request.Form["StartDate"], out startDate);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["EndDate"]))
{
DateTime.TryParse(context.Request.Form["EndDate"], out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate >= @StartDate) ");
var parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(700);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (RecordDate <= @EndDate) ");
var parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
var backDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.Form["BackDate"]))
{
DateTime.TryParse(context.Request.Form["BackDate"], out backDate);
}
if (backDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and BackDate = @BackDate ");
var parm = new SqlParameter("@BackDate", SqlDbType.DateTime);
parm.Value = backDate;
parms.Add(parm);
}
var isBack = false;
if (!string.IsNullOrWhiteSpace(context.Request.Form["IsBack"]) && bool.TryParse(context.Request.Form["IsBack"], out isBack))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(100);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and IsBack = @IsBack ");
var parm = new SqlParameter("@IsBack", SqlDbType.Bit);
parm.Value = isBack;
parms.Add(parm);
}
#endregion
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}
public ResResultModel GetStockProductList(StockProductModel model)
{
try
{
ParamsHelper parms = new ParamsHelper();
StringBuilder sqlWhere = null;
var startDate = DateTime.MinValue;
var endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(model.StartDate))
{
DateTime.TryParse(model.StartDate, out startDate);
}
if (!string.IsNullOrWhiteSpace(model.EndDate))
{
DateTime.TryParse(model.EndDate, out endDate);
}
#region 查询条件
if (!string.IsNullOrWhiteSpace(model.Keyword))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.Append("and (p.ProductCode like @Keyword or p.ProductName like @Keyword or c.Coded like @Keyword or c.Named like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = "%" + model.Keyword + "%";
parms.Add(parm);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.AppendFormat("and sp.LastUpdatedDate between @StartDate and @EndDate ");
var parm = new SqlParameter("@StartDate", startDate);
parms.Add(parm);
parm = new SqlParameter("@EndDate", DateTime.Parse(string.Format("{0} 23:59:59", model.EndDate)));
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.AppendFormat("and sp.LastUpdatedDate >= @StartDate ");
var parm = new SqlParameter("@StartDate", startDate);
parms.Add(parm);
}
else if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
sqlWhere.AppendFormat("and sp.LastUpdatedDate <= @EndDate ");
var parm = new SqlParameter("@EndDate", DateTime.Parse(string.Format("{0} 23:59:59", model.EndDate)));
parms.Add(parm);
}
}
#endregion
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize < 1)
{
model.PageSize = 10;
}
int totalRecord = 0;
var bll = new StockProduct();
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
return(ResResult.Response(true, null, JsonConvert.SerializeObject(list)));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, null));
}
}
private void GetInfoneDeviceRepairRecordList(HttpContext context, int pageIndex, int pageSize, string keyword)
{
var bll = new InfoneDeviceRepairRecord();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
SqlParameter parm = null;
if (!string.IsNullOrWhiteSpace(keyword))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(2000);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (drr.Customer like @Keyword or drr.SerialNumber like @Keyword
or drr.DeviceModel like @Keyword or drr.FaultCause like @Keyword or drr.SolveMethod like @Keyword
or drr.CustomerProblem like @Keyword or drr.DevicePart like @Keyword or drr.TreatmentSituation like @Keyword
or drr.HandoverPerson like @Keyword or drr.RegisteredPerson like @Keyword or drr.Remark like @Keyword) ");
parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.Form["StartDate"]))
{
DateTime.TryParse(context.Request.Form["StartDate"], out startDate);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["EndDate"]))
{
DateTime.TryParse(context.Request.Form["EndDate"], out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (drr.RecordDate between @StartDate and @EndDate) ");
parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (drr.RecordDate >= @StartDate) ");
parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(1000);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (drr.RecordDate <= @EndDate) ");
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
var backDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.Form["BackDate"]))
{
DateTime.TryParse(context.Request.Form["BackDate"], out backDate);
}
if (backDate != DateTime.MinValue)
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(500);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and drr.BackDate = @BackDate ");
parm = new SqlParameter("@BackDate", SqlDbType.DateTime);
parm.Value = backDate;
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["WhetherFix"]))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(300);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and drr.WhetherFix = @WhetherFix ");
parm = new SqlParameter("@WhetherFix", SqlDbType.NVarChar, 20);
parm.Value = HttpUtility.UrlDecode(context.Request.Form["WhetherFix"].Trim());
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(context.Request.Form["IsBack"]))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder(50);
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and drr.IsBack = @IsBack ");
parm = new SqlParameter("@IsBack", SqlDbType.Bit);
parm.Value = context.Request.Form["IsBack"].Trim() == "1";
parms.Add(parm);
}
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}
public void AddRolesToUser(Dictionary <string, string> roleIdAndUserIdDic, string userName)
{
if (roleIdAndUserIdDic == null && roleIdAndUserIdDic.Count == 0)
{
return;
}
if (string.IsNullOrEmpty(userName))
{
return;
}
string cmdTextAppend = "";
ParamsHelper parms = new ParamsHelper();
string[] rolesForUser = GetRolesForUser(userName);
int n = 0;
foreach (string roleId in rolesForUser)
{
n++;
if (roleIdAndUserIdDic.ContainsKey(roleId))
{
roleIdAndUserIdDic.Remove(roleId);
}
else
{
cmdTextAppend += "delete Aspnet_UsersInRoles where RoleId = @DelRoleId" + n + "";
SqlParameter parm = new SqlParameter("@DelRoleId" + n + "", SqlDbType.UniqueIdentifier);
parm.Value = roleId;
parms.Add(parm);
}
}
if (roleIdAndUserIdDic.Count == 0)
{
return;
}
foreach (KeyValuePair <string, string> kvp in roleIdAndUserIdDic)
{
n++;
cmdTextAppend += "insert into Aspnet_UsersInRoles (UserId,RoleId) values (@UserId" + n + ",@RoleId" + n + ")";
SqlParameter parm = new SqlParameter("@UserId" + n + "", SqlDbType.UniqueIdentifier);
parm.Value = kvp.Value;
parms.Add(parm);
parm = new SqlParameter("@RoleId" + n + "", SqlDbType.UniqueIdentifier);
parm.Value = kvp.Key;
parms.Add(parm);
}
using (SqlConnection conn = new SqlConnection(SqlHelper.SqlProviderConnString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
int effect = SqlHelper.ExecuteNonQuery(tran, CommandType.Text, cmdTextAppend, parms != null ? parms.ToArray() : null);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
}
private void SetTexPrimitiveParams(TextureEntryFace face, PrimitiveParamsType type, AnArray.MarkEnumerator enumerator, ref UpdateChangedFlags flags, ref bool isUpdated, bool updateParams)
{
switch (type)
{
case PrimitiveParamsType.Texture:
{
UUID textureID = m_Part.GetTextureParam(enumerator, "PRIM_TEXTURE");
Vector3 repeats = ParamsHelper.GetVector(enumerator, "PRIM_TEXTURE");
Vector3 offsets = ParamsHelper.GetVector(enumerator, "PRIM_TEXTURE");
float rot = (float)ParamsHelper.GetDouble(enumerator, "PRIM_TEXTURE");
if (updateParams)
{
if (m_Part.TryFetchTexture(textureID))
{
face.TextureID = textureID;
}
face.RepeatU = (float)repeats.X;
face.RepeatV = (float)repeats.Y;
face.OffsetU = (float)offsets.X;
face.OffsetV = (float)offsets.Y;
face.Rotation = rot;
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.Color:
{
Vector3 color = ParamsHelper.GetVector(enumerator, "PRIM_COLOR");
double alpha = ParamsHelper.GetDouble(enumerator, "PRIM_COLOR").Clamp(0, 1);
if (updateParams)
{
face.TextureColor = new ColorAlpha(color, alpha);
flags |= UpdateChangedFlags.Color;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.Alpha:
{
double alpha = ParamsHelper.GetDouble(enumerator, "PRIM_ALPHA").Clamp(0, 1);
if (updateParams)
{
ColorAlpha color = face.TextureColor;
color.A = alpha;
face.TextureColor = color;
flags |= UpdateChangedFlags.Color;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.BumpShiny:
{
Shininess shiny = (Shininess)ParamsHelper.GetInteger(enumerator, "PRIM_BUMP_SHINY");
Bumpiness bump = (Bumpiness)ParamsHelper.GetInteger(enumerator, "PRIM_BUMP_SHINY");
if (updateParams)
{
face.Shiny = shiny;
face.Bump = bump;
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.FullBright:
{
bool fbright = ParamsHelper.GetBoolean(enumerator, "PRIM_FULLBRIGHT");
if (updateParams)
{
face.FullBright = fbright;
flags |= UpdateChangedFlags.Color;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.TexGen:
{
MappingType mapType = (MappingType)ParamsHelper.GetInteger(enumerator, "PRIM_TEXGEN");
if (updateParams)
{
face.TexMapType = mapType;
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.Glow:
{
float glow = (float)ParamsHelper.GetDouble(enumerator, "PRIM_GLOW").Clamp(0, 1);
if (updateParams)
{
face.Glow = glow;
flags |= UpdateChangedFlags.Color;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.AlphaMode:
/* [ PRIM_ALPHA_MODE, integer face, integer alpha_mode, integer mask_cutoff ] */
{
Material mat;
try
{
mat = m_Part.ObjectGroup.Scene.GetMaterial(face.MaterialID);
}
catch
{
mat = new Material();
}
mat.DiffuseAlphaMode = ParamsHelper.GetInteger(enumerator, "PRIM_ALPHA_MODE");
mat.AlphaMaskCutoff = ParamsHelper.GetInteger(enumerator, "PRIM_ALPHA_MODE");
if (updateParams)
{
mat.DiffuseAlphaMode = mat.DiffuseAlphaMode.Clamp(0, 3);
mat.AlphaMaskCutoff = mat.AlphaMaskCutoff.Clamp(0, 3);
mat.MaterialID = UUID.Random;
m_Part.ObjectGroup.Scene.StoreMaterial(mat);
face.MaterialID = mat.MaterialID;
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.Normal:
/* [ PRIM_NORMAL, integer face, string texture, vector repeats, vector offsets, float rotation_in_radians ] */
{
UUID texture = m_Part.GetTextureParam(enumerator, "PRIM_NORMAL");
Vector3 repeats = ParamsHelper.GetVector(enumerator, "PRIM_NORMAL");
Vector3 offsets = ParamsHelper.GetVector(enumerator, "PRIM_NORMAL");
double rotation = ParamsHelper.GetDouble(enumerator, "PRIM_NORMAL");
if (updateParams)
{
repeats.X *= Material.MATERIALS_MULTIPLIER;
repeats.Y *= Material.MATERIALS_MULTIPLIER;
offsets.X *= Material.MATERIALS_MULTIPLIER;
offsets.Y *= Material.MATERIALS_MULTIPLIER;
rotation %= Math.PI * 2;
rotation *= Material.MATERIALS_MULTIPLIER;
Material mat;
try
{
mat = m_Part.ObjectGroup.Scene.GetMaterial(face.MaterialID);
}
catch
{
mat = new Material();
}
mat.NormMap = texture;
mat.NormOffsetX = (int)Math.Round(offsets.X);
mat.NormOffsetY = (int)Math.Round(offsets.Y);
mat.NormRepeatX = (int)Math.Round(repeats.X);
mat.NormRepeatY = (int)Math.Round(repeats.Y);
mat.NormRotation = (int)Math.Round(rotation);
mat.MaterialID = UUID.Random;
if (m_Part.TryFetchTexture(texture))
{
m_Part.ObjectGroup.Scene.StoreMaterial(mat);
face.MaterialID = mat.MaterialID;
}
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
case PrimitiveParamsType.Specular:
/* [ PRIM_SPECULAR, integer face, string texture, vector repeats, vector offsets, float rotation_in_radians, vector color, integer glossiness, integer environment ] */
{
UUID texture = m_Part.GetTextureParam(enumerator, "PRIM_NORMAL");
Vector3 repeats = ParamsHelper.GetVector(enumerator, "PRIM_SPECULAR");
Vector3 offsets = ParamsHelper.GetVector(enumerator, "PRIM_SPECULAR");
repeats *= Material.MATERIALS_MULTIPLIER;
offsets *= Material.MATERIALS_MULTIPLIER;
double rotation = ParamsHelper.GetDouble(enumerator, "PRIM_SPECULAR");
rotation %= Math.PI * 2;
rotation *= Material.MATERIALS_MULTIPLIER;
var color = new ColorAlpha(ParamsHelper.GetVector(enumerator, "PRIM_SPECULAR"), 1);
int glossiness = ParamsHelper.GetInteger(enumerator, "PRIM_SPECULAR");
int environment = ParamsHelper.GetInteger(enumerator, "PRIM_SPECULAR");
if (updateParams)
{
environment = environment.Clamp(0, 255);
glossiness = glossiness.Clamp(0, 255);
Material mat;
try
{
mat = m_Part.ObjectGroup.Scene.GetMaterial(face.MaterialID);
}
catch
{
mat = new Material();
}
mat.SpecColor = color;
mat.SpecMap = texture;
mat.SpecOffsetX = (int)Math.Round(offsets.X);
mat.SpecOffsetY = (int)Math.Round(offsets.Y);
mat.SpecRepeatX = (int)Math.Round(repeats.X);
mat.SpecRepeatY = (int)Math.Round(repeats.Y);
mat.SpecRotation = (int)Math.Round(rotation);
mat.EnvIntensity = environment;
mat.SpecExp = glossiness;
mat.MaterialID = UUID.Random;
if (m_Part.TryFetchTexture(texture))
{
m_Part.ObjectGroup.Scene.StoreMaterial(mat);
face.MaterialID = mat.MaterialID;
}
flags |= UpdateChangedFlags.Texture;
isUpdated = true;
}
}
break;
default:
throw new ArgumentException($"Internal error! Primitive parameter type {type} should not be passed to PrimitiveFace");
}
}
private void ExportDeviceRepairRecord(HttpContext context)
{
try
{
#region 动态创建查询条件
var sqlWhere = new StringBuilder(1000);
var parms = new ParamsHelper();
SqlParameter parm = null;
var keyword = string.Empty;
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["keyword"]))
{
keyword = HttpUtility.UrlDecode(context.Request.QueryString["keyword"]).Trim();
}
if (!string.IsNullOrWhiteSpace(keyword))
{
sqlWhere.Append(@"and (drr.Customer like @Customer or drr.SerialNumber like @SerialNumber
or drr.DeviceModel like @DeviceModel or drr.FaultCause like @FaultCause or drr.SolveMethod like @SolveMethod
or drr.CustomerProblem like @CustomerProblem or drr.DevicePart like @DevicePart or drr.TreatmentSituation like @TreatmentSituation
or drr.HandoverPerson like @HandoverPerson or drr.RegisteredPerson like @RegisteredPerson or drr.Remark like @Remark) ");
parms.Add(new SqlParameter("@Customer", "%" + keyword + "%"));
parms.Add(new SqlParameter("@SerialNumber", "%" + keyword + "%"));
parms.Add(new SqlParameter("@DeviceModel", "%" + keyword + "%"));
parms.Add(new SqlParameter("@FaultCause", "%" + keyword + "%"));
parms.Add(new SqlParameter("@SolveMethod", "%" + keyword + "%"));
parms.Add(new SqlParameter("@CustomerProblem", "%" + keyword + "%"));
parms.Add(new SqlParameter("@DevicePart", "%" + keyword + "%"));
parms.Add(new SqlParameter("@TreatmentSituation", "%" + keyword + "%"));
parms.Add(new SqlParameter("@HandoverPerson", "%" + keyword + "%"));
parms.Add(new SqlParameter("@RegisteredPerson", "%" + keyword + "%"));
parms.Add(new SqlParameter("@Remark", "%" + keyword + "%"));
}
DateTime startDate = DateTime.MinValue;
DateTime endDate = DateTime.MinValue;
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["startDate"]))
{
DateTime.TryParse(context.Request.QueryString["startDate"], out startDate);
}
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["endDate"]))
{
DateTime.TryParse(context.Request.QueryString["endDate"], out endDate);
}
if (startDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
sqlWhere.AppendFormat(@"and (drr.RecordDate between @StartDate and @EndDate) ");
parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
else
{
if (startDate != DateTime.MinValue)
{
sqlWhere.AppendFormat(@"and (drr.RecordDate >= @StartDate) ");
parm = new SqlParameter("@StartDate", SqlDbType.DateTime);
parm.Value = startDate;
parms.Add(parm);
}
if (endDate != DateTime.MinValue)
{
sqlWhere.AppendFormat(@"and (drr.RecordDate <= @EndDate) ");
parm = new SqlParameter("@EndDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59");
parms.Add(parm);
}
}
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["backDate"]))
{
sqlWhere.AppendFormat(@"and drr.BackDate = @BackDate ");
parm = new SqlParameter("@BackDate", SqlDbType.DateTime);
parm.Value = DateTime.Parse(context.Request.QueryString["backDate"]);
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["whetherFix"]))
{
sqlWhere.AppendFormat(@"and drr.WhetherFix = @WhetherFix ");
parm = new SqlParameter("@WhetherFix", SqlDbType.NVarChar, 20);
parm.Value = HttpUtility.UrlDecode(context.Request.QueryString["whetherFix"].Trim());
parms.Add(parm);
}
if (!string.IsNullOrWhiteSpace(context.Request.QueryString["isBack"]))
{
sqlWhere.AppendFormat(@"and drr.IsBack = @IsBack ");
parm = new SqlParameter("@IsBack", SqlDbType.Bit);
parm.Value = context.Request.QueryString["isBack"].Trim() == "1";
parms.Add(parm);
}
#endregion
var bll = new InfoneDeviceRepairRecord();
var dt = bll.GetExportToExcelData(sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
OpenXmlHelper.Export(context, dt);
}
catch (Exception ex)
{
context.Response.Write(ResResult.ResJsonString(false, ex.Message, ""));
}
}
/// <summary>
/// 按类型得到一个参数
/// </summary>
/// <typeparam name="T">参数类型</typeparam>
/// <param name="data">输出的数据</param>
/// <returns>错误信息，没有错误返回""</returns>
public string GetParams <T>(out T data)
{
return(ParamsHelper.GetParams(Data, out data));
}
private void GetSearchItem()
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["adFun"]))
{
Guid siteFunId = Guid.Empty;
Guid.TryParse(Request.QueryString["adFun"], out siteFunId);
if (!siteFunId.Equals(Guid.Empty))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder();
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and ad.SiteFunId = @SiteFunId ");
SqlParameter parm = new SqlParameter("@SiteFunId", SqlDbType.UniqueIdentifier);
parm.Value = siteFunId;
parms.Add(parm);
}
}
if (!string.IsNullOrWhiteSpace(Request.QueryString["adLayout"]))
{
Guid layoutPositionId = Guid.Empty;
Guid.TryParse(Request.QueryString["adLayout"], out layoutPositionId);
if (!layoutPositionId.Equals(Guid.Empty))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder();
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append("and ad.LayoutPositionId = @LayoutPositionId ");
SqlParameter parm = new SqlParameter("@LayoutPositionId", SqlDbType.UniqueIdentifier);
parm.Value = layoutPositionId;
parms.Add(parm);
}
}
if (!string.IsNullOrEmpty(keyword))
{
if (sqlWhere == null)
{
sqlWhere = new StringBuilder();
}
if (parms == null)
{
parms = new ParamsHelper();
}
sqlWhere.Append(@"and (ad.Title like @Title or at.TypeCode like @Title or at.TypeCode like @Title or at.TypeName like @Title or at.TypeValue like @Title
or at1.TypeCode like @Title or at1.TypeName like @Title or at1.TypeValue like @Title
) ");
SqlParameter parm = new SqlParameter("@Title", SqlDbType.NVarChar, 50);
parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
}
public void GetObjectDetails(IEnumerator <IValue> enumerator, AnArray paramList)
{
while (enumerator.MoveNext())
{
/* LSL ignores non-integer parameters, see http://wiki.secondlife.com/wiki/LlGetObjectDetails. */
if (enumerator.Current.LSL_Type != LSLValueType.Integer)
{
continue;
}
switch (ParamsHelper.GetObjectDetailsType(enumerator))
{
case ObjectDetailsType.Name:
paramList.Add(Name);
break;
case ObjectDetailsType.Desc:
paramList.Add(Description);
break;
case ObjectDetailsType.Pos:
paramList.Add(Position);
break;
case ObjectDetailsType.Rot:
paramList.Add(GlobalRotation);
break;
case ObjectDetailsType.Velocity:
paramList.Add(Velocity);
break;
case ObjectDetailsType.LastOwner:
case ObjectDetailsType.Owner:
case ObjectDetailsType.Creator:
case ObjectDetailsType.RezzerKey:
paramList.Add(ID);
break;
case ObjectDetailsType.Root:
{
ObjectGroup grp = SittingOnObject;
paramList.Add(grp != null ? grp.ID : ID);
}
break;
case ObjectDetailsType.Group:
paramList.Add(Group.ID);
break;
case ObjectDetailsType.GroupTag:
paramList.Add(GetGroupTag());
break;
case ObjectDetailsType.AttachedSlotsAvailable:
paramList.Add(Attachments.AvailableSlots);
break;
case ObjectDetailsType.RunningScriptCount:
{
int runningScriptCount = 0;
foreach (ObjectGroup grp in Attachments.All)
{
foreach (ObjectPart part in grp.Values)
{
runningScriptCount += part.Inventory.CountRunningScripts;
}
}
paramList.Add(runningScriptCount);
}
break;
case ObjectDetailsType.TotalScriptCount:
{
int n = 0;
foreach (ObjectGroup grp in Attachments.All)
{
foreach (ObjectPart part in grp.Values)
{
n += part.Inventory.CountScripts;
}
}
paramList.Add(n);
}
break;
case ObjectDetailsType.PrimEquivalence:
paramList.Add(1);
break;
case ObjectDetailsType.PathfindingType:
paramList.Add(1); // this is OPT_AVATAR
break;
case ObjectDetailsType.ScriptTime:
case ObjectDetailsType.ServerCost:
case ObjectDetailsType.StreamingCost:
case ObjectDetailsType.PhysicsCost:
paramList.Add(0f);
break;
case ObjectDetailsType.ScriptMemory:
case ObjectDetailsType.CharacterTime:
case ObjectDetailsType.AttachedPoint:
paramList.Add(0);
break;
case ObjectDetailsType.Physics:
paramList.Add(true);
break;
case ObjectDetailsType.Phantom:
case ObjectDetailsType.TempOnRez:
case ObjectDetailsType.TempAttached:
paramList.Add(false);
break;
case ObjectDetailsType.HoverHeight:
paramList.Add(HoverHeight);
break;
case ObjectDetailsType.BodyShapeType:
paramList.Add(GenderVp);
break;
case ObjectDetailsType.ClickAction:
paramList.Add((int)ClickActionType.None);
break;
case ObjectDetailsType.Omega:
paramList.Add(AngularVelocity);
break;
case ObjectDetailsType.CreationTime:
paramList.Add(string.Empty);
break;
case ObjectDetailsType.SelectCount:
case ObjectDetailsType.SitCount:
paramList.Add(0);
break;
case ObjectDetailsType.RenderWeight:
default:
paramList.Add(-1);
break;
}
}
}
/// <summary>
/// The add family parameters.
/// </summary>
/// <param name="families">
/// The families.
/// </param>
/// <param name="isAddShared"></param>
/// <param name="checkProject"></param>
/// <exception cref="ArgumentException">Throws when no families are checked
/// </exception>
public static void AddFamilyParameters(ObservableCollection <FamilyCategory> families, bool isAddShared, bool checkProject)
{
List <Family> fam = (from familyCategory in families
from item in familyCategory.Members
where ItemHelper.GetIsChecked(item) == true
select item.Family).ToList();
if (fam.Count == 0)
{
throw new ArgumentException("Пожалуйста, выберите семейства, в которые вы хотите добавить параметры");
}
if (isAddShared && ((SharedParameterFile == null) || (SharedParameterFile.Filename == string.Empty)))
{
throw new ArgumentException("Выбранный файл общих параметров не существует. Пожалуйста, выберите другой файл или создайте новый");
}
var results = new List <AddFamilyParametersResult>();
List <RevitParameter> dataList = ParamsHelper.LoadExcel();
if (dataList != null)
{
foreach (Family family in fam)
{
var familyParametersResult = new AddFamilyParametersResult(family);
Document familyDoc;
if (family.IsEditable)
{
familyParametersResult.FamilyDocument = familyDoc = revitDocument.EditFamily(family);
}
else
{
familyParametersResult.Skipped = true;
results.Add(familyParametersResult);
continue;
}
using (var t = new Transaction(familyDoc))
{
t.Start($"editing {family.Name}");
try
{
AddFamilyParameters(familyDoc, dataList, familyParametersResult, isAddShared, checkProject);
}
catch (Exception e)
{
TaskDialog.Show("Add Family Parameters", e.Message);
break;
}
t.Commit();
}
results.Add(familyParametersResult);
}
if (results.Count != 0)
{
var opt = new FamilyLoadingOptions();
foreach (var r in results)
{
if (r.FamilyDocument != null)
{
r.FamilyDocument.LoadFamily(revitDocument, opt);
r.FamilyDocument.Close(false);
}
}
AddFamilyParametersResult.ShowResultsDialog(results);
}
}
}
