/// <summary> /// 根据操作员和申报单位取预算部门 /// </summary> /// <param name="Usercoode"></param> /// <param name="Unit"></param> /// <returns></returns> public IList <OrganizeModel> GetDept(string Usercoode, string Unit) { Dictionary <string, object> dic_Corr = new Dictionary <string, object>(); new CreateCriteria(dic_Corr) .Add(ORMRestrictions <String> .Eq("Dwdm", Usercoode)) .Add(ORMRestrictions <String> .Eq("Dylx", "97")) .Add(ORMRestrictions <String> .LLike("Dydm", Unit)); IList <CorrespondenceSettingsModel> correspondenceSettings = CorrespondenceSettingsRule.Find(dic_Corr); List <string> ocodeList = new List <string>(); if (correspondenceSettings.Count > 0) { for (var i = 0; i < correspondenceSettings.Count; i++) { if (!ocodeList.Contains(correspondenceSettings[i].Dydm)) { ocodeList.Add(correspondenceSettings[i].Dydm); } } } Dictionary <string, object> dic_org = new Dictionary <string, object>(); new CreateCriteria(dic_org) .Add(ORMRestrictions <String> .Eq("IfCorp", "N")) .Add(ORMRestrictions <String> .Eq("IsActive", "1")) .Add(ORMRestrictions <List <String> > .In("OCode", ocodeList)); IList <OrganizeModel> organizes = OrganizationRule.Find(dic_org); return(organizes); }
/* * /// <summary> * /// 获取实际发生数 * /// </summary> * /// <param name="userID"></param> * /// <param name="expenseMsts"></param> * /// <returns></returns> * public PagedResult<ExpenseMstModel> GetSJFSS (string userID, PagedResult<ExpenseMstModel> expenseMsts) * { * string FDeclarationUnit=""; * var dicWhereUnit = new Dictionary<string, object>(); * new CreateCriteria(dicWhereUnit).Add(ORMRestrictions<string>.Eq("Dylx", "08")) * .Add(ORMRestrictions<Int32>.Eq("DefInt1", 1)).Add(ORMRestrictions<string>.Eq("Dwdm", userID)); * var CorrespondenceSettings = CorrespondenceSettingsRule.Find(dicWhereUnit); * if (CorrespondenceSettings.Count > 0) * { * FDeclarationUnit = CorrespondenceSettings[0].Dydm; * } * * DateTime? beforeDate = new DateTime(DateTime.Now.Year, 1, 1); //账务筛选时间 * var dicWheredate = new Dictionary<string, object>(); * new CreateCriteria(dicWheredate).Add(ORMRestrictions<string>.Eq("BZ", "G6HBLKZExpense")); * var setModels = QTControlSetRule.Find(dicWheredate);//QTControlSetModel * if (setModels.Count > 0) * { * beforeDate = setModels[0].BEGINFDATE; * } * * string userConn=""; * string select_DM; * string Date_Dm; * Dictionary<string, object> conndic = new Dictionary<string, object>(); * new CreateCriteria(conndic) * .Add(ORMRestrictions<string>.Eq("Dylx", "config")) * .Add(ORMRestrictions<string>.Eq("DefStr1", FDeclarationUnit)); * IList<CorrespondenceSettings2Model> CorrespondenceSettings2s = CorrespondenceSettings2Rule.RuleHelper.Find(conndic); * if (CorrespondenceSettings2s.Count > 0 && CorrespondenceSettings2s[0].DefStr2 != null) * { * userConn = CorrespondenceSettings2s[0].DefStr2; * } * if (userConn.IndexOf("ConnectType=SqlClient", StringComparison.OrdinalIgnoreCase) < 0) * { * select_DM = @"SELECT sum(nvl(j,0))-sum(nvl(d,0)) FROM v_zw_pzhz WHERE zxyt= "; * Date_Dm = " and PZRQ < to_date('" + Convert.ToDateTime(beforeDate).ToString("yyyy-MM-dd") + "', 'yyyy/mm/dd hh24:mi:ss')"; * } * else * { * select_DM = @"SELECT sum(isnull(j,0))-sum(isnull(d,0)) FROM v_zw_pzhz WHERE zxyt= "; * Date_Dm = " and PZRQ < '" + Convert.ToDateTime(beforeDate).ToString("yyyy-MM-dd") + "'"; * } * DataTable dataTable = null; * DbHelper.Open(userConn); * for (var i = 0; i < expenseMsts.Results.Count; i++) * { * dataTable = DbHelper.GetDataTable(userConn, select_DM+"'"+ expenseMsts.Results[i].FProjcode+"'" + Date_Dm); * if (dataTable.Rows.Count != 0) * { * expenseMsts.Results[i].FDeclarationDept = dataTable.Rows[0][0].ToString(); * } * } * DbHelper.Close(userConn); * return expenseMsts; * }*/ /// <summary> /// 通过项目代码和操作员获取财务实际发生数 /// </summary> /// <param name="userID"></param> /// <param name="code"></param> /// <returns></returns> public string GetSJFSSbyCode(string userID, string code) { var result = ""; string FDeclarationUnit = ""; var dicWhereUnit = new Dictionary <string, object>(); new CreateCriteria(dicWhereUnit).Add(ORMRestrictions <string> .Eq("Dylx", "08")) .Add(ORMRestrictions <Int32> .Eq("DefInt1", 1)).Add(ORMRestrictions <string> .Eq("Dwdm", userID)); var CorrespondenceSettings = CorrespondenceSettingsRule.Find(dicWhereUnit); if (CorrespondenceSettings.Count > 0) { FDeclarationUnit = CorrespondenceSettings[0].Dydm; } DateTime?beforeDate = new DateTime(DateTime.Now.Year, 1, 1); //账务筛选时间 var dicWheredate = new Dictionary <string, object>(); new CreateCriteria(dicWheredate).Add(ORMRestrictions <string> .Eq("BZ", "G6HBLKZExpense")); var setModels = QTControlSetRule.Find(dicWheredate);//QTControlSetModel if (setModels.Count > 0) { beforeDate = setModels[0].BEGINFDATE; } string userConn = ""; string select_DM; string Date_Dm; Dictionary <string, object> conndic = new Dictionary <string, object>(); new CreateCriteria(conndic) .Add(ORMRestrictions <string> .Eq("Dylx", "config")) .Add(ORMRestrictions <string> .Eq("DefStr1", FDeclarationUnit)); IList <CorrespondenceSettings2Model> CorrespondenceSettings2s = CorrespondenceSettings2Rule.RuleHelper.Find(conndic); if (CorrespondenceSettings2s.Count > 0 && CorrespondenceSettings2s[0].DefStr2 != null) { userConn = CorrespondenceSettings2s[0].DefStr2; if (userConn.IndexOf("ConnectType=SqlClient", StringComparison.OrdinalIgnoreCase) < 0) { select_DM = @"SELECT sum(nvl(j,0))-sum(nvl(d,0)) FROM v_zw_pzhz WHERE zxyt= "; Date_Dm = " and PZRQ < to_date('" + Convert.ToDateTime(beforeDate).ToString("yyyy-MM-dd") + "', 'yyyy/mm/dd hh24:mi:ss')"; } else { select_DM = @"SELECT sum(isnull(j,0))-sum(isnull(d,0)) FROM v_zw_pzhz WHERE zxyt= "; Date_Dm = " and PZRQ < '" + Convert.ToDateTime(beforeDate).ToString("yyyy-MM-dd") + "'"; } DataTable dataTable = null; DbHelper.Open(userConn); dataTable = DbHelper.GetDataTable(userConn, select_DM + "'" + code + "'" + Date_Dm); if (dataTable.Rows.Count != 0) { result = dataTable.Rows[0][0].ToString(); } DbHelper.Close(userConn); } else { return("0.00"); } return(result); }