/// <summary> /// 保存市政交通扩展信息 /// </summary> /// <param name="ProjectModel">工程模型</param> /// <param name="ItemModel">项目模型</param> /// <param name="Model">备用,可空</param> /// <returns></returns> public bool Add(T_Projects ProjectModel, T_Item ItemModel, object Model = null) { ProjectModel.shrq = System.DateTime.Now.ToString("yyyy.MM.dd"); trafficMDL.ProjectID = ProjectModel.ProjectNO; trafficMDL.ID = Guid.NewGuid().ToString(); return(new T_Traffic_BLL().Add(ProjectModel, ItemModel, trafficMDL, detailList)); }
/// <summary> /// 保存市政路灯扩展信息 /// </summary> /// <param name="ProjectModel">工程模型</param> /// <param name="ItemModel">项目模型</param> /// <param name="Model">备用,可空</param> /// <returns></returns> public bool Add(T_Projects ProjectModel, T_Item ItemModel, object Model = null) { ProjectModel.shrq = DateTime.Now.ToString("yyyy.MM.dd"); RoadLampMDL.ProjectID = ProjectModel.ProjectNO; RoadLampMDL.ID = Guid.NewGuid().ToString(); return(new T_Project_RoadLamp_BLL().Add(ProjectModel, ItemModel, RoadLampMDL)); }
public void setXmlInfo(XmlDocument To_JavaXml, XmlElement engBaseInfo, T_Projects project, XmlElement root = null) { List <T_Model> outList = new List <T_Model>(); outList = ProjectXML_Factory.setXmlInfo(To_JavaXml, project, "queryByProjectNo", engBaseInfo, "Buildding", " and ProjectNo='" + project.ProjectNO + "'"); XmlElement X_temp = null; if (outList != null) { foreach (var item in outList) { XmlNodeList xmlList = engBaseInfo.GetElementsByTagName(item.MappColumn); if (xmlList.Count == 0) { X_temp = To_JavaXml.CreateElement(item.MappColumn); } else { continue; } X_temp.SetAttribute("value", ""); X_temp.SetAttribute("description", item.Description); engBaseInfo.AppendChild(X_temp); } } }
public ActionResult UpdateProject(ProjectModel tproject, string Command) { if (!ModelState.IsValid) { return(PartialView("_EditProject", tproject)); } else { T_Projects Obj = new T_Projects(); Obj.C_ProjectID = tproject.C_ProjectID; Obj.C_ProjectName = tproject.C_ProjectName; Obj.C_ProjectDescription = tproject.C_ProjectDescription; Obj.C_LastModified = DateTime.Now; bool IsSuccess = mobjModel.UpdateProject(Obj); if (IsSuccess) { TempData["OperStatus"] = "Project updated successfully"; ModelState.Clear(); return(RedirectToAction("SearchProject", "ManageProjects")); } } return(PartialView("_EditProject")); }
public void Insert(T_Projects obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_Projects.Insert"; MyISqlMap.Insert(stmtId, obj); }
public void Update(T_Projects obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_Projects.Update"; MyISqlMap.Update(stmtId, obj); }
public T_Projects Find(String projectNO) { String stmtId = "T_Projects.Find"; MDL.T_Projects obj = new T_Projects(); obj.ProjectNO = projectNO; T_Projects result = MyISqlMap.QueryForObject <T_Projects>(stmtId, obj); return(result); }
public void Delete(String projectNO) { if (projectNO == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_Projects.Delete"; T_Projects obj = new T_Projects(); obj.ProjectNO = projectNO; MyISqlMap.Delete(stmtId, obj); }
public bool Update(T_Projects model_Projects, T_Item model_Item, T_Project_Brige model_Brige) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Update(model_Projects, model_Item); if (flag) { this.Update(model_Brige); return(true); } return(false); }
public bool Add(T_Projects model_Projects, T_Item model_Item, T_Project_RoadLamp model_RoadLamp) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Add(model_Projects, model_Item); if (flag) { this.Insert(model_RoadLamp); return(true); } return(false); }
//To add new Project public bool AddProject(T_Projects tproject) { try { entities.T_Projects.Add(tproject); entities.SaveChanges(); return true; } catch (Exception e) { return false; } }
//To add new Project public bool AddProject(T_Projects tproject) { try { entities.T_Projects.Add(tproject); entities.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
//To delete project public bool DeleteProject(int id) { try { T_Projects data = entities.T_Projects.Where(m => m.C_ProjectID == id).FirstOrDefault(); entities.T_Projects.Remove(data); entities.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public void setXmlInfo(XmlDocument To_JavaXml, XmlElement engBaseInfo, T_Projects project, XmlElement root = null) { List <T_Model> outList = new List <T_Model>(); outList = ProjectXML_Factory.setXmlInfo(To_JavaXml, project, "queryByProjectNo", engBaseInfo, "Buildding", " and ProjectNo='" + project.ProjectNO + "'"); if (outList != null) { foreach (var item in outList) { XmlElement X_temp = To_JavaXml.CreateElement(item.MappColumn); X_temp = To_JavaXml.CreateElement(item.MappColumn); X_temp.SetAttribute("value", item.Default); engBaseInfo.AppendChild(X_temp); } } }
public void setXmlInfo(XmlDocument To_JavaXml, XmlElement engBaseInfo, T_Projects project, XmlElement root) { XmlElement trafficInfo = To_JavaXml.CreateElement("TrafficInfo"); engBaseInfo.AppendChild(trafficInfo); List <T_Model> outList = new List <T_Model>(); outList = ProjectXML_Factory.setXmlInfo(To_JavaXml, project, "queryByProjectID", trafficInfo, "Traffic", " where ProjectID='" + project.ProjectNO + "'"); if (outList != null) { foreach (var item in outList) { XmlElement X_temp = To_JavaXml.CreateElement(item.MappColumn); X_temp.SetAttribute("value", ""); X_temp.SetAttribute("description", item.Description); trafficInfo.AppendChild(X_temp); } } //交通明细 T_Traffic traffic = new T_Traffic_BLL().QueryTraffic_ByProjID(project.ProjectNO); if (traffic != null) { IList <T_Traffic_Detail> detailList = new T_Traffic_Detail_BLL().QueryTraffic_ByProjID(traffic.ID); foreach (var detail in detailList) { XmlElement traffic_DetailInfo = To_JavaXml.CreateElement("DetailInfo"); trafficInfo.AppendChild(traffic_DetailInfo); List <T_Model> outList_Detail = new List <T_Model>(); outList_Detail = ProjectXML_Factory.setXmlInfo(To_JavaXml, project, "queryByTrafficID", traffic_DetailInfo, "Traffic_Detail", " where Trafficid='" + traffic.ID + "' and types='" + detail.Types + "'"); if (outList_Detail != null) { foreach (var item in outList_Detail) { XmlElement X_temp = To_JavaXml.CreateElement(item.MappColumn); X_temp.SetAttribute("value", ""); X_temp.SetAttribute("description", item.Description); traffic_DetailInfo.AppendChild(X_temp); } } } } }
public ActionResult CreateProject(ProjectModel tproject, string Command) { T_Projects Obj = new T_Projects(); Obj.C_ProjectName = tproject.C_ProjectName; Obj.C_ProjectDescription = tproject.C_ProjectDescription; Obj.C_LastModified = DateTime.Now; bool IsSuccess = mobjModel.AddProject(Obj); if (IsSuccess) { TempData["OperStatus"] = "Project added successfully"; ModelState.Clear(); return RedirectToAction("SearchProject", "ManageProjects"); } return PartialView("_CreateProject"); }
public bool Update(T_Projects model_Projects, T_Item model_Item, T_Traffic model_Traffic, IList <T_Traffic_Detail> detailMDL) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Update(model_Projects, model_Item); if (flag) { BLL.T_Traffic_Detail_BLL detailBLL = new ERM.BLL.T_Traffic_Detail_BLL(); for (int i = 0; i < detailMDL.Count; i++) { detailBLL.Update(detailMDL[i]); } this.Update(model_Traffic); return(true); } return(false); }
public object GetInfo(string where = "", object objModel = null, int flag = 0) { if (cboStru.Items.Count == 0) { IList <MDL.T_Dict> ds2 = new ERM.BLL.T_Dict_BLL().FindByKeyWord("stru"); cboStru.DisplayMember = "displayname"; cboStru.ValueMember = "valuename"; cboStru.DataSource = ds2; } projectMDL = (new BLL.T_Projects_BLL()).Find(where); if (projectMDL == null) { projectMDL = new T_Projects(); } return(Reflections.Control_Reflection(typeof(T_Projects), projectMDL, this.Controls, "txt|cbo|dtp", flag)); }
public bool Add(T_Projects model_Projects, T_Item model_Item, T_Traffic model_Traffic, IList <T_Traffic_Detail> detailMDL) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Add(model_Projects, model_Item); if (flag) { this.Insert(model_Traffic); BLL.T_Traffic_Detail_BLL detailBLL = new ERM.BLL.T_Traffic_Detail_BLL(); for (int i = 0; i < detailMDL.Count; i++) { detailMDL[i].TrafficID = model_Traffic.ID.ToString(); detailBLL.Add(detailMDL[i]); } return(true); } return(false); }
//To update project details public bool UpdateProject(T_Projects tproject) { try { T_Projects data = entities.T_Projects.Where(m => m.C_ProjectID == tproject.C_ProjectID).FirstOrDefault(); data.C_ProjectID = tproject.C_ProjectID; data.C_ProjectName = tproject.C_ProjectName; data.C_ProjectDescription = tproject.C_ProjectDescription; data.C_LastModified = tproject.C_LastModified; entities.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public void setXmlInfo(XmlDocument To_JavaXml, XmlElement engBaseInfo, T_Projects project, XmlElement root = null) { XmlElement roadLampInfo = To_JavaXml.CreateElement("RoadLampInfo"); engBaseInfo.AppendChild(roadLampInfo); List <T_Model> outList = new List <T_Model>(); outList = ProjectXML_Factory.setXmlInfo(To_JavaXml, project, "queryByProjectID", roadLampInfo, "RoadLamp", " where ProjectID='" + project.ProjectNO + "'"); if (outList != null) { foreach (var item in outList) { XmlElement X_temp = To_JavaXml.CreateElement(item.MappColumn); X_temp.SetAttribute("value", ""); X_temp.SetAttribute("description", item.Description); roadLampInfo.AppendChild(X_temp); } } }
public ActionResult CreateProject(ProjectModel tproject, string Command) { T_Projects Obj = new T_Projects(); Obj.C_ProjectName = tproject.C_ProjectName; Obj.C_ProjectDescription = tproject.C_ProjectDescription; Obj.C_LastModified = DateTime.Now; bool IsSuccess = mobjModel.AddProject(Obj); if (IsSuccess) { TempData["OperStatus"] = "Project added successfully"; ModelState.Clear(); return(RedirectToAction("SearchProject", "ManageProjects")); } return(PartialView("_CreateProject")); }
/// <summary> /// This method will return the /// gridview of the project Summary /// </summary> /// <param name="reg">TProjects model</param> /// <returns>List view</returns> public ActionResult List() { try { var projects = new List <T_Projects>(); T_Projects project; using (ContinuousIntegrationEntities ci = new ContinuousIntegrationEntities()) { //userID is received through querystring var userId = Convert.ToInt32(Session["LoggedUserID"]); var listOfProjects = ci.GetAllProjects(userId); foreach (var item in listOfProjects) //loop to populate Project with list of projects { project = new T_Projects { C_ProjectID = item.C_ProjectID, C_ProjectName = item.C_ProjectName, C_ProjectDescription = item.C_ProjectDescription, C_LastModified = item.C_LastModified }; projects.Add(project); } if (projects.Count == 0) { ViewBag.Msg = "You are not assigned any project."; return(View("ErrorPage")); } return(View(projects)); } } catch (Exception e) { throw new ApplicationException("Error: " + e); } }
/// <summary> /// 设置XML输出信息 /// </summary> /// <param name="To_JavaXml">XML文档</param> /// <param name="project">工程对象</param> /// <param name="sqlID">SQL查询标识</param> /// <param name="xmlInfo">节点XML</param> /// <param name="template">模板名称</param> /// <param name="where">查询条件</param> /// <returns>自定义字段集合</returns> public static List <T_Model> setXmlInfo(XmlDocument To_JavaXml, T_Projects project, string sqlID, XmlElement xmlInfo, string template, string where = "") { XmlDoc doc = new XmlDoc(Application.StartupPath + @"\Common\XMLTemplate\" + template + ".xml"); XmlNodeList nodeList = doc.GetNodeList("root"); XmlNodeList columList = null; XmlNodeList sqlList = null; List <T_Model> modelList = new List <T_Model>(); List <T_Model> resultList = new List <T_Model>(); string sql = string.Empty; #region XML节点 for (int i = 0; i < nodeList.Count; i++) { switch (nodeList[i].Name.ToLower()) { case "columns": columList = nodeList[i].ChildNodes; break; case "selects": sqlList = nodeList[i].ChildNodes; break; } } #endregion #region 模板字段 if (columList != null) { modelList.Clear(); resultList.Clear(); T_Model model = null; for (int i = 0; i < columList.Count; i++) { XmlNode node = columList[i]; XmlAttributeCollection attrCollection = node.Attributes; if (attrCollection == null) { continue; } model = new T_Model(); for (int j = 0; j < attrCollection.Count; j++) { switch (attrCollection[j].Name) { case "column": model.Column = attrCollection[j].Value; break; case "mappColumn": model.MappColumn = attrCollection[j].Value; break; case "display": model.Display = attrCollection[j].Value; break; case "description": model.Description = attrCollection[j].Value; break; case "type": model.Type = attrCollection[j].Value; break; case "default": model.Default = attrCollection[j].Value; break; } } if (model.Display == "1") { modelList.Add(model); } if (model.Type == "1") { resultList.Add(model); } } } #endregion #region 射字段 if (sqlList.Count > 0) { for (int j = 0; j < sqlList.Count; j++) { XmlAttributeCollection attrColl = sqlList[j].Attributes; if (attrColl["id"].Value.ToString() == sqlID) { sql = sqlList[j].InnerText.Trim(); #region 参数处理 //switch (attrColl["parameterClass"].Value.ToLower()) //{ // case "string": // sql = sql.Replace("#value#", "'" + project.ProjectNO + "'"); // break; // case "int": // sql = sql.Replace("#value#", project.ProjectNO); // break; // default: // dynamic d = attrColl["parameterClass"].Value; // sql = sql.Replace("#value#", project.ProjectNO); // break; //} #endregion #region 输出XML try { DataSet ds = ERM.DAL.MyBatis.QueueyForSql(sql + " " + where); if (ds.Tables.Count > 0) { for (int m = 0; m < ds.Tables[0].Rows.Count; m++) { for (int k = 0; k < modelList.Count; k++) { for (int n = 0; n < ds.Tables[0].Columns.Count; n++) { if (modelList[k].Column.ToString().ToLower() == ds.Tables[0].Columns[n].ColumnName.ToString().ToLower()) { XmlElement X_temp = To_JavaXml.CreateElement(modelList[k].MappColumn); if (!string.IsNullOrEmpty(ds.Tables[0].Rows[m][n].ToString())) { X_temp.SetAttribute("value", ds.Tables[0].Rows[m][n].ToString()); } else { X_temp.SetAttribute("value", modelList[k].Default); } xmlInfo.AppendChild(X_temp); } } } } } } catch (Exception ex) { TX.Framework.WindowUI.Forms.TXMessageBoxExtensions.Info(ex.Message.ToString()); } break; #endregion } } } return(resultList); #endregion }
/// <summary> /// 根据配置模板动态导出XML /// </summary> /// <param name="To_JavaXml">XML文档对象</param> /// <param name="project">工程对象</param> /// <param name="tableName">查询表名</param> /// <param name="xmlInfo">XML节点</param> /// <param name="template">XML模板名</param> /// <param name="outList">非数据库取值字段列表,在具体实现类处理</param> public static void setXmlInfo(XmlDocument To_JavaXml, T_Projects project, string tableName, XmlElement xmlInfo, string template, out List <T_Model> outList, string where) { XmlDoc doc = new XmlDoc(Application.StartupPath + @"\Common\XMLTemplate\" + template + ".xml"); XmlNodeList nodeList = doc.GetNodeList("root"); XmlNodeList childList = null; outList = new List <T_Model>(); for (int i = 0; i < nodeList.Count; i++) { if (nodeList[i].Name.ToLower() == "columns") { childList = nodeList[i].ChildNodes; break; } } if (childList != null) { T_Model model = null; string sql = string.Empty; List <T_Model> columnList = new List <T_Model>(); for (int i = 0; i < childList.Count; i++) { XmlNode node = childList[i]; XmlAttributeCollection attrCollection = node.Attributes; if (attrCollection == null) { continue; } model = new T_Model(); for (int j = 0; j < attrCollection.Count; j++) { switch (attrCollection[j].Name) { case "column": model.Column = attrCollection[j].Value; break; case "mappColumn": model.MappColumn = attrCollection[j].Value; break; case "display": model.Display = attrCollection[j].Value; break; case "description": model.Description = attrCollection[j].Value; break; case "type": model.Type = attrCollection[j].Value; break; } } if (model.Display == "1") { if (model.Type == "0") { sql += "[" + model.Column + "],"; columnList.Add(model); } else { outList.Add(model); } } } if (sql.Length > 0) { sql = "select " + sql.TrimEnd(',') + " from " + tableName + " where " + where; DataSet ds = ERM.DAL.MyBatis.QueueyForSql(sql); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { XmlElement X_temp = To_JavaXml.CreateElement(columnList[j].MappColumn); X_temp.SetAttribute("value", dt.Rows[i][j].ToString()); X_temp.SetAttribute("description", columnList[j].Description); xmlInfo.AppendChild(X_temp); } } } } } }
//To update project details public bool UpdateProject(T_Projects tproject) { try { T_Projects data = entities.T_Projects.Where(m => m.C_ProjectID == tproject.C_ProjectID).FirstOrDefault(); data.C_ProjectID = tproject.C_ProjectID; data.C_ProjectName = tproject.C_ProjectName; data.C_ProjectDescription = tproject.C_ProjectDescription; data.C_LastModified = tproject.C_LastModified; entities.SaveChanges(); return true; } catch (Exception e) { return false; } }
/// <summary> /// 构建原文XML /// </summary> /// <param name="obj"></param> /// <param name="xDoc"></param> /// <param name="PElement"></param> private void GetEFileXE(T_CellAndEFile obj, XmlDocument xDoc, XmlElement PElement, string filePath, string fileName, string orerIndex, T_Projects project) { //YW_CellAndEFile file = new YW_CellAndEFile(fileName, filePath, obj, orerIndex); //file.setXmlInfo(xDoc, PElement, project); }
public ActionResult UpdateProject(ProjectModel tproject, string Command) { if (!ModelState.IsValid) { return PartialView("_EditProject", tproject); } else { T_Projects Obj = new T_Projects(); Obj.C_ProjectID = tproject.C_ProjectID; Obj.C_ProjectName = tproject.C_ProjectName; Obj.C_ProjectDescription = tproject.C_ProjectDescription; Obj.C_LastModified = DateTime.Now; bool IsSuccess = mobjModel.UpdateProject(Obj); if (IsSuccess) { TempData["OperStatus"] = "Project updated successfully"; ModelState.Clear(); return RedirectToAction("SearchProject", "ManageProjects"); } } return PartialView("_EditProject"); }
/// <summary> /// 更新路灯扩展信息和明细 /// </summary> /// <param name="ProjectModel">工程模型</param> /// <param name="ItemModel">项目模型</param> /// <param name="Model">备用,可空</param> /// <returns></returns> public bool Updates(T_Projects ProjectModel, T_Item ItemModel = null, object Model = null) { return(new T_Project_RoadLamp_BLL().Update(ProjectModel, ItemModel, RoadLampMDL)); }
/// <summary> /// This method will return the /// gridview of the project Summary /// </summary> /// <param name="reg">TProjects model</param> /// <returns>List view</returns> public ActionResult List() { try { var projects = new List<T_Projects>(); T_Projects project; using (ContinuousIntegrationEntities ci = new ContinuousIntegrationEntities()) { //userID is received through querystring var userId = Convert.ToInt32(Session["LoggedUserID"]); var listOfProjects = ci.GetAllProjects(userId); foreach (var item in listOfProjects) //loop to populate Project with list of projects { project = new T_Projects { C_ProjectID = item.C_ProjectID, C_ProjectName = item.C_ProjectName, C_ProjectDescription = item.C_ProjectDescription, C_LastModified = item.C_LastModified }; projects.Add(project); } if (projects.Count == 0) { ViewBag.Msg = "You are not assigned any project."; return View("ErrorPage"); } return View(projects); } } catch (Exception e) { throw new ApplicationException("Error: " + e); } }
public bool Add(T_Projects ProjectModel, T_Item ItemModel, object Model = null) { ProjectModel.shrq = DateTime.Now.ToString("yyyy.MM.dd"); return(new ERM.BLL.T_Projects_BLL().Add(ProjectModel, ItemModel)); }
/// <summary> /// 更新交通扩展信息和明细 /// </summary> /// <param name="ProjectModel">工程模型</param> /// <param name="ItemModel">项目模型</param> /// <param name="Model">备用,可空</param> /// <returns></returns> public bool Updates(T_Projects ProjectModel, T_Item ItemModel = null, object Model = null) { return(new T_Traffic_BLL().Update(ProjectModel, ItemModel, trafficMDL, detailList)); }
public bool Updates(T_Projects ProjectModel, T_Item ItemModel = null, object Model = null) { return(new ERM.BLL.T_Projects_BLL().Update(ProjectModel, ItemModel)); }
/// <summary> /// 更新桥梁扩展信息和明细 /// </summary> /// <param name="ProjectModel">工程模型</param> /// <param name="ItemModel">项目模型</param> /// <param name="Model">备用,可空</param> /// <returns></returns> public bool Updates(T_Projects ProjectModel, T_Item ItemModel = null, object Model = null) { return(new T_Project_Brige_BLL().Update(ProjectModel, ItemModel, brigeMDL)); }