/// <summary>
/// 获取费用分配数据底层调用
/// </summary>
/// <param name="CurrorPage"></param>
/// <param name="PageSize"></param>
/// <param name="Total"></param>
/// <param name="sortStr"></param>
/// <param name="condition"></param>
/// <param name="DataID"></param>
/// <returns></returns>
public static DataTable FindByPage(int CurrorPage, int PageSize, out int Total, string sortStr, Cost_PerCondition condition, string DataID = null)
{
SqlParameter[] sqlParas = new SqlParameter[] {
new SqlParameter("@SourceID ", SqlDbType.VarChar, 100)
, new SqlParameter("@LangType", SqlDbType.VarChar, 20)
, new SqlParameter("@Sect_RID", SqlDbType.VarChar, 50)
, new SqlParameter("@Emp_No", SqlDbType.VarChar, 10)
, new SqlParameter("@Effect_Date", SqlDbType.VarChar, 20)
, new SqlParameter("@Effect_Date_To", SqlDbType.VarChar, 20)
, new SqlParameter("@CursorPage", SqlDbType.Int)
, new SqlParameter("@PageSize", SqlDbType.Int)
, new SqlParameter("@SortStr", SqlDbType.NVarChar, 200)
, new SqlParameter("@DataID", SqlDbType.VarChar, 50)
, new SqlParameter("@CheckDate", SqlDbType.VarChar, 20)
, new SqlParameter("@ActiveVal", SqlDbType.VarChar, 10)
};
sqlParas[0].Value = "getPagerData";
sqlParas[1].Value = "CN"; // LangType;
sqlParas[2].Value = condition.Sect_RID_Value; // this.SelectTree.GetItem("value");
sqlParas[3].Value = condition.Emp_No;
sqlParas[4].Value = condition.Effect_DateFrom;
sqlParas[5].Value = condition.Effect_DateTo;
sqlParas[6].Value = CurrorPage;
sqlParas[7].Value = PageSize;
sqlParas[8].Value = sortStr;
sqlParas[9].Value = DataID;
sqlParas[10].Value = condition.CheckDate;
sqlParas[11].Value = condition.ActiveVal;
DataSet ds = SQlHelper.ExecuteToDataSet("p_HRIS424SearchData", CommandType.StoredProcedure, sqlParas);
DataTable dt = ds.Tables[1];
Total = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(dt);
}
/// <summary>
/// 从工号得到组织架构和职位
/// </summary>
/// <param name="httpContext"></param>
/// <returns></returns>
public static string GetorganizationLevelEmp_No(HttpContext httpContext)
{
String keyword = httpContext.Request["keyword"];
string sJSON2 = String.Empty;
SqlParameter[] sqlParas = new SqlParameter[] {
new SqlParameter("@SourceID", SqlDbType.VarChar, 100)
, new SqlParameter("@LangType", SqlDbType.VarChar, 20)
, new SqlParameter("@Keyword", SqlDbType.NVarChar, 200)
, new SqlParameter("@Keyword1", SqlDbType.NVarChar, 200)
, new SqlParameter("@Keyword2", SqlDbType.NVarChar, 200)
, new SqlParameter("@Keyword3", SqlDbType.NVarChar, 200)
, new SqlParameter("@Keyword4", SqlDbType.NVarChar, 200)
, new SqlParameter("@Keyword5", SqlDbType.NVarChar, 200)
};
sqlParas[0].Value = "GetorganizationLevelEmp_No";
sqlParas[1].Value = httpContext.Session["LangType"] ?? "";
sqlParas[2].Value = keyword;
DataSet dt = SQlHelper.ExecuteToDataSet("p_HRIS424ControlDataSource", CommandType.StoredProcedure, sqlParas);
sJSON2 = JsonConvert.SerializeObject(dt.Tables[0]);
return(sJSON2);
}