/// <summary> /// 获取一条数据 /// </summary> /// <returns></returns> public static IEnumerable <OD_ODTYPE_Model> GetOneData() { //var result = new List<O_ODUSER_Model>(); //var dt = BaseDT.O_OD_USER.GetModelList(od); //for (int i = 0; i < dt.Rows.Count; i++) //{ // O_ODUSER_Model ood = new O_ODUSER_Model(); // ood.BYORGNO = BaseDT.T_SYS_ORG.getName(dt, dt.Rows[i]["ORGNO"].ToString()); // ood.ONDUTYUSERTYPE = dt.Rows[i]["ONDUTYUSERTYPE"].ToString(); // ood.USERNAME = dt.Rows[i]["username"].ToString(); // ood.ISATTENDED = dt.Rows[i]["ISATTENDED"].ToString(); // ood.ONDUTYDATE = ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString()); // result.Add(ood); //} //dt.Clear(); //dt.Dispose(); //return result; var result = new List <OD_ODTYPE_Model>(); var dt = BaseDT.OD_TYPE.GetOneData(); for (int i = 0; i < dt.Rows.Count; i++) { OD_ODTYPE_Model om = new OD_ODTYPE_Model(); om.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString(); om.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString(); om.OD_DATEBEGIN = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEBEGIN"].ToString()); om.OD_DATEEND = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEEND"].ToString()); result.Add(om); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取火险等级模型列表 /// </summary> /// <returns></returns> private IEnumerable <YJJCFireLevelModel> GetModelList() { var result = new List <YJJCFireLevelModel>(); var list = YJ_DANGERCLASSCls.getListModelTop(new YJ_DANGERCLASS_SW() { }); if (list.Any()) { foreach (var item in list.OrderByDescending(p => p.DANGERCLASS)) { var model = new YJJCFireLevelModel(); if (!string.IsNullOrEmpty(item.TOPTOWNNAME)) { model.AreaName = item.TOPTOWNNAME + "==>"; } model.AreaName += item.TOWNNAME; //区域 model.FireLevel = item.DANGERCLASS; //等级 model.LevelDate = ClsSwitch.SwitDate(item.DCDATE); //等级时间; model.SourceForm = "人工导入"; result.Add(model); } } return(result); }
/// <summary> /// 获取值班人的userID /// </summary> /// <param name="ondutyTime">日期</param> /// <param name="byorgon">组织机构编码(多个以,号分开)</param> /// <returns></returns> public static DataTable GetOndutyUserid(string ondutyTime, string byorgon) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select ou.DUTYUSERID from DUTY_USER as ou where 1=1"); if (!string.IsNullOrEmpty(ondutyTime)) { sb.AppendFormat(" and ou.DUTYDATE='{0}'", ClsSwitch.SwitDate(ondutyTime)); } if (!string.IsNullOrEmpty(byorgon)) { sb.AppendFormat(" and ou.BYORGNO in({0})", ClsSql.EncodeSql(byorgon)); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 获取列表分页 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static IEnumerable <DC_DETAILS_Model> getModelPager(DC_DETAILS_SW sw, out int total) { var result = new List <DC_DETAILS_Model>(); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); DataTable dt = BaseDT.DC_DETAILS.getDT(sw, out total);//列表 for (int i = 0; i < dt.Rows.Count; i++) { DC_DETAILS_Model m = new DC_DETAILS_Model(); m.DCDETAILSID = dt.Rows[i]["DCDETAILSID"].ToString(); m.SUPID = dt.Rows[i]["SUPID"].ToString(); m.SUPNAME = DC_SUPPLIESPROPCls.getsupname(m.SUPID); m.DCSUPPROPMODEL = BaseDT.DC_SUPPLIESPROP.getmodel(new DC_SUPPLIESPROP_SW { DC_SUPPLIESPROP_ID = m.SUPID }); m.DCSUPPROPUNIT = BaseDT.DC_SUPPLIESPROP.getunit(new DC_SUPPLIESPROP_SW { DC_SUPPLIESPROP_ID = m.SUPID }); m.REPID = dt.Rows[i]["REPID"].ToString(); m.DPNAME = DC_REPOSITORYCls.getdepotname(m.REPID); m.DCREPTIME = ClsSwitch.SwitDate(dt.Rows[i]["DCREPTIME"].ToString());; m.DCREPFLAG = dt.Rows[i]["DCREPFLAG"].ToString(); m.DCREPSUPCOUNT = dt.Rows[i]["DCREPSUPCOUNT"].ToString(); m.DCENTYMANID = dt.Rows[i]["DCENTYMANID"].ToString(); m.DCUSERID = dt.Rows[i]["DCUSERID"].ToString(); m.DCCUSTODIANID = dt.Rows[i]["DCCUSTODIANID"].ToString(); m.DCUSERORG = dt.Rows[i]["DCUSERORG"].ToString(); m.PRICE = dt.Rows[i]["PRICE"].ToString(); m.MARK = dt.Rows[i]["MARK"].ToString(); m.REPERTORYCOUNT = dt.Rows[i]["REPERTORYCOUNT"].ToString(); m.DCFAFANGREN = dt.Rows[i]["DCFAFANGREN"].ToString(); m.DCZHIBIAOREN = dt.Rows[i]["DCZHIBIAOREN"].ToString(); //m.DCENTYMANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCENTYMANID); //m.DCUSERNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCUSERID); //m.DCCUSTODIANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCCUSTODIANID); m.NUMBER = dt.Rows[i]["NUMBER"].ToString(); m.SUM = (float.Parse(m.DCREPSUPCOUNT) * float.Parse(m.PRICE)).ToString("F2"); result.Add(m); } dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); return(result); }
public string GetFireLevelHtml(YJ_DANGERCLASS_SW sw) { StringBuilder sb = new StringBuilder(); sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" >"); sb.Append(" <thead>"); sb.Append("<tr><th>区域</th><th>等级</th><th>时间</th></tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); var list = new List <YJ_DANGERCLASS_Model>(); if (string.IsNullOrEmpty(sw.DCDATE)) { list = YJ_DANGERCLASSCls.getListModelTop(new YJ_DANGERCLASS_SW() { }).ToList(); if (!string.IsNullOrEmpty(sw.DANGERCLASS) && sw.DANGERCLASS != "0") { list = list.Where(p => p.DANGERCLASS == sw.DANGERCLASS).ToList(); } } else { list = YJ_DANGERCLASSCls.getListModel(sw).ToList(); } if (list.Any()) { foreach (var item in list) { sb.Append("<tr>"); sb.AppendFormat("<td class=\"center\">{0}</td>", item.TOPTOWNNAME + "==>" + item.TOWNNAME); sb.AppendFormat("<td class=\"center\">{0}</td>", item.DANGERCLASS); sb.AppendFormat("<td class=\"center\">{0}</td>", ClsSwitch.SwitDate(item.DCDATE)); sb.Append("</tr>"); } } else { sb.Append("<tr>"); sb.Append("<td colspan=\"3\"><em>暂未查询到记录!</em></td>"); sb.Append("</tr>"); } sb.Append("</tbody>"); sb.Append("</table>"); return(sb.ToString()); }
/// <summary> /// 火险等级 List转为Datable /// </summary> /// <param name="tasks"></param> /// <returns></returns> private DataTable ConvertToDataTableLevelList(List <YJ_DANGERCLASS_Model> tasks) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ContyName")); dt.Columns.Add(new DataColumn("Level")); dt.Columns.Add(new DataColumn("LevelDate")); foreach (var task in tasks) { var dr = dt.NewRow(); dr["ContyName"] = task.TOWNNAME; dr["Level"] = task.DANGERCLASS; dr["LevelDate"] = ClsSwitch.SwitDate(task.DCDATE); dt.Rows.Add(dr); } tasks.Clear(); return(dt); }
/// <summary> /// 获取数据集合 /// </summary> /// <param name="o"></param> /// <returns></returns> public static IEnumerable <OD_ODTYPE_Model> GetModelList(OD_ODTYPE_Model o) { var result = new List <OD_ODTYPE_Model>(); var dt = BaseDT.OD_TYPE.GetModelList(o); for (int i = 0; i < dt.Rows.Count; i++) { OD_ODTYPE_Model om = new OD_ODTYPE_Model(); om.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString(); om.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString(); om.OD_DATEBEGIN = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEBEGIN"].ToString()); om.OD_DATEEND = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEEND"].ToString()); result.Add(om); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据查询条件获取某一条信息记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DC_DETAILS_Model getModel(DC_DETAILS_SW sw) { DataTable dt = BaseDT.DC_DETAILS.getDT(sw);//列表 DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); DC_DETAILS_Model m = new DC_DETAILS_Model(); if (dt.Rows.Count > 0) { int i = 0; m.DCDETAILSID = dt.Rows[i]["DCDETAILSID"].ToString(); m.SUPID = dt.Rows[i]["SUPID"].ToString(); m.SUPNAME = DC_SUPPLIESPROPCls.getsupname(m.SUPID); //获取物资的名称 m.REPID = dt.Rows[i]["REPID"].ToString(); m.DPNAME = DC_REPOSITORYCls.getdepotname(m.REPID); //获取仓库的名称 m.DCSUPPROPMODEL = BaseDT.DC_SUPPLIESPROP.getmodel(new DC_SUPPLIESPROP_SW { DC_SUPPLIESPROP_ID = m.SUPID }); //获取物资的型号 m.DCSUPPROPUNIT = BaseDT.DC_SUPPLIESPROP.getunit(new DC_SUPPLIESPROP_SW { DC_SUPPLIESPROP_ID = m.SUPID }); //获取物资的单位 m.RESPONSIBLEMAN = DC_REPOSITORYCls.getdepotman(m.REPID); //获取仓库负责人 m.DCREPTIME = ClsSwitch.SwitDate(dt.Rows[i]["DCREPTIME"].ToString());; m.DCREPFLAG = dt.Rows[i]["DCREPFLAG"].ToString(); m.DCREPSUPCOUNT = dt.Rows[i]["DCREPSUPCOUNT"].ToString(); m.DCENTYMANID = dt.Rows[i]["DCENTYMANID"].ToString(); m.DCUSERID = dt.Rows[i]["DCUSERID"].ToString(); m.DCCUSTODIANID = dt.Rows[i]["DCCUSTODIANID"].ToString(); m.DCUSERORG = dt.Rows[i]["DCUSERORG"].ToString(); m.PRICE = dt.Rows[i]["PRICE"].ToString(); m.MARK = dt.Rows[i]["MARK"].ToString(); m.REPERTORYCOUNT = dt.Rows[i]["REPERTORYCOUNT"].ToString(); m.DCFAFANGREN = dt.Rows[i]["DCFAFANGREN"].ToString(); m.DCZHIBIAOREN = dt.Rows[i]["DCZHIBIAOREN"].ToString(); m.NUMBER = dt.Rows[i]["NUMBER"].ToString(); //m.DCENTYMANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCENTYMANID); //m.DCUSERNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCUSERID); //m.DCCUSTODIANNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DCCUSTODIANID); m.SUM = (float.Parse(m.DCREPSUPCOUNT) * float.Parse(m.PRICE)).ToString("F2");//金额 } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取数据模型 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_HARMCLASS_Model getModel(PEST_HARMCLASS_SW sw) { PEST_HARMCLASS_Model m = new PEST_HARMCLASS_Model(); DataTable dt = BaseDT.PEST_HARMCLASS.getDT(sw); if (dt.Rows.Count > 0) { int i = 0; m.PEST_HARMCLASSID = dt.Rows[i]["PEST_HARMCLASSID"].ToString(); m.DCDATE = ClsSwitch.SwitDate(dt.Rows[i]["DCDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.HARMCLASS = dt.Rows[i]["HARMCLASS"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <PEST_HARMCLASS_Model> getListModel(PEST_HARMCLASS_SW sw) { var result = new List <PEST_HARMCLASS_Model>(); DataTable dt = BaseDT.PEST_HARMCLASS.getDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { PEST_HARMCLASS_Model m = new PEST_HARMCLASS_Model(); m.PEST_HARMCLASSID = dt.Rows[i]["PEST_HARMCLASSID"].ToString(); m.DCDATE = ClsSwitch.SwitDate(dt.Rows[i]["DCDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.HARMCLASS = dt.Rows[i]["HARMCLASS"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="o">对象</param> /// <returns></returns> public static Message Mdy(OD_ODTYPE_Model o) { if (string.IsNullOrEmpty(o.OD_TYPEID)) { return(new Message(false, "修改ID不能为空", "")); } //增加判断该值班日期是否已存在 StringBuilder sbExits = new StringBuilder(); sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo()); sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND); sbExits.AppendFormat("and OD_TYPEID<>'{0}'", o.OD_TYPEID); if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true) { return(new Message(false, "重新生成失败,在该值班日期范围内已存在历史值班日期!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("update OD_TYPE set"); sb.AppendFormat(" OD_TYPENAME='{0}',", ClsSql.EncodeSql(o.OD_TYPENAME)); sb.AppendFormat("OD_DATEBEGIN='{0}',", ClsSwitch.SwitDate(o.OD_DATEBEGIN)); sb.AppendFormat("OD_DATEEND='{0}'", ClsSwitch.SwitDate(o.OD_DATEEND)); if (!string.IsNullOrEmpty(o.OD_TYPEID)) { sb.AppendFormat(" where OD_TYPEID={0}", ClsSql.EncodeSql(o.OD_TYPEID)); } bool b = DataBaseClass.ExeSql(sb.ToString()); if (b) { return(new Message(true, "修改成功", o.OD_TYPEID)); } else { return(new Message(false, "修改失败", "")); } }
/// <summary> /// 获取数据库中最新的一条火险等级记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getTopDT(YJ_DANGERCLASS_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT top 1 DANGERID, DCDATE, BYORGNO, TOWNNAME, JD, WD, DANGERCLASS, TOPTOWNNAME, WEATHER, TEMPREATURE, WINDYSPEED"); sb.AppendFormat(" FROM YJ_DANGERCLASS Where 1=1 "); if (!string.IsNullOrEmpty(sw.BYORGNO)) { sb.AppendFormat(" And BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (!string.IsNullOrEmpty(sw.DANGERCLASS) && sw.DANGERCLASS != "0") { sb.AppendFormat(" And DANGERCLASS='{0}'", ClsSql.EncodeSql(sw.DANGERCLASS)); } if (!string.IsNullOrEmpty(sw.DCDATE)) { sb.AppendFormat(" And convert(char(10), DCDATE,120)='{0}'", ClsSwitch.SwitDate(sw.DCDATE)); } string sql = sb.ToString() + " order by DCDATE DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }