/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.AddSearch("UserId", UserInfo.UserID);
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()) && item.PropertyName == "Month")
{
where += " month(ApplyTime)=" + item.Value.ToString() + " ";
}
if (!String.IsNullOrEmpty(item.Value.ToString()) && item.PropertyName == "Year")
{
where += " Year(ApplyTime)=" + item.Value.ToString() + " ";
}
}
if (!string.IsNullOrEmpty(where))
{
SearchCriterion.Searches.RemoveSearch("Month");
SearchCriterion.Searches.RemoveSearch("Year");
ents = UsrChildWelfare.FindAll(SearchCriterion, Expression.Sql(where));
}
else
{
ents = UsrChildWelfare.FindAll(SearchCriterion);
}
this.PageState.Add("UsrChildWelfareList", ents);
}
protected void Page_Load(object sender, EventArgs e)
{
cid = RequestData.Get <string>("cid", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "role").ToLower();
if (!String.IsNullOrEmpty(cid))
{
try
{
int icid = Convert.ToInt32(cid);
SearchCriterion.AddSearch("Type", icid);
ents = SysRoleRule.FindAll(SearchCriterion);
}
catch { }
}
else
{
ents = SysRoleRule.FindAll(SearchCriterion);
}
this.PageState.Add("DtList", ents);
}
private void DoSelect()
{
sql = @"select Id as IndicatorFirstId ,IndicatorFirstName from BJKY_Examine..IndicatorFirst
where ExamineIndicatorId = '" + ExamineIndicatorId + "' order by SortIndex asc ";
EasyDictionary dic = DataHelper.QueryDict(sql, "IndicatorFirstId", "IndicatorFirstName");
PageState.Add("IndictorFirstEnum", dic);//Combo数据集
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = IndicatorSecond.Find(id);
}
SetFormData(ent);
SearchCriterion.AddSearch(ScoreStandard.Prop_IndicatorSecondId, id);
SearchCriterion.SetOrder("SortIndex", true);
ents = ScoreStandard.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
}
else
{
if (!string.IsNullOrEmpty(IndicatorFirstId))
{
IndicatorFirst ifEnt = IndicatorFirst.Find(IndicatorFirstId);
sql = "select isnull(max(SortIndex),0) from BJKY_Examine..IndicatorSecond where IndicatorFirstId='" + IndicatorFirstId + "'";
var obj = new
{
SortIndex = DataHelper.QueryValue <int>(sql) + 1,
ExamineIndicatorId = ExamineIndicatorId
};
SetFormData(obj);
}
}
}
private void DoSelect()
{
string index = RequestData.Get <string>("Index");
string where = "";
string detailwhere = "";
string payState = RequestData.Get <string>("PayState");
string inWarehouseState = RequestData.Get <string>("InWarehouseState");
string orderState = RequestData.Get <string>("OrderState");
if (!string.IsNullOrEmpty(payState))
{
SearchCriterion.AddSearch("PayState", payState);
}
if (!string.IsNullOrEmpty(inWarehouseState))
{
SearchCriterion.AddSearch("InWarehouseState", inWarehouseState);
}
if (!string.IsNullOrEmpty(orderState))
{
SearchCriterion.AddSearch("OrderState", orderState);
}
string sql = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate" && item.Value.ToString() != "")
{
where += " and CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value.ToString() != "")
{
where += " and CreateTime<'" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value.ToString() != "")
{
if (item.PropertyName != "Code")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
}
else
{
detailwhere = "where " + item.PropertyName + " like '%" + item.Value + "%'";
}
}
}
if (index == "0")
{
sql = @"select A.* from SHHG_AimExamine..PurchaseOrder as A
where A.InWarehouseState='未入库' and A.Id in
(select distinct PurchaseOrderId from SHHG_AimExamine..PurchaseOrderDetail " + detailwhere + ")" + where;
}//采购人员也能看到别人做的采购订单所以这里不加人员过滤
else
{
sql = @"select A.* from SHHG_AimExamine..PurchaseOrder as A
where A.InWarehouseState='已入库' and A.Id in
(select distinct PurchaseOrderId from SHHG_AimExamine..PurchaseOrderDetail " + detailwhere + ")" + where;
}
PageState.Add("PurchaseOrderList", GetPageData(sql, SearchCriterion));
}
private void DoSelect()
{
CommPowerSplit ps = new CommPowerSplit();
if (ps.IsSurveyRole(UserInfo.UserID, UserInfo.LoginName))
{
SearchCriterion.SetSearch("IsFixed", "2"); //固定问卷
SurveyQuestion[] Ents = SurveyQuestion.FindAll(SearchCriterion);
this.PageState.Add("DataList", Ents);
}
else
{
SearchCriterion.SetSearch("IsFixed", "2"); //固定问卷
string CompanyId = string.Empty; //公司ID
//first depend login corpid
var Ent = SysUser.Find(UserInfo.UserID);
UserContextInfo UC = new UserContextInfo();
CompanyId = UC.GetUserCurrentCorpId(UserInfo.UserID);
SearchCriterion.AddSearch("CompanyId", CompanyId);
SurveyQuestion[] Ents = SurveyQuestion.FindAll(SearchCriterion);
this.PageState.Add("DataList", Ents);
}
}
private void DoSelect()
{
SearchCriterion.AddSearch(ExamineTask.Prop_ExamineStageId, ExamineStageId);
IList <ExamineStageResult> esrEnts = ExamineStageResult.FindAll(SearchCriterion);
PageState.Add("DataList", esrEnts);
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string QuestionId = RequestData.Get <string>("Id");
SearchCriterion.AddSearch(EmpVoiceAnswerInfo.Prop_QuestionId, QuestionId);
ents = EmpVoiceAnswerInfo.FindAll(SearchCriterion);
this.PageState.Add("EmpVoiceAnswerInfoList", ents);
}
string code = String.Empty; // 编码
#endregion
#region 构造函数
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
type = RequestData.Get <string>("type");
code = RequestData.Get <string>("code");
DynamicAuthCatalog dac = null; // 动态权限类型
SearchCriterion sc = new HqlSearchCriterion();
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
SearchCriterion.AddSearch("EditStatus", "G", SearchModeEnum.Like); // 只显示允许授权的节点
if (type == "catalog")
{
if (String.IsNullOrEmpty(code) && !String.IsNullOrEmpty(id))
{
dac = DynamicAuthCatalog.Find(id);
code = dac.Code;
}
if (!String.IsNullOrEmpty(code))
{
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
ents = DynamicAuthRule.FindAll(SearchCriterion);
if (dac == null)
{
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", code));
}
}
}
else if (!String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", id);
ents = DynamicAuthRule.FindAll(SearchCriterion);
DynamicAuth da = DynamicAuth.Find(id);
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", da.CatalogCode));
}
this.PageState.Add("EntList", ents);
if (!IsAsyncRequest)
{
if (dac != null)
{
IList <DynamicPermissionCatalog> dpcs = dac.AllowGrantPermissionCatalog;
this.PageState.Add("PCatalogList", dpcs);
}
}
}
/// <summary>
/// 选择操作
/// </summary>
private void DoSelect()
{
DynamicAuthCatalog dac = null; // 动态权限类型
SearchCriterion sc = new HqlSearchCriterion();
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
SearchCriterion.AddSearch("EditStatus", "G", SearchModeEnum.Like); // 只显示允许授权的节点
if (type == "catalog")
{
if (String.IsNullOrEmpty(code) && !String.IsNullOrEmpty(id))
{
dac = DynamicAuthCatalog.Find(id);
code = dac.Code;
}
if (!String.IsNullOrEmpty(code))
{
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
ents = DynamicAuthRule.FindAll(SearchCriterion);
if (dac == null)
{
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", code));
}
}
}
else if (!String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", id);
ents = DynamicAuthRule.FindAll(SearchCriterion);
DynamicAuth da = DynamicAuth.Find(id);
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", da.CatalogCode));
}
this.PageState.Add("EntList", ents);
if (!IsAsyncRequest)
{
if (dac != null)
{
IList <DynamicPermissionCatalog> dpcs = dac.AllowGrantPermissionCatalog;
this.PageState.Add("PCatalogList", dpcs);
this.PageState.Add("AllowOperation", dac.GetAllowOperations()); // 允许的操作
}
this.PageState.Add("OpDivChar", DynamicOperations.DivChar); // 操作分割符
}
}
string code = String.Empty; // 对象类型
#endregion
#region 构造函数
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
code = RequestData.Get <string>("code");
if (IsAsyncRequest)
{
DynamicAuth ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Read:
case RequestActionEnum.Query:
case RequestActionEnum.Default:
if (SearchCriterion.Orders.Count <= 0)
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
}
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("EditStatus", SingleSearchModeEnum.IsNotNull);
SearchCriterion.AddSearch("EditStatus", "", SearchModeEnum.NotEqual);
if (String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
}
else
{
SearchCriterion.AddSearch("ParentID", id);
}
ents = DynamicAuthRule.FindAll(SearchCriterion);
break;
case RequestActionEnum.Delete:
ent = DynamicAuth.Find(id);
ent.DoDelete();
this.SetMessage("删除成功！");
break;
}
this.PageState.Add("EntList", ents);
}
else
{
SearchCriterion sc = new HqlSearchCriterion();
sc.SetOrder("SortIndex");
sc.SetOrder("CreatedDate");
DynamicAuthCatalog[] entCatalogs = DynamicAuthCatalogRule.FindAll(sc);
this.PageState.Add("EntCatalogList", entCatalogs);
}
}
private void DoSelect()
{
string type = this.RequestData.Get("VedioType") + "";
if (!string.IsNullOrEmpty(type))
{
SearchCriterion.AddSearch(Vedio.Prop_VedioType, type);
}
ents = Vedio.FindAll(SearchCriterion);
this.PageState.Add("DataList", ents);
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
// 类型标识
cid = RequestData.Get <string>("cid", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "role").ToLower();
if (!IsAsyncRequest)
{
cid = "2"; //WGM 13/4/7 默认组织结构
if (!String.IsNullOrEmpty(cid))
{
try
{
int icid = Convert.ToInt32(cid);
SearchCriterion.SetOrder("ParentID");
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreateDate");
SearchCriterion.AddSearch("Type", icid);
ents = SysGroupRule.FindAll(SearchCriterion);
}
catch { }
this.PageState.Add("DtList", ents);
}
else
{
SysGroupType[] typeList = SysGroupTypeRule.FindAll();
this.PageState.Add("DtList", typeList);
}
}
else
{
switch (this.RequestAction)
{
case RequestActionEnum.Custom:
if (RequestActionString == "querychildren")
{
if (type == "gtype")
{
ents = SysGroup.FindAll("FROM SysGroup as ent WHERE ent.Type = ?", id);
this.PageState.Add("DtList", ents);
}
}
break;
}
}
}
/// <summary>
/// default
/// </summary>
private void DoSelect()
{
string PId = RequestData.Get("PId") + "";
if (!string.IsNullOrEmpty(PId))
{
//ManagementInfo.Prop_PId, PId);
SearchCriterion.AddSearch("PId", PId);
SearchCriterion.SetOrder(ManagementInfo.Prop_CreateTime, false);
var Ents = ManagementInfo.FindAll(SearchCriterion);
this.PageState.Add("DataList", Ents);
}
}
protected void Page_Load(object sender, EventArgs e)
{
cid = RequestData.Get <string>("cid", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "role").ToLower();
if (RequestActionString == "getData")
{
string filedVal = this.RequestData.Get("filedVal") + "";
string sql = @"select top 200 A.RoleID,A.Code,A.Description,A.Type,A.SortIndex,
A.Name +' ['+ case when B.name is not null then B.Name+'/' else '' end +
C.Name + ']' AS Name
from Sysrole AS A
left join SysGroup As B
on A.Pk_corp=B.GroupID
left join SysGroup As C
on A.pk_deptdoc=C.GroupID
where A.Isabort='N' and len(A.Pk_corp)>0 and len(A.pk_deptdoc)>0 and A.Name like '%{0}%' ";
sql = sql.Replace("FL_PortalHR", Global.AimPortalDB);
sql = string.Format(sql, filedVal);
this.PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
if (!String.IsNullOrEmpty(cid))
{
try
{
int icid = Convert.ToInt32(cid);
SearchCriterion.AddSearch("Type", icid);
ents = SysRoleRule.FindAll(SearchCriterion);
this.PageState.Add("DtList", ents);
}
catch { }
}
else
{
string sql = @" select top 100 A.RoleID,A.Code,A.Description,A.Type,A.SortIndex,
A.Name+' ['+ case when B.name is not null then B.Name+'/' else '' end +
C.Name + ']' AS Name
from Sysrole AS A
left join SysGroup As B
on A.Pk_corp=B.GroupID
left join SysGroup As C
on A.pk_deptdoc=C.GroupID
where A.Isabort='N' and len(A.Pk_corp)>0 and len(A.pk_deptdoc)>0";
ents = SysRoleRule.FindAll(SearchCriterion);
this.PageState.Add("DtList", DataHelper.QueryDictList(sql));
}
}
private void DoSelect()
{
string where = "";
string productType = RequestData.Get <string>("ProductType");
if (!string.IsNullOrEmpty(productType))
{
SearchCriterion.AddSearch("ProductType", productType);
}
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate1" && item.Value + "" != "")
{
where += " and B.CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate1" && item.Value + "" != "")
{
where += " and B.CreateTime<'" + (item.Value + "").Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.PropertyName == "BeginDate" && item.Value + "" != "")
{
where += " and B.EndDate>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value + "" != "")
{
where += " and B.EndDate<'" + (item.Value + "").Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value + "" != "")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%' ";
}
}
string sql = @"select A.*,B.Number,B.CName,B.Salesman,B.EndDate,B.InvoiceNumber,C.ProductType,C.Pcn,C.CostPrice,
SHHG_AimExamine.dbo.fun_CaculateCostAmount(A.PId,A.Count,A.SalePrice) as CostAmount,
(select top(1) Rate from SHHG_AimExamine..ExchangeRate where Symbo =(select top(1) Symbo from SHHG_AimExamine..Supplier where Id=C.SupplierId )) as Rate,
SHHG_AimExamine.dbo.fun_CaculateBuyPrice(A.PId) as BuyPrice, B.CreateTime
from (
select OId,PId,PCode,PName,Isbn,sum([count]) as [Count],max(SalePrice) as SalePrice, sum(Amount) as Amount from(
select OId,PId,PCode,PName,Isbn,([Count]-isnull(ReturnCount,0)) as Count,SalePrice,Amount from SHHG_AimExamine..OrdersPart
)t
group by PId,PCode,PName,Isbn,OId having sum([Count])>0
) as A
left join SHHG_AimExamine..SaleOrders as B on A.OId=B.Id
left join SHHG_AimExamine..Products as C on C.Id=A.PId
where (B.DeliveryState is null or B.DeliveryState<>'已作废') and B.InvoiceType='发票' " + where;
PageState.Add("OrderList", GetPageData(sql, SearchCriterion));
}
private void ProcessDetail(IList <string> strList, StockCheck ent)
{
StockCheckDetail scdEnt = null;
foreach (string str in strList)
{
JObject json = JsonHelper.GetObject <JObject>(str);
scdEnt = StockCheckDetail.Find(json.Value <string>("Id"));
if (json.Value <int>("StockCheckQuantity") >= 0)
{
scdEnt.StockCheckQuantity = json.Value <int>("StockCheckQuantity");
if (scdEnt.StockQuantity > scdEnt.StockCheckQuantity)
{
scdEnt.StockCheckResult = "盘亏";
}
if (scdEnt.StockQuantity < scdEnt.StockCheckQuantity)
{
scdEnt.StockCheckResult = "盘赢";
}
if (scdEnt.StockQuantity == scdEnt.StockCheckQuantity)
{
scdEnt.StockCheckResult = "正常";
scdEnt.StockCheckState = "盘点结束";
}
scdEnt.DoUpdate();
}
}
//1 如果所有的盘点明细都正常 则把盘点单的状态改为已结束
SearchCriterion.AddSearch("StockCheckResult", "正常", SearchModeEnum.NotEqual);
IList <StockCheckDetail> scdEnts = StockCheckDetail.FindAll(SearchCriterion);
if (scdEnts.Count == 0)
{
ent.State = "已结束"; ent.Result = "正常";
}
else
{
ent.Result = "异常";
}
ent.DoUpdate();
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
if (!SearchCriterion.Orders.Exists(en => en.PropertyName == "CreateTime"))
{
SearchCriterion.Orders.Add(new OrderCriterionItem("CreateTime", false));
}
string paystate = RequestData.Get <string>("paystate");
if (paystate == "1")
{
SearchCriterion.AddSearch("PayState", "1");
ents = Logistic.FindAll(SearchCriterion);
}
else
{
ents = Logistic.FindAll(SearchCriterion, Expression.Sql(" isnull(PayState,0) <> '1' "));
}
this.PageState.Add("LogisticList", ents);
}
private void DoSelect()
{
string where = "";
string detailwhere = "";
string state = RequestData.Get <string>("State");
if (!string.IsNullOrEmpty(state))
{
SearchCriterion.AddSearch("State", state);
}
string sql = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate" && item.Value.ToString() != "")
{
where += " and CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value.ToString() != "")
{
where += " and CreateTime<'" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value.ToString() != "")
{
if (item.PropertyName != "ProductCode")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
}
else
{
detailwhere = "where " + item.PropertyName + " like '%" + item.Value + "%'";
}
}
}
sql = @"select A.* from SHHG_AimExamine..InWarehouse as A
where A.InWarehouseType !='采购入库' and A.Id in (select distinct InWarehouseId from SHHG_AimExamine..OtherInWarehouseDetail
" + detailwhere + ")" + where;
this.PageState.Add("InWarehouseList", GetPageData(sql, SearchCriterion));
}
private void DoSelect()
{
string where = "";
string detailwhere = "";
string state = RequestData.Get <string>("State");
if (!string.IsNullOrEmpty(state))
{
SearchCriterion.AddSearch("State", state);
}
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate" && item.Value.ToString() != "")
{
where += " and CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value.ToString() != "")
{
where += " and CreateTime<'" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value.ToString() != "")
{
if (item.PropertyName != "ProductCode")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
}
else
{
detailwhere = "where " + item.PropertyName + " like '%" + item.Value + "%'";
}
}
}
string sql = @"select A.*,B.MoneyType,B.Symbo from SHHG_AimExamine..PurchaseInvoice as A
left join (select Id ,MoneyType,Symbo from SHHG_AimExamine..Supplier) as B on A.SupplierId=B.Id
where A.Id in (select PurchaseInvoiceId from SHHG_AimExamine..PurchaseInvoiceDetail " + detailwhere + ") " + where;
this.PageState.Add("PurchaseInvoiceList", GetPageData(sql, SearchCriterion));
}
private void DoSelect()
{
string where = "";
string productType = RequestData.Get <string>("ProductType");
if (!string.IsNullOrEmpty(productType))
{
SearchCriterion.AddSearch("ProductType", productType);
}
string sql = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.Value.ToString() != "")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
}
}
// ((select isnull(sum(isnull(Count,0)-isnull(OutCount,0)),0) from SHHG_AimExamine..DelieryOrderPart t where t.ProductId=A.ProductId and isnull(State,'')<>'已出库')+
//(select isnull(sum(isnull(Count,0)-isnull(OutCount,0)),0) from SHHG_AimExamine..OrdersPart n where n.PId=A.ProductId and n.IsValid=1 and isnull(OutCount,0)<>isnull(Count,0))) as NoOutQuan,
//SHHG_AimExamine.dbo.fun_CaculateBuyPrice(A.ProductId)*(A.StockQuantity)*(select top(1) rate from SHHG_AimExamine..ExchangeRate where Symbo=(select top(1) Symbo from SHHG_AimExamine..Supplier where Id=B.SupplierId)) as StockAmount,
sql = @"select A.*,
(B.BuyPrice)*(A.StockQuantity) as StockAmount,
SHHG_AimExamine.dbo.fun_getProQuantity(A.ProductId) as StockQuan,
((select isnull(sum(t.Quantity),0) from SHHG_AimExamine..PurchaseOrderDetail t where t.ProductId=A.ProductId and t.InWarehouseState='未入库')-
(select isnull(sum(m.Quantity),0) from SHHG_AimExamine..InWareHouseDetailDetail m where m.PurchaseOrderDetailId in
(select Id from SHHG_AimExamine..PurchaseOrderDetail t where t.ProductId=A.ProductId and t.InWarehouseState='未入库'))) as NoInQuan,
((select isnull(sum(isnull(Count,0)-isnull(OutCount,0)),0) from SHHG_AimExamine..DelieryOrderPart t where t.ProductId=A.ProductId and isnull(State,'')<>'已出库')+
(select isnull(sum(isnull(Count,0)-isnull(OutCount,0)),0) from SHHG_AimExamine..OrdersPart n where n.PId=A.ProductId and n.IsValid=1 and isnull(OutCount,0)<>isnull(Count,0))) as NoOutQuan,
SHHG_AimExamine.dbo.fun_CaculateBuyPrice(A.ProductId) as BuyPrice,
B.ProductType,B.MinCount,B.Pcn,B.Isbn,B.Name
from SHHG_AimExamine..StockInfo as A
left join (select Id,Isbn,Pcn,MinCount,ProductType,Name,SupplierId,BuyPrice from SHHG_AimExamine..Products) as B on B.Id=A.ProductId
where 1=1 " + where;
PageState.Add("StockList", GetPageData(sql, SearchCriterion));
PageState.Add("ProductTypeEnum", SysEnumeration.GetEnumDict("ProductType"));
}
private void DoSelect()
{
string where = "";
string productType = RequestData.Get <string>("ProductType");
if (!string.IsNullOrEmpty(productType))
{
SearchCriterion.AddSearch("ProductType", productType);
}
string sql = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate" && item.Value.ToString() != "")
{
where += " and CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value.ToString() != "")
{
where += " and CreateTime<'" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value.ToString() != "")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
}
}
sql = @"select A.Id,A.PurchaseOrderId,C.PurchaseOrderNo,A.BuyPrice,A.Quantity,A.Amount,A.PayState,A.InWarehouseState,
A.InvoiceState,B.ProductType,B.Name,B.Code,B.Pcn,C.PriceType,C.SupplierName,C.CreateName,C.CreateTime,D.Symbo
from (Select Id,PurchaseOrderId,BuyPrice,Quantity,Amount,
PayState,InWarehouseState,InvoiceState,ProductId from SHHG_AimExamine..PurchaseOrderDetail) as A
left join (select Id,Name,Code,ProductType,Isbn,Pcn from SHHG_AimExamine..Products) as B on A.ProductId=B.Id
left join (Select Id,PurchaseOrderNo,PriceType,SupplierId,SupplierName,CreateName,CreateTime from SHHG_AimExamine..PurchaseOrder) as C on A.PurchaseOrderId=C.Id
left join (Select Id,Symbo from SHHG_AimExamine..Supplier) as D on D.Id=C.SupplierId
where 1=1" + where;
PageState.Add("DataList", GetPageData(sql, SearchCriterion));
}
private void DoSelect()
{
if (!SearchCriterion.Orders.Exists(en => en.PropertyName == "CreateTime"))
{
SearchCriterion.Orders.Add(new OrderCriterionItem("CreateTime", false));
}
string state = "未结束";
string temp = RequestData.Get <string>("State");
if (!string.IsNullOrEmpty(temp))
{
state = temp;
}
if (state == "未结束")
{
SearchCriterion.AddSearch("State", "已结束", SearchModeEnum.NotEqual);
}
else
{
SearchCriterion.AddSearch("State", state);
}
ents = StockCheck.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
}
private void DoSelect()
{
string where = "";
string productType = RequestData.Get <string>("ProductType");
if (!string.IsNullOrEmpty(productType))
{
SearchCriterion.AddSearch("ProductType", productType);
}
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (item.PropertyName == "BeginDate1" && item.Value + "" != "")
{
where += " and B.CreateTime>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate1" && item.Value + "" != "")
{
where += " and B.CreateTime<'" + (item.Value + "").Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.PropertyName == "BeginDate" && item.Value + "" != "")
{
where += " and B.EndDate>'" + item.Value + "' ";
}
else if (item.PropertyName == "EndDate" && item.Value + "" != "")
{
where += " and B.EndDate<'" + (item.Value + "").Replace(" 0:00:00", " 23:59:59") + "' ";
}
else if (item.Value + "" != "")
{
where += " and " + item.PropertyName + " like '%" + item.Value + "%' ";
}
}
string userid = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID;
//2017-07-21 新增用户 f54d92c5-6b98-4120-8c5d-9b770125a0e5 沈艳霞
if (userid == "97968039-a657-467b-b735-04dab4a9b60c" || userid == "c7712e33-2b20-463e-8910-8f234cf260ef" || userid == "46c5f4df-f6d1-4b36-96ac-d39d3dd65a5d" || userid == "7580578a-ce30-47ef-9a7e-95ca8ac97df3" || userid == "f54d92c5-6b98-4120-8c5d-9b770125a0e5")
{
where += "";
}
else
{
where += " and B.SalesmanId='" + userid + "'";
}
string sql = @"select A.*,B.Number,B.CName,B.Salesman,B.EndDate,C.ProductType,C.Pcn,C.CostPrice,C.SalePrice as BuyPrice,
(A.SalePrice/
((isnull(C.SalePrice,1))*(select top(1) Rate from SHHG_AimExamine..ExchangeRate where Symbo =(select top(1) Symbo from SHHG_AimExamine..Supplier where Id=C.SupplierId ))))
as ProfitRate,
SHHG_AimExamine.dbo.fun_CaculateCostAmount(A.PId,A.Count,A.SalePrice) as CostAmount,
(select top(1) Rate from SHHG_AimExamine..ExchangeRate where Symbo =(select top(1) Symbo from SHHG_AimExamine..Supplier where Id=C.SupplierId )) as Rate,
B.CreateTime
from (
select OId,PId,PCode,PName,Isbn,sum(count) as Count,max(SalePrice) as SalePrice, sum(Amount) as Amount,max(CustomerOrderNo) as CustomerOrderNo from(
select OId,PId,PCode,PName,Isbn,(Count-isnull(ReturnCount,0)) as Count,SalePrice,Amount,CustomerOrderNo from SHHG_AimExamine..OrdersPart
)t
group by PId,PCode,PName,Isbn,OId,isnull(CustomerOrderNo,'') having sum([Count])>0
) as A
left join SHHG_AimExamine..SaleOrders as B on A.OId=B.Id
left join SHHG_AimExamine..Products as C on C.Id=A.PId
where (B.DeliveryState is null or B.DeliveryState<>'已作废') " + where;
PageState.Add("OrderList", GetPageData(sql, SearchCriterion));
}
private void DoSelect()
{
SearchCriterion.AddSearch("CreateId", UserInfo.UserID);
ents = EmpInsurance.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.AddSearch("UserId", UserInfo.UserID);
ents = UsrHealthyWelfare.FindAll(SearchCriterion);
this.PageState.Add("UsrHealthyWelfareList", ents);
}
protected void Page_Load(object sender, EventArgs e)
{
TypeId = RequestData.Get <string>("TypeId");
if (!String.IsNullOrEmpty(TypeId))
{
ICriterion crit = null;
if (TypeId == "Send")
{
SearchCriterion.AddSearch("SenderId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsSenderDelete", false), Expression.IsNull("IsSenderDelete"));
}
else
{
SearchCriterion.AddSearch("ReceiverId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
}
SearchCriterion.SetOrder("SendTime", false);
ents = SysMessageRule.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", ents);
}
SysMessage ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
ent = this.GetPostedData <SysMessage>();
ent.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
ent = this.GetMergedData <SysMessage>();
ent.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <SysMessage>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> ids = RequestData.GetList <object>("Ids");
if (ids != null && ids.Count > 0)
{
if (RequestActionString == "batchdelete")
{
SysMessage[] tents = SysMessage.FindAll(Expression.In("Id", ids.ToList()));
foreach (SysMessage tent in tents)
{
if (TypeId == "Send")
{
tent.IsSenderDelete = true;
}
else
{
tent.IsReceiverDelete = true;
}
tent.DoDelete();
}
}
}
break;
}
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
if (SearchCriterion.Orders.Count == 0)
{
if (!SearchCriterion.Orders.Exists(en => en.PropertyName == "CreateTime"))
{
SearchCriterion.Orders.Add(new OrderCriterionItem("CreateTime", false));
}
}
string type = "all";
foreach (CommonSearchCriterionItem sear in SearchCriterion.Searches.Searches)
{
if (sear.PropertyName == "Name" && sear.Value + "" != "")
{
type = "Logistic";
}
else if ((sear.PropertyName == "CName" && sear.Value + "" != "") || (sear.PropertyName == "Number" && sear.Value + "" != ""))
{
type = "Order";
}
}
string did = RequestData.Get <string>("did");
if (type == "all" || type == "Logistic" || !string.IsNullOrEmpty(did))
{
//if (!string.IsNullOrEmpty(did))
//{
// SearchCriterion.Searches.Clear();
//}
ents = Logistic.FindAll(SearchCriterion, Expression.Sql(" charindex('" + did + "',DeliveryId)>0 "));
//if (ents.Count == 0 && !string.IsNullOrEmpty(did))
//{
// DeliveryOrder doent = DeliveryOrder.TryFind(did);
// if (doent != null)
// {
// ents = Logistic.FindAll(SearchCriterion, Expression.Eq("CustomerId", doent.CId));
// }
//}
this.PageState.Add("LogisticList", ents);
}
if (type == "all" || type == "Order")
{
string wtype = RequestData.Get <string>("wtype");
ICriterion crit = null;
if (wtype == "1")
{
SearchCriterion.AddSearch("LogisticState", "已填写");
}
else
{
crit = Expression.Or(Expression.Sql(" LogisticState <> '已填写' "), Expression.IsNull("LogisticState"));
}
SearchCriterion.AddSearch("State", "已出库");
DeliveryOrder[] ents2 = DeliveryOrder.FindAll(SearchCriterion, crit);
this.PageState.Add("OrderList", ents2);
SearchCriterion.RemoveSearch("State");
}
}
protected void Page_Load(object sender, EventArgs e)
{
TypeId = RequestData.Get <string>("TypeId");
if (!String.IsNullOrEmpty(TypeId))
{
ICriterion crit = null;
SearchCriterion.SetOrder("SendTime", false);
switch (TypeId)
{
case "ToSend":
SearchCriterion.AddSearch("SenderId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsSenderDelete", false), Expression.IsNull("IsSenderDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNull(SysMessage.Prop_State));
ents = SysMessageRule.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", ents);
break;
case "Send":
SearchCriterion.AddSearch("SenderId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsSenderDelete", false), Expression.IsNull("IsSenderDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNotNull(SysMessage.Prop_State));
ents = SysMessageRule.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", ents);
break;
case "Receive":
crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNull(View_SysMessage.Prop_IsFirstView), Expression.Eq(View_SysMessage.Prop_ReceiveId, this.UserInfo.UserID)
, Expression.IsNull(View_SysMessage.Prop_IsDelete));
View_SysMessage[] mgs = View_SysMessage.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", mgs);
break;
case "ReceiveReaded":
crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNotNull(View_SysMessage.Prop_IsFirstView), Expression.Eq(View_SysMessage.Prop_ReceiveId, this.UserInfo.UserID)
, Expression.IsNull(View_SysMessage.Prop_IsDelete));
View_SysMessage[] mgss = View_SysMessage.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", mgss);
break;
}
}
SysMessage ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
ent = this.GetPostedData <SysMessage>();
ent.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
ent = this.GetMergedData <SysMessage>();
ent.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <SysMessage>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> ids = RequestData.GetList <object>("Ids");
if (ids != null && ids.Count > 0)
{
if (RequestActionString == "batchdelete")
{
if (TypeId == "Send" || TypeId == "ToSend")
{
SysMessage[] tents = SysMessage.FindAll(Expression.In("Id", ids.ToList()));
foreach (SysMessage tent in tents)
{
tent.IsSenderDelete = true;
tent.DoDelete();
}
}
else
{
SysMessage[] tents = SysMessage.FindAll(Expression.In("Id", ids.ToList()));
foreach (SysMessage tent in tents)
{
SysMessageReceive receive = SysMessageReceive.FindAllByProperties("MsgId", tent.Id, "ReceiverId", this.UserInfo.UserID)[0];
receive.IsDelete = "1";
receive.DeleteTime = DateTime.Now;
receive.Save();
}
}
}
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
switch (RequestAction)
{
case RequestActionEnum.Query:
case RequestActionEnum.Read:
case RequestActionEnum.Default:
if (!String.IsNullOrEmpty(id))
{
using (new Castle.ActiveRecord.SessionScope())
{
SearchCriterion.PageSize = 50;
SearchCriterion.AddSearch("AuthID", id);
SearchCriterion.AddSearch("CatalogCode", DynamicPermissionCatalog.SysCatalogEnum.SYS_USER.ToString());
dps = DynamicPermissionRule.FindAll(SearchCriterion);
}
}
break;
case RequestActionEnum.Update:
IList <string> entStrList = RequestData.GetList <string>("data");
using (TransactionScope trans = new TransactionScope())
{
try
{
foreach (string entStr in entStrList)
{
DynamicPermission tent = JsonHelper.GetObject <DynamicPermission>(entStr) as DynamicPermission;
tent.DoUpdate();
}
trans.VoteCommit();
}
catch (Exception ex)
{
trans.VoteRollBack();
throw ex;
}
}
break;
case RequestActionEnum.Custom:
if (RequestActionString == "adduser" || RequestActionString == "deluser")
{
IList <string> userIDs = RequestData.GetList <string>("UserIDs");
if (!String.IsNullOrEmpty(id))
{
using (new SessionScope())
{
if (RequestActionString == "adduser")
{
DynamicAuth dauth = DynamicAuth.Find(id);
DynamicPermission.GrantDAuthToUsers(dauth, userIDs, null, null, UserInfo.UserID, UserInfo.Name);
}
else if (RequestActionString == "deluser")
{
DynamicPermission.RevokeDAuthFromUsers(id, userIDs);
}
}
}
}
break;
}
this.PageState.Add("EntList", dps);
if (!IsAsyncRequest)
{
if (!String.IsNullOrEmpty(id))
{
using (new SessionScope())
{
DynamicAuth da = DynamicAuth.Find(id);
DynamicAuthCatalog dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", da.CatalogCode));
if (dac != null)
{
this.PageState.Add("AllowOperation", dac.GetAllowOperations());
}
}
}
this.PageState.Add("OpDivChar", DynamicOperations.DivChar);
}
}
