/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <DC_REPOSITORY_Model> getModelList(DC_REPOSITORY_SW sw) { var result = new List <DC_REPOSITORY_Model>(); DataTable dt = BaseDT.DC_REPOSITORY.getDT(sw);//列表 DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); for (int i = 0; i < dt.Rows.Count; i++) { DC_REPOSITORY_Model m = new DC_REPOSITORY_Model(); m.DCREPOSITORYID = dt.Rows[i]["DCREPOSITORYID"].ToString(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); //string orgname = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.COMNAME = "[" + m.ORGName + "]" + m.NAME + ""; //m.COMNAME = "[" + orgname + "]" + m.NAME + ""; m.RESPONSIBLEMAN = dt.Rows[i]["RESPONSIBLEMAN"].ToString(); m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString(); m.REPTYPEID = dt.Rows[i]["REPTYPEID"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(result); }
/// <summary> /// 添加 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Add(DC_REPOSITORY_Model m) { if (DC_ARMY.isExistsPoint(new DC_ARMY_Model { JD = m.JD, WD = m.WD }) == false) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO DC_REPOSITORY( NAME,ADDRESS,BYORGNO,RESPONSIBLEMAN,LINKWAY,REPTYPEID,JD,WD ) output inserted.DCREPOSITORYID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0},", ClsSql.saveNullField(m.NAME)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.RESPONSIBLEMAN)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.LINKWAY)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.REPTYPEID)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.JD)); sb.AppendFormat("{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(")"); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); return(new Message(true, "添加成功!", strid)); } catch (Exception) { throw; } } else { return(new Message(false, "添加失败,已有相同的位置的仓库!", "")); } }
/// <summary> /// 单条记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DC_REPOSITORY_Model getModel(DC_REPOSITORY_SW sw) { DataTable dt = BaseDT.DC_REPOSITORY.getDT(sw);//列表 DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); DC_REPOSITORY_Model m = new DC_REPOSITORY_Model(); if (dt.Rows.Count > 0) { int i = 0; m.DCREPOSITORYID = dt.Rows[i]["DCREPOSITORYID"].ToString(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.RESPONSIBLEMAN = dt.Rows[i]["RESPONSIBLEMAN"].ToString(); m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString(); m.REPTYPEID = dt.Rows[i]["REPTYPEID"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 修改 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Mdy(DC_REPOSITORY_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE DC_REPOSITORY"); sb.AppendFormat(" set "); sb.AppendFormat("NAME={0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",ADDRESS={0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",RESPONSIBLEMAN={0}", ClsSql.saveNullField(m.RESPONSIBLEMAN)); sb.AppendFormat(",LINKWAY={0}", ClsSql.saveNullField(m.LINKWAY)); sb.AppendFormat(",REPTYPEID={0}", ClsSql.saveNullField(m.REPTYPEID)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(" where DCREPOSITORYID= '{0}'", ClsSql.EncodeSql(m.DCREPOSITORYID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.DCREPOSITORYID)); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 仓库id获取仓库名称仓库组织机构码 /// </summary> /// <param name="dpid"></param> /// <returns></returns> public static string getdepOrg(string dpid) { DC_REPOSITORY_Model m = getModel(new DC_REPOSITORY_SW { DCREPOSITORYID = dpid }); return(m.BYORGNO); }
/// <summary> /// 仓库id获取仓库名称仓库负责人 /// </summary> /// <param name="dpid"></param> /// <returns></returns> public static string getdepotman(string dpid) { DC_REPOSITORY_Model m = getModel(new DC_REPOSITORY_SW { DCREPOSITORYID = dpid }); return(m.RESPONSIBLEMAN); }
/// <summary> /// 仓库id获取仓库名称 /// </summary> /// <param name="dpid"></param> /// <returns></returns> public static string getdepotname(string dpid) { DC_REPOSITORY_Model m = getModel(new DC_REPOSITORY_SW { DCREPOSITORYID = dpid }); return(m.NAME); }
/// <summary> /// 判断是否相同坐标 /// </summary> /// <param name="m"></param> /// <returns></returns> public static bool isExistsPoint(DC_REPOSITORY_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from DC_REPOSITORY where 1=1"); if (string.IsNullOrEmpty(m.JD) == false && string.IsNullOrEmpty(m.WD) == false) { sb.AppendFormat(" and JD='{0}'", ClsSql.EncodeSql(m.JD)); } sb.AppendFormat(" and WD='{0}'", ClsSql.EncodeSql(m.WD)); return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(DC_REPOSITORY_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete DC_REPOSITORY"); sb.AppendFormat(" where DCREPOSITORYID= '{0}'", ClsSql.EncodeSql(m.DCREPOSITORYID)); 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_REPOSITORY_Model m) { if (m.opMethod == "Add") { Message msgUser = BaseDT.DC_REPOSITORY.Add(m); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } if (m.opMethod == "Mdy") { Message msgUser = BaseDT.DC_REPOSITORY.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } if (m.opMethod == "Del") { Message msgUser = BaseDT.DC_REPOSITORY.Del(m); return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } return(new Message(false, "无效操作", "")); }