/// <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));
}
