/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <DC_ARMY_EQUIP_Model> getModelList(DC_ARMY_EQUIP_SW sw) { var result = new List <DC_ARMY_EQUIP_Model>(); DataTable dt = BaseDT.DC_ARMY_EQUIP.getDT(sw);//列表 DataTable dt36 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "36" }); //使用现状 for (int i = 0; i < dt.Rows.Count; i++) { DC_ARMY_EQUIP_Model m = new DC_ARMY_EQUIP_Model(); m.DC_ARMY_EQUIP_ID = dt.Rows[i]["DC_ARMY_EQUIP_ID"].ToString(); m.DC_ARMY_ID = dt.Rows[i]["DC_ARMY_ID"].ToString(); m.EQUIPNAME = dt.Rows[i]["EQUIPNAME"].ToString(); m.EQUIPNUM = dt.Rows[i]["EQUIPNUM"].ToString(); m.EQUIPMODEL = dt.Rows[i]["EQUIPMODEL"].ToString(); m.EQUIPUSESTATE = dt.Rows[i]["EQUIPUSESTATE"].ToString(); m.EQUIPUSESTATEName = BaseDT.T_SYS_DICT.getName(dt36, m.EQUIPUSESTATE); m.EQUIPSUM = dt.Rows[i]["EQUIPSUM"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(DC_ARMY_EQUIP_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE DC_ARMY_EQUIP"); sb.AppendFormat(" set "); sb.AppendFormat("DC_ARMY_ID={0}", ClsSql.saveNullField(m.DC_ARMY_ID)); sb.AppendFormat(",EQUIPNAME={0}", ClsSql.saveNullField(m.EQUIPNAME)); sb.AppendFormat(",EQUIPNUM={0}", ClsSql.saveNullField(m.EQUIPNUM)); sb.AppendFormat(",EQUIPMODEL={0}", ClsSql.saveNullField(m.EQUIPMODEL)); sb.AppendFormat(",EQUIPUSESTATE={0}", ClsSql.saveNullField(m.EQUIPUSESTATE)); sb.AppendFormat(",EQUIPSUM={0}", ClsSql.saveNullField(m.EQUIPSUM)); sb.AppendFormat(" where DC_ARMY_EQUIP_ID= '{0}'", ClsSql.EncodeSql(m.DC_ARMY_EQUIP_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 Del(DC_ARMY_EQUIP_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete DC_ARMY_EQUIP"); sb.AppendFormat(" where DC_ARMY_EQUIP_ID= '{0}'", ClsSql.EncodeSql(m.DC_ARMY_EQUIP_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(DC_ARMY_EQUIP_Model m) { if (m.opMethod == "Add") { //SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.DC_ARMY_EQUIP.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_ARMY_EQUIP.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_ARMY_EQUIP.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(DC_ARMY_EQUIP_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO DC_ARMY_EQUIP( DC_ARMY_ID, EQUIPNAME, EQUIPNUM, EQUIPMODEL, EQUIPUSESTATE,EQUIPSUM)"); sb.AppendFormat("VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.DC_ARMY_ID)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.EQUIPNAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.EQUIPNUM)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.EQUIPMODEL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.EQUIPUSESTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.EQUIPSUM)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }