/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYS_ORG_LINK_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE T_SYS_ORG_LINK"); sb.AppendFormat(" set "); sb.AppendFormat("BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",ORGLINKTYPE='{0}'", ClsSql.EncodeSql(m.ORGLINKTYPE)); sb.AppendFormat(",UNITNAME='{0}'", ClsSql.EncodeSql(m.UNITNAME)); sb.AppendFormat(",NAME='{0}'", ClsSql.EncodeSql(m.NAME)); sb.AppendFormat(",USERJOB='{0}'", ClsSql.EncodeSql(m.USERJOB)); sb.AppendFormat(",PHONE='{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",Tell='{0}'", ClsSql.EncodeSql(m.Tell)); sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(" where ORGLINK_ID= '{0}'", ClsSql.EncodeSql(m.ORGLINK_ID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYS_ORG_LINK_Model m) { if (isExists(new T_SYS_ORG_LINK_SW { PHONE = m.PHONE, BYORGNO = m.BYORGNO, ORGLINKTYPE = m.ORGLINKTYPE, ORDERBY = m.ORDERBY }) == true) { return(new Message(false, "添加失败,已重复!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYS_ORG_LINK( BYORGNO, ORGLINKTYPE,UNITNAME, NAME, USERJOB, PHONE, Tell, ORDERBY)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORGLINKTYPE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.UNITNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.NAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERJOB)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.Tell)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(T_SYS_ORG_LINK_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete T_SYS_ORG_LINK"); sb.AppendFormat(" where ORGLINK_ID= '{0}'", ClsSql.EncodeSql(m.ORGLINK_ID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYS_ORG_LINK_Model m) { if (m.opMethod == "Add") { Message msgUser = BaseDT.T_SYS_ORG_LINK.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { Message msgUser = BaseDT.T_SYS_ORG_LINK.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { Message msgUser = BaseDT.T_SYS_ORG_LINK.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作!", "")); }
/// <summary> /// 根据组织机构获取短信发送tree字符串 /// </summary> /// <param name="phonelist"></param> /// <param name="name"></param> /// <returns></returns> public static SendMessage_Model getOrgno(string phonelist, string name) { var s = ""; DataTable dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { PHONE = phonelist, keys = name }); //列表 DataTable dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { PHONELIST = phonelist, HNAME = name }); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); s += m.BYORGNO + "|" + "1" + ","; } } if (dtipuser.Rows.Count > 0) { for (int i = 0; i < dtipuser.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.BYORGNO = dtipuser.Rows[i]["BYORGNO"].ToString(); s += m.BYORGNO + "|" + "2" + ","; } } s = s.TrimEnd(','); SendMessage_Model m1 = new SendMessage_Model(); m1.BYORGNOLIST = s; dt.Clear(); dt.Dispose(); dtipuser.Clear(); dtipuser.Dispose(); return(m1); }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_SYS_ORG_LINK_Model getModel(T_SYS_ORG_LINK_SW sw) { var result = new List <T_SYS_ORG_LINK_Model>(); DataTable dt = BaseDT.T_SYS_ORG_LINK.getDT(sw);//列表 DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 DataTable dt45 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "45" }); //组织机构联系人类型 T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); if (dt.Rows.Count > 0) { int i = 0; m.ORGLINK_ID = dt.Rows[i]["ORGLINK_ID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGLINKTYPE = dt.Rows[i]["ORGLINKTYPE"].ToString(); m.ORGLINKTYPEName = BaseDT.T_SYS_DICT.getName(dt45, m.ORGLINKTYPE); m.UNITNAME = dt.Rows[i]["UNITNAME"].ToString(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.USERJOB = dt.Rows[i]["USERJOB"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.Tell = dt.Rows[i]["Tell"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); dt45.Clear(); dt45.Dispose(); return(m); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message CWHUploadAdd(OrgMapUpload_Model m) { //第一步,根据县名称和乡名称获取单位编码 string orgNo = BaseDT.T_SYS_ORG.getOrgNoByXianNameAndZhenName(m.县名称, m.乡镇名称); if (string.IsNullOrEmpty(orgNo)) { return(new Message(false, "没有找到该乡镇", "")); } //第二步,判断村委会是否存在于表中,通过获取村委会ID来判断 string cwhID = ""; if (1 == 1) { DataTable dt = BaseDT.T_SYS_ORG_CWH.getDT(new T_SYS_ORG_CWH_SW { CWHNAME = m.村委会名称, BYORGNO = orgNo }); if (dt.Rows.Count > 0) { cwhID = dt.Rows[0]["CWHID"].ToString(); } if (string.IsNullOrEmpty(cwhID)) {//没有找到村委会,先插入 该村委会 T_SYS_ORG_CWH_Model mCWH = new T_SYS_ORG_CWH_Model(); mCWH.BYORGNO = orgNo; mCWH.CWHNAME = m.村委会名称; mCWH.ORDERBY = m.排序号; mCWH.opMethod = "Add"; Manager(mCWH); } dt.Clear(); dt.Dispose(); } if (string.IsNullOrEmpty(cwhID))//如果是新添加的,重新获取村委会ID { DataTable dt = BaseDT.T_SYS_ORG_CWH.getDT(new T_SYS_ORG_CWH_SW { CWHNAME = m.村委会名称, BYORGNO = orgNo }); if (dt.Rows.Count > 0) { cwhID = dt.Rows[0]["CWHID"].ToString(); } dt.Clear(); dt.Dispose(); } if (string.IsNullOrEmpty(cwhID)) { return(new Message(false, "未找到该村委会", "")); } //第三步,插入到联系人表中 T_SYS_ORG_LINK_Model ml = new T_SYS_ORG_LINK_Model(); ml.BYORGNO = cwhID; if (string.IsNullOrEmpty(m.自然村名称))//村委会成员 { ml.ORGLINKTYPE = "1"; } else { ml.ORGLINKTYPE = "2";//小组长 } ml.UNITNAME = m.自然村名称; ml.NAME = m.联系人; ml.USERJOB = m.职位; ml.PHONE = m.手机; ml.Tell = m.电话; ml.ORDERBY = m.排序号; ml.opMethod = "Add"; return(T_SYS_ORG_LINKCls.Manager(ml)); //if(bln) //return new Message(false, "无效操作", ""); }
/// <summary> /// 根据组织机构获取短信发送tree字符串 /// </summary> /// <param name="orgno"></param> /// <param name="type"></param> /// <returns></returns> public static SendMessage_Model getstr(string orgno, string type) { var s = ""; var d = ""; var dt = new DataTable(); var dtvillage = new DataTable(); var dtipuser = new DataTable(); if (orgno == "1") { dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { BYORGNO = SystemCls.getCurUserOrgNo() }); //列表 } else if (orgno == "2") { dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = SystemCls.getCurUserOrgNo() }); } else { if (PublicCls.OrgIsShi(orgno) == false && PublicCls.OrgIsXian(orgno) == false && PublicCls.OrgIsZhen(orgno) == false) { dtvillage = BaseDT.T_SYS_ORG_CWH.getVillagecComDT(new T_SYS_ORG_CWH_SW { CWHID = orgno }); } else { dtvillage = BaseDT.T_SYS_ORG_CWH.getVillagecComDT(new T_SYS_ORG_CWH_SW { BYORGNO = orgno }); dt = BaseDT.T_SYS_ORG_LINK.getDT(new T_SYS_ORG_LINK_SW { BYORGNO = orgno }); //列表 dtipuser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = orgno }); } } if (type == "1") { if (PublicCls.OrgIsShi(orgno) == false && PublicCls.OrgIsXian(orgno) == false && PublicCls.OrgIsZhen(orgno) == false) { for (int i = 0; i < dtvillage.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtvillage.Rows[i]["NAME"].ToString(); m.PHONE = dtvillage.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } else { for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } for (int i = 0; i < dtvillage.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtvillage.Rows[i]["NAME"].ToString(); m.PHONE = dtvillage.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } } if (type == "2") { for (int i = 0; i < dtipuser.Rows.Count; i++) { T_SYS_ORG_LINK_Model m = new T_SYS_ORG_LINK_Model(); m.NAME = dtipuser.Rows[i]["HNAME"].ToString(); m.PHONE = dtipuser.Rows[i]["PHONE"].ToString(); s += m.NAME + ","; d += m.PHONE + ","; } } s = s.TrimEnd(','); d = d.TrimEnd(','); SendMessage_Model m1 = new SendMessage_Model(); m1.PHONELIST = d; m1.NAMELIST = s; dt.Clear(); dt.Dispose(); dtvillage.Clear(); dtvillage.Dispose(); dtipuser.Clear(); dtipuser.Dispose(); return(m1); }