/// <summary>
/// 获取数据
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(DC_FULLTIMEUSER_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from DC_FULLTIMEUSER a ");
sb.AppendFormat("where 1=1");
if (string.IsNullOrEmpty(sw.DC_FULLTIMEUSERID) == false)
{
sb.AppendFormat("and DC_FULLTIMEUSERID = '{0}'", ClsSql.EncodeSql(sw.DC_FULLTIMEUSERID));
}
if (string.IsNullOrEmpty(sw.BYORGNO) == false)
{
sb.AppendFormat("and BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO));
}
if (string.IsNullOrEmpty(sw.FTNAME) == false)
{
sb.AppendFormat("and FTNAME = '{0}'", ClsSql.EncodeSql(sw.FTNAME));
}
if (string.IsNullOrEmpty(sw.BIRTH) == false)
{
sb.AppendFormat("and BIRTH = '{0}'", ClsSql.EncodeSql(sw.BIRTH));
}
if (string.IsNullOrEmpty(sw.SEX) == false)
{
sb.AppendFormat("and SEX = '{0}'", ClsSql.EncodeSql(sw.SEX));
}
if (string.IsNullOrEmpty(sw.NATION) == false)
{
sb.AppendFormat("and NATION = '{0}'", ClsSql.EncodeSql(sw.NATION));
}
if (string.IsNullOrEmpty(sw.USERJOB) == false)
{
sb.AppendFormat("and USERJOB = '{0}'", ClsSql.EncodeSql(sw.USERJOB));
}
if (string.IsNullOrEmpty(sw.LINKWAY) == false)
{
sb.AppendFormat("and LINKWAY = '{0}'", ClsSql.EncodeSql(sw.LINKWAY));
}
if (string.IsNullOrEmpty(sw.PHOTO) == false)
{
sb.AppendFormat("and PHOTO = '{0}'", ClsSql.EncodeSql(sw.PHOTO));
}
if (string.IsNullOrEmpty(sw.ORDERBY) == false)
{
sb.AppendFormat("and ORDERBY = '{0}'", ClsSql.EncodeSql(sw.ORDERBY));
}
string sql = ("select DC_FULLTIMEUSERID,BYORGNO,FTNAME,BIRTH,SEX,NATION,USERJOB,LINKWAY,PHOTO,ORDERBY") + sb.ToString() + ("order by DC_FULLTIMEUSERID ");
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
//#region 专职人员树形菜单
//public static JArray getFULLTIMEUSERTree()
//{
// JArray jObjects = new JArray();
// DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() });
// DataTable dtUser = BaseDT.DC_FULLTIMEUSER.getDT(new DC_FULLTIMEUSER_SW { });
// DataRow[] drOrg = dtOrg.Select("", "ORGNO");
// if (drOrg.Length > 0)
// {
// JObject root = new JObject
// {
// {"id",""},//ORGNO
// {"text",drOrg[0]["ORGNAME"].ToString()}
// };
// root.Add("children", getFULLTIMEUSERChild(dtOrg, dtUser, drOrg[0]["ORGNO"].ToString()));
// jObjects.Add(root);
// }
// return jObjects;
//}
//public static JArray getFULLTIMEUSERChild(DataTable dtOrg, DataTable dtUser, string orgNo)
//{
// JArray childArray = new JArray();
// if (orgNo.Substring(4, 5) == "00000")//获取所有市下属的人员和县
// {
// DataRow[] drUser = dtUser.Select("BYORGNO = '" + orgNo + "'", "");
// for (int i = 0; i < drUser.Length; i++)
// {
// JObject root = new JObject
// {
// {"id",drUser[i]["DC_FULLTIMEUSERID"].ToString()} ,
// {"text",drUser[i]["FTNAME"].ToString()}
// };
// childArray.Add(root);
// }
// DataRow[] drOrg = dtOrg.Select("SUBSTRING(ORGNO,1,4) = '" + orgNo.Substring(0, 4) + "' AND ORGNO<>'" + orgNo + "' and SUBSTRING(ORGNO,7,3)='000'", "");//获取所有县且〈〉市的
// for (int i = 0; i < drOrg.Length; i++)
// {
// JObject root = new JObject
// {
// {"id",""},//ORGNO
// {"text",drOrg[i]["ORGNAME"].ToString()}
// };
// root.Add("children", getFULLTIMEUSERChild(dtOrg, dtUser, drOrg[i]["ORGNO"].ToString()));//继续获取镇
// childArray.Add(root);
// }
// return childArray;
// }
// else if (orgNo.Substring(6, 3) == "000")//获取所有县的人员
// {
// DataRow[] drUser = dtUser.Select("BYORGNO = '" + orgNo + "'", "");
// for (int i = 0; i < drUser.Length; i++)
// {
// JObject root = new JObject
// {
// {"id",drUser[i]["DC_FULLTIMEUSERID"].ToString()} ,
// {"text",drUser[i]["FTNAME"].ToString()}
// };
// childArray.Add(root);
// }
// return childArray;
// }
// return childArray;
//}
//#endregion
#region 获取单条专职人员
/// <summary>
/// 单条专职人员
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DC_FULLTIMEUSER_Model getModel(DC_FULLTIMEUSER_SW sw)
{
DataTable dt = BaseDT.DC_FULLTIMEUSER.getDT(sw);
DC_FULLTIMEUSER_Model m = new DC_FULLTIMEUSER_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DC_FULLTIMEUSERID = dt.Rows[i]["DC_FULLTIMEUSERID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FTNAME = dt.Rows[i]["FTNAME"].ToString();
m.BIRTH = dt.Rows[i]["BIRTH"].ToString();
m.SEX = dt.Rows[i]["SEX"].ToString();
m.NATION = dt.Rows[i]["NATION"].ToString();
m.USERJOB = dt.Rows[i]["USERJOB"].ToString();
m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString();
m.PHOTO = dt.Rows[i]["PHOTO"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
}
dt.Dispose();
dt.Clear();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <DC_FULLTIMEUSER_Model> getListModel(DC_FULLTIMEUSER_SW sw)
{
DataTable dt = BaseDT.DC_FULLTIMEUSER.getDT(sw);
var result = new List <DC_FULLTIMEUSER_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_FULLTIMEUSER_Model m = new DC_FULLTIMEUSER_Model();
m.DC_FULLTIMEUSERID = dt.Rows[i]["DC_FULLTIMEUSERID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FTNAME = dt.Rows[i]["FTNAME"].ToString();
m.BIRTH = dt.Rows[i]["BIRTH"].ToString();
m.SEX = dt.Rows[i]["SEX"].ToString();
m.NATION = dt.Rows[i]["NATION"].ToString();
m.USERJOB = dt.Rows[i]["USERJOB"].ToString();
m.PHOTO = dt.Rows[i]["PHOTO"].ToString();
m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
