/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(DC_TYPE_Model m) { if (m.DCTYPETOPID == "0") { return(new Message(false, "操作失败,顶级类别 禁止操作!", "")); } if (DataBaseClass.JudgeRecordExists("select DCTYPEID from DC_TYPE where DCTYPETOPID=" + m.DCTYPEID + "") == true) { return(new Message(false, "删除失败,请先删除子类别!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete DC_TYPE"); sb.AppendFormat(" where DCTYPEID= '{0}'", ClsSql.EncodeSql(m.DCTYPEID)); 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 Mdy(DC_TYPE_Model m) { if (m.DCTYPETOPID == "0") { return(new Message(false, "操作失败,顶级类别 禁止操作!", "")); } StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE DC_TYPE"); sb.AppendFormat(" set "); sb.AppendFormat("DCTYPETOPID='{0}'", ClsSql.EncodeSql(m.DCTYPETOPID)); sb.AppendFormat(",DCTYPENAME='{0}'", ClsSql.EncodeSql(m.DCTYPENAME)); sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(",DCTYPEFLAG='{0}'", ClsSql.EncodeSql(m.DCTYPEFLAG)); sb.AppendFormat(" where DCTYPEID= '{0}'", ClsSql.EncodeSql(m.DCTYPEID)); 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(DC_TYPE_Model m) { if (m.DCTYPETOPID == "0") { return(new Message(false, "操作失败,顶级类别 禁止操作!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO DC_TYPE( DCTYPETOPID, DCTYPENAME, ORDERBY, DCTYPEFLAG)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.DCTYPETOPID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DCTYPENAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DCTYPEFLAG)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 根据物资id获取物资名称 /// </summary> /// <param name="dctypeid">物资id</param> /// <returns></returns> public static string getSupname(string dctypeid) { DC_TYPE_Model m = getModel(new DC_TYPE_SW { DCTYPEID = dctypeid }); return(m.DCTYPENAME); }
/// <summary> /// 根据查询条件获取某一条信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DC_TYPE_Model getModel(DC_TYPE_SW sw) { DataTable dt = BaseDT.DC_TYPE.getDT(sw);//列表 DC_TYPE_Model m = new DC_TYPE_Model(); if (dt.Rows.Count > 0) { int i = 0; m.DCTYPEID = dt.Rows[i]["DCTYPEID"].ToString(); m.DCTYPETOPID = dt.Rows[i]["DCTYPETOPID"].ToString(); m.DCTYPENAME = dt.Rows[i]["DCTYPENAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); m.DCTYPEFLAG = dt.Rows[i]["DCTYPEFLAG"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取文档列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <DC_TYPE_Model> getModelList(DC_TYPE_SW sw) { var result = new List <DC_TYPE_Model>(); DataTable dt = BaseDT.DC_TYPE.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { DC_TYPE_Model m = new DC_TYPE_Model(); m.DCTYPEID = dt.Rows[i]["DCTYPEID"].ToString(); m.DCTYPETOPID = dt.Rows[i]["DCTYPETOPID"].ToString(); m.DCTYPENAME = dt.Rows[i]["DCTYPENAME"].ToString(); m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString(); m.DCTYPEFLAG = dt.Rows[i]["DCTYPEFLAG"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(DC_TYPE_Model m) { if (m.opMethod == "Add") { //SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.DC_TYPE.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { //SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.DC_TYPE.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { //SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.DC_TYPE.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }