public SYS_BUSINESSROLE GetBusinessRole(int RoleID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_BUSINESSROLE>("where ID=" + RoleID)); } }
public ORUP_ORGANIZATION GetOrganization(int OrgID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <ORUP_ORGANIZATION>("where ID=" + OrgID)); } }
public SYS_BUSINESSDATADETAIL BusinessDataDetail(int BusinessDataID, int MetaDataID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_BUSINESSDATADETAIL>("where REF_BUSINESSDATA_ID=" + BusinessDataID + " and REF_METADATA_ID=" + MetaDataID)); } }
public SYS_BUSINESSFORM GetBusinessForm(int FormID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_BUSINESSFORM>("where ID=" + FormID)); } }
public SYS_METADATA MetaData(int MetaDataID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_METADATA>("where ID=" + MetaDataID)); } }
public SYS_SYSTEMCONFIG GetConfig(int ConfigId) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_SYSTEMCONFIG>("where ID=" + ConfigId)); } }
public SYS_BUSINESSMATERIAL GetBusinessMaterial(int MaterialID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_BUSINESSMATERIAL>("where ID=" + MaterialID)); } }
public SYS_BUSINESS Business(int BusinessID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <SYS_BUSINESS>("where ID=" + BusinessID)); } }
public ORUP_ROLE GetRole(int RoleID) { using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { return(orm.Init <ORUP_ROLE>("where ID=" + RoleID)); } }
public List <SYS_MESSAGE> GetReadMsgs(string UserId) { List <SYS_MESSAGE> result = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { result = orm.Query <SYS_MESSAGE>("where STATE=1 and RECVUSERID='" + UserId + "'"); foreach (SYS_MESSAGE msg in result) { ORUP_USER sendUser = orm.Init <ORUP_USER>("where ID=" + msg.SENDUSERID); msg.SENDUSERNAME = sendUser.USERNAME; msg.SENDUSERIMG = sendUser.USERIMG; msg.PROJECTNAME = orm.Init <SYS_PROJECT>("where ID=" + msg.REF_PROJECT_ID).PROJECTNAME; msg.RECVUSERNAME = orm.Init <ORUP_USER>("where ID=" + msg.RECVUSERID).USERNAME; } } return(result); }
public ORUP_USER GetUser(string username, string password) { ORUP_USER user = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { user = orm.Init <ORUP_USER>("where USERNAME='******' and password='******'"); } return(user); }
public ORUP_USER GetUser(int userId) { ORUP_USER user = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { user = orm.Init <ORUP_USER>("where ID=" + userId); } return(user); }
public SYS_BUSINESSDATA BusinessData(int BusinessDataID) { SYS_BUSINESSDATA result = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { result = orm.Init <SYS_BUSINESSDATA>("where ID=" + BusinessDataID); } return(result); }
public ORUP_USER modifyPassword(string userId, string password) { ORUP_USER user = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { user = orm.Init <ORUP_USER>("where ID='" + userId + "'"); user.PASSWORD = password; orm.Save(user); } return(user); }
public SYS_BUSINESSDATA EditBusinessData(int Id, string Name, string Description) { SYS_BUSINESSDATA result = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { result = orm.Init <SYS_BUSINESSDATA>("where ID=" + Id); result.NAME = Name; result.DESCRIPTION = Description; orm.Update(result); } return(result); }
public List <SYS_MESSAGE> ReadMsg(string MsgId) { SYS_MESSAGE msg = null; List <SYS_MESSAGE> result = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { msg = orm.Init <SYS_MESSAGE>("where ID=" + MsgId); msg.STATE = 1; orm.Save(msg); result = GetNoReadMsgs(msg.RECVUSERID + ""); } return(result); }
public ActionResult DoLogin(LoginViewModel model, string returnUrl) { ORUP_USER user = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { user = orm.Init <ORUP_USER>("where USERNAME='******' and PASSWORD='******'"); if (null != user) { Session["UserId"] = user.ID + ""; Session["UserName"] = user.USERNAME + ""; return(View("Index")); } else { return(View("Login")); } } }
public ORUP_USER modifyUserInfo(string userId, string name, string value) { ORUP_USER user = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { user = orm.Init <ORUP_USER>("where ID='" + userId + "'"); if (name == "MOBILE") { user.MOBILE = value; } if (name == "PHONE") { user.PHONE = value; } if (name == "EMAIL") { user.EMAIL = value; } orm.Save(user); } return(user); }
public ActionResult BuildForm(int ProjectFormId) { SYS_PROJECTFORM prjForm = null; SYS_BUSINESSFORM businessForm = null; using (ORMHandler orm = Zxl.Data.DatabaseManager.ORMHandler) { prjForm = orm.Init <SYS_PROJECTFORM>("where ID=" + ProjectFormId); businessForm = orm.Init <SYS_BUSINESSFORM>("where ID=" + prjForm.REF_BUSINESSFORM_ID); } StringBuilder result = new StringBuilder(); string content = System.Text.Encoding.Default.GetString(businessForm.CONTENT); XmlDocument doc = new XmlDocument(); doc.LoadXml(content); XmlNode controlNode = doc.SelectNodes("Form/Control").Item(0); string formWidth = controlNode.Attributes["width"].Value; string formHeight = controlNode.Attributes["height"].Value; result.Append("<div id='form-" + ProjectFormId + "' style='position:relative; margin:0 auto;margin-top:20px;margin-bottom:20px; width:" + (Convert.ToInt32(formWidth) + 200) + "px; height:" + (Convert.ToInt32(formHeight) + 250) + "px;background:white;'>"); #region Controls foreach (XmlNode node in controlNode.ChildNodes) { string NodeType = node.Name; string id = node.Attributes["id"].Value; string name = node.Attributes["name"].Value; string x = node.Attributes["x"].Value; string y = node.Attributes["y"].Value; string width = node.Attributes["width"].Value; string height = node.Attributes["height"].Value; string readonlyT = node.Attributes["readonly"].Value; string isprint = node.Attributes["isprint"].Value; string text = null; if (null != node.Attributes["text"]) { text = node.Attributes["text"].Value; } string temp = ""; switch (NodeType) { case "Label": temp = "<span id='" + id + "' style='position: absolute;left:" + x + "px;top:" + y + "px;width:" + width + "px;height:" + height + "px' >" + text + "</span>"; break; case "TextBox": temp = "<input type='text' id='" + id + "' style='position: absolute;left:" + x + "px;top:" + y + "px;width:" + width + "px;height:" + height + "px' />"; break; case "ComboBox": temp = "<select id='" + id + "' style='position: absolute;left:" + x + "px;top:" + y + "px;width:" + width + "px;height:" + height + "px' >" + "</select>"; break; case "RadioButtonList": temp = "<input type='radio' id='" + id + "' style='position: absolute;left:" + x + "px;top:" + y + "px;width:" + width + "px;height:" + height + "px' />"; break; default: break; } result.Append(temp); } #endregion Controls #region Sheet XmlNode sheetReportNode = doc.SelectNodes("Form/SheetReport/Layout").Item(0); SheetReport sheetReport = new SheetReport(); sheetReport.Orientation = sheetReportNode.Attributes["Orientation"].Value; sheetReport.PaperWidthWithTwipsUnit = sheetReportNode.Attributes["PaperWidthWithTwipsUnit"].Value; sheetReport.PaperHeightWithTwipsUnit = sheetReportNode.Attributes["PaperHeightWithTwipsUnit"].Value; sheetReport.BottomMargin = sheetReportNode.Attributes["BottomMargin"].Value; sheetReport.LeftMargin = sheetReportNode.Attributes["LeftMargin"].Value; sheetReport.RightMargin = sheetReportNode.Attributes["RightMargin"].Value; sheetReport.TopMargin = sheetReportNode.Attributes["TopMargin"].Value; XmlNodeList sheetPageNodes = sheetReportNode.SelectNodes("SheetPageNode/SheetPage"); sheetReport.SheetPages = new List <SheetPage>(); int sheetPageNodeIndex = 0; foreach (XmlNode pageNode in sheetPageNodes) { /*用来画表*/ //SheetRectangle paperMarginWithTwipsUnit = this.GetPaperMarginWithTwipsUnit(); int paperActualHeight = Convert.ToInt32(sheetReport.PaperHeightWithTwipsUnit) - 750 * 1440 / 1000 - 750 * 1440 / 1000; //TOP - BOTTOM int pointX = 1000 * 1440 / 1000; //Left int pointY = 750 * 1440 / 1000 - sheetPageNodeIndex * paperActualHeight; // TOP sheetPageNodeIndex++; /**/ SheetPage sheetPage = new SheetPage(); sheetReport.SheetPages.Add(sheetPage); XmlNode tableNode = pageNode.SelectSingleNode("SheetTable"); SheetTable sheetTable = new SheetTable(); sheetPage.SheetTable = sheetTable; sheetTable.RowPositionCollection = new List <RowPosition>(); XmlNodeList rowPositionNodes = tableNode.SelectNodes("RowPositionCollection/RowPosition"); foreach (XmlNode rowPositionNode in rowPositionNodes) { RowPosition rowPosition = new RowPosition(); rowPosition.position = rowPositionNode.Attributes["position"].Value; sheetTable.RowPositionCollection.Add(rowPosition); } sheetTable.ColumnPositionCollection = new List <ColumnPosition>(); XmlNodeList columnPositionNodes = tableNode.SelectNodes("ColumnPositionCollection/ColumnPosition"); foreach (XmlNode columnPositionNode in columnPositionNodes) { ColumnPosition columnPosition = new ColumnPosition(); columnPosition.position = columnPositionNode.Attributes["position"].Value; sheetTable.ColumnPositionCollection.Add(columnPosition); } sheetTable.SheetRows = new List <SheetRow>(); XmlNodeList sheetRowNodes = tableNode.SelectNodes("SheetRow"); //int rowIndex = 0; //用来画表 int rowCount = sheetTable.RowPositionCollection.Count - 1; int columnCount = sheetTable.ColumnPositionCollection.Count - 1; for (int rowIndex = 0; rowIndex < rowCount; rowIndex++) { XmlNode sheetRowNode = sheetRowNodes[rowIndex]; SheetRow sheetRow = new SheetRow(); sheetTable.SheetRows.Add(sheetRow); XmlNodeList sheetColumnNodes = sheetRowNode.SelectNodes("SheetColumn"); sheetRow.SheetColumns = new List <SheetColumn>(); //int columnIndex = 0; //用来画表 for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) { XmlNode sheetColumnNode = sheetColumnNodes[columnIndex]; SheetColumn sheetColumn = new SheetColumn(); sheetRow.SheetColumns.Add(sheetColumn); XmlNode sheetItemNodeNode = sheetColumnNode.SelectSingleNode("SheetItemNode"); SheetItemNode sheetItemNode = new SheetItemNode(); sheetItemNode.IsCellUnit = sheetItemNodeNode.Attributes["IsCellUnit"].Value; sheetItemNode.CellPx = sheetItemNodeNode.Attributes["CellPx"].Value; sheetItemNode.CellPy = sheetItemNodeNode.Attributes["CellPy"].Value; sheetColumn.SheetItemNode = sheetItemNode; if ("0" == sheetItemNode.IsCellUnit) { continue; } /**/ for (int px = 0; px < Convert.ToInt32(sheetItemNode.CellPx); px++) { for (int py = 0; py < Convert.ToInt32(sheetItemNode.CellPy); py++) { if (px > 0 && px < Convert.ToInt32(sheetItemNode.CellPx) - 1 && py > 0 && py < Convert.ToInt32(sheetItemNode.CellPy) - 1) { continue; } SheetRectangle nodeRectangle = new SheetRectangle(); nodeRectangle.Left = Convert.ToInt32(sheetTable.ColumnPositionCollection[columnIndex + px].position); nodeRectangle.Right = Convert.ToInt32(sheetTable.ColumnPositionCollection[columnIndex + px + 1].position); nodeRectangle.Top = Convert.ToInt32(sheetTable.RowPositionCollection[rowIndex + py].position); nodeRectangle.Bottom = Convert.ToInt32(sheetTable.RowPositionCollection[rowIndex + py + 1].position); nodeRectangle.Left += pointX; nodeRectangle.Right += pointX; nodeRectangle.Top += pointY; nodeRectangle.Bottom += pointY; //计算放大倍数,换算为Pixels为单位 nodeRectangle.Left = nodeRectangle.Left * 2 / 30; nodeRectangle.Right = nodeRectangle.Right * 2 / 30; nodeRectangle.Top = nodeRectangle.Top * 2 / 30; nodeRectangle.Bottom = nodeRectangle.Bottom * 2 / 30; float width = nodeRectangle.Right - nodeRectangle.Left; float height = nodeRectangle.Bottom - nodeRectangle.Top; //result.Append("<div style='position:absolute;border:solid 1px black; left:" + (nodeRectangle.Left + 50) + "px; top:" + nodeRectangle.Top + "px; width:" + width + "px; height:" + height + "px;'></div>"); float pageStartPointX = 21 + 20; float pageStartPointY = 21 + 16; // 合并单元格左边框 if (px == 0) { float startPointX = nodeRectangle.Left + pageStartPointX; float startPointY = nodeRectangle.Top + pageStartPointY; float endPointX = nodeRectangle.Left + pageStartPointX; float endPointY = nodeRectangle.Bottom + pageStartPointY; width = endPointX - startPointX; height = endPointY - startPointY; result.Append(" <div style='position:absolute;border-left:solid 1px black; left:" + startPointX + "px; top:" + startPointY + "px; width:" + width + "px; height:" + height + "px;'></div>\r\n"); } // 合并单元格上边框 if (py == 0) { float startPointX = nodeRectangle.Left + pageStartPointX; float startPointY = nodeRectangle.Top + pageStartPointY; float endPointX = nodeRectangle.Right + pageStartPointX; float endPointY = nodeRectangle.Top + pageStartPointY; width = endPointX - startPointX; height = endPointY - startPointY; result.Append(" <div style='position:absolute;border-top:solid 1px black; left:" + startPointX + "px; top:" + startPointY + "px; width:" + width + "px; height:" + height + "px;'></div>\r\n"); } // 合并单元格右边框 if (px == Convert.ToInt32(sheetItemNode.CellPx) - 1 //最后一条边 //&& columnIndex + Convert.ToInt32(sheetItemNode.CellPx) == columnCount ) { float startPointX = nodeRectangle.Right + pageStartPointX; float startPointY = nodeRectangle.Top + pageStartPointY; float endPointX = nodeRectangle.Right + pageStartPointX; float endPointY = nodeRectangle.Bottom + pageStartPointY; width = endPointX - startPointX; height = endPointY - startPointY; result.Append(" <div style='position:absolute;border-right:solid 1px black; left:" + startPointX + "px; top:" + startPointY + "px; width:" + width + "px; height:" + height + "px;'></div>\r\n"); } // 合并单元格下边框 if (py == Convert.ToInt32(sheetItemNode.CellPy) - 1 //最后一条边 //&& rowIndex + Convert.ToInt32(sheetItemNode.CellPy) == rowCount ) { float startPointX = nodeRectangle.Left + pageStartPointX; float startPointY = nodeRectangle.Bottom + pageStartPointY; float endPointX = nodeRectangle.Right + pageStartPointX; float endPointY = nodeRectangle.Bottom + pageStartPointY; if (columnIndex + Convert.ToInt32(sheetItemNode.CellPx) == columnCount) { // 画图时右下角缺一块??? endPointX++; } width = endPointX - startPointX; height = endPointY - startPointY; result.Append(" <div style='position:absolute;border-bottom:solid 1px black; left:" + startPointX + "px; top:" + startPointY + "px; width:" + width + "px; height:" + height + "px;'></div>\r\n"); } } } /**/ } }