/// <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);
}
