public static string ExpExcel(string path) { ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks; Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1 worksheet.Cells[1, 1] = "管道名称"; // 数据查询 OleDbDataReader rst = null; string ret = CommonQuery.qryRst("select * from PIPELINE", ref rst); Int16 i = 2; DicCache dic = DicCache.getInstance(); if (ret.Equals("0")) { while (rst.Read()) { worksheet.Cells[i, 1] = rst["DATA1"].ToString(); i++; } rst.Close(); } string sPath = path; string filename = "海底管道数据导出.xls"; workbook.Saved = true; workbook.SaveCopyAs(sPath + filename); xlApp.Quit(); obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS); obj_ReturnDoc.setFuncErrorInfo(filename); } catch (Exception e) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(e.Message); } return obj_ReturnDoc.getXml(); }
public static string drop(string strEventTypeID) { DataStorage storage = new DataStorage(); // 删除角色权限 string strSQL = "DELETE FROM ROLEPOWER WHERE EVENTTYPEID='" + strEventTypeID + "'"; storage.addSQL(strSQL); // 删除对应的事件 strSQL = "DELETE FROM EVENTTYPE WHERE EVENTTYPEID='" + strEventTypeID + "'"; storage.addSQL(strSQL); // 执行 string strReturn = storage.runSQL(); ReturnDoc returndoc = new ReturnDoc(); if (!General.empty(strReturn)) { returndoc.addErrorResult(Common.RT_FUNCERROR); returndoc.setFuncErrorInfo(strReturn); } else { returndoc.addErrorResult(Common.RT_SUCCESS); } return returndoc.getXml(); }
public static string addNew(string strXml) { DataDoc doc = new DataDoc(strXml); // 创建执行对象 DataStorage storage = new DataStorage(); int size = doc.getDataNum(Table.USERLIST); // 解析sql语句 for (int i = 0; i < size; i++) { XmlElement ele = (XmlElement)doc.getDataNode(Table.USERLIST, i); string a = ele.InnerXml; XmlNode node = XmlFun.getNode(ele, Field.USERID); string strId = NumAssign.assignID_A("000002"); XmlFun.setNodeValue(node,strId); storage.addSQL(SQLAnalyse.analyseXMLSQL(ele)); } // 执行 string strReturn = storage.runSQL(); ReturnDoc returndoc = new ReturnDoc(); if (!General.empty(strReturn)) { returndoc.addErrorResult(Common.RT_FUNCERROR); returndoc.setFuncErrorInfo(strReturn); } else { returndoc.addErrorResult(Common.RT_SUCCESS); } return returndoc.getXml(); }
/// <summary> /// 删除角色 /// </summary> /// <param name="strRoleID"></param> /// <returns></returns> public static string DropRole(string strRoleID) { DataStorage storage = new DataStorage(); string str_SQL = "DELETE FROM ROLEBASIC WHERE ROLEID='" + strRoleID + "'"; storage.addSQL(str_SQL); str_SQL = "DELETE FROM ROLEPOWER WHERE ROLEID='" + strRoleID + "'"; storage.addSQL(str_SQL); str_SQL = "DELETE FROM ROLEUSER WHERE ROLEID='" + strRoleID + "'"; storage.addSQL(str_SQL); // 执行 string strReturn = storage.runSQL(); ReturnDoc returndoc = new ReturnDoc(); if (!General.empty(strReturn)) { returndoc.addErrorResult(Common.RT_FUNCERROR); returndoc.setFuncErrorInfo(strReturn); } else { returndoc.addErrorResult(Common.RT_SUCCESS); } return returndoc.getXml(); }
protected void Page_Load(object sender, EventArgs e) { try { string sMothod = Request["method"]; if (!General.empty(sMothod)) { Type ts = typeof(baseRef); object obj = Activator.CreateInstance(ts, null); //获得一个实例 object[] methodParamArgs = new object[] { Request, Response }; MethodInfo mi = ts.GetMethod(sMothod); //获得执行方法 string sXml = (string)mi.Invoke(obj, methodParamArgs); //带参数方法的调用并返回值 Response.ContentType = "text/xml;charset=utf-8"; Response.Charset = "UTF-8"; Response.Write(sXml); } } catch (Exception ex) { ReturnDoc obj_ReturnDoc = new ReturnDoc(); obj_ReturnDoc.addErrorResult(ex.Message); obj_ReturnDoc.setFuncErrorInfo(Common.SRT_FUNCERROR); Response.Write(obj_ReturnDoc.getXml()); } }
public static string addNew(string strXml) { /// 创建执行对象 DataStorage obj_Storage = new DataStorage(); ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXml); XmlNodeList nodeLst = obj_Doc.SelectNodes("//*[@operation][@operation!='']"); for (int i = 0; i < nodeLst.Count; i++ ) { XmlElement ele_Temp = (XmlElement)nodeLst.Item(i); // 分配学生编码 string strpersonid = NumAssign.assignID_B("100001", "1007"); XmlFun.setNodeValue(ele_Temp.SelectSingleNode("//PERSONID"), strpersonid); string stT = ele_Temp.InnerXml; // 创建插入数据的XML string str_SQL = SQLAnalyse.analyseXMLSQL(ele_Temp); obj_Storage.addSQL(str_SQL); } /// 执行 string str_Return = obj_Storage.runSQL(); if (!General.empty(str_Return)) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(str_Return); } else { obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS); } } catch(Exception e) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(e.Message); } return obj_ReturnDoc.getXml(); }
/// <summary> /// 统一处理标准的业务操作型XML文档,将文档分析称T-SQL封装到DataStorage类中作为一个事务执行 /// </summary> /// <param name="strXML">标准业务操作型XML文档</param> /// <returns>标准 XML 返回文档字符串</returns> public static string dealWithXml(string strXML) { /// 创建执行对象 DataStorage obj_Storage = new DataStorage(); ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXML); XmlNodeList nodeLst = obj_Doc.SelectNodes("//*[@operation][@operation!='']"); for (int i = 0; i < nodeLst.Count; i++) { XmlElement ele_Temp = (XmlElement)nodeLst.Item(i); // 创建插入数据的XML string str_SQL = SQLAnalyse.analyseXMLSQL(ele_Temp); obj_Storage.addSQL(str_SQL); } /// 执行 string str_Return = obj_Storage.runSQL(); if (!General.empty(str_Return)) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(str_Return); } else { obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS); } } catch (Exception e) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(e.Message); } return(obj_ReturnDoc.getXml()); }
/// <summary> /// 统一处理标准的业务操作型XML文档,将文档分析称T-SQL封装到DataStorage类中作为一个事务执行 /// </summary> /// <param name="strXML">标准业务操作型XML文档</param> /// <returns>标准 XML 返回文档字符串</returns> public static string dealWithXml(string strXML) { /// 创建执行对象 DataStorage obj_Storage = new DataStorage(); ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXML); XmlNodeList nodeLst = obj_Doc.SelectNodes("//*[@operation][@operation!='']"); for (int i = 0; i < nodeLst.Count; i++ ) { XmlElement ele_Temp = (XmlElement)nodeLst.Item(i); // 创建插入数据的XML string str_SQL = SQLAnalyse.analyseXMLSQL(ele_Temp); obj_Storage.addSQL(str_SQL); } /// 执行 string str_Return = obj_Storage.runSQL(); if (!General.empty(str_Return)) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(str_Return); } else { obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS); } } catch(Exception e) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(e.Message); } return obj_ReturnDoc.getXml(); }
/// <summary> /// 生成字典文件 /// </summary> /// <param name="Request"></param> /// <param name="Response"></param> /// <returns></returns> public string CreateDicFile(HttpRequest Request, HttpResponse Response) { string strDicName = Request["txtXML"]; ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { General.CreateDicFile(strDicName); obj_ReturnDoc.setErrorResult(Common.SRT_SUCCESS); } catch (Exception ep) { obj_ReturnDoc.addErrorResult(ep.Message); obj_ReturnDoc.setFuncErrorInfo(Common.SRT_FUNCERROR); } return(obj_ReturnDoc.getXml()); }
protected void Page_Load(object sender, EventArgs e) { Response.ContentType = "text/xml;charset=utf-8"; Response.Charset = "UTF-8"; string strDicName = Request["txtDicName"]; ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { General.CreateDicFile(strDicName); obj_ReturnDoc.setErrorResult(Common.SRT_SUCCESS); } catch (Exception ep) { obj_ReturnDoc.addErrorResult(ep.Message); obj_ReturnDoc.setFuncErrorInfo(Common.SRT_FUNCERROR); } Response.Write(obj_ReturnDoc.getXml()); }
public static string psnDel(string strPersonID) { /// 创建执行对象 DataStorage obj_Storage = new DataStorage(); ReturnDoc obj_ReturnDoc = new ReturnDoc(); // 手工构造sql语句 string str_SQL = "DELETE FROM PERSON WHERE PERSONID='" + strPersonID + "'"; obj_Storage.addSQL(str_SQL); /// 执行sql string str_Return = obj_Storage.runSQL(); if (!General.empty(str_Return)) { obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR); obj_ReturnDoc.setFuncErrorInfo(str_Return); } else { obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS); } return obj_ReturnDoc.getXml(); }
/// <summary> /// 生成字典文件 /// </summary> /// <param name="Request"></param> /// <param name="Response"></param> /// <returns></returns> public string CreateDicFile(HttpRequest Request, HttpResponse Response) { string strDicName = Request["txtXML"]; ReturnDoc obj_ReturnDoc = new ReturnDoc(); try { General.CreateDicFile(strDicName); obj_ReturnDoc.setErrorResult(Common.SRT_SUCCESS); } catch (Exception ep) { obj_ReturnDoc.addErrorResult(ep.Message); obj_ReturnDoc.setFuncErrorInfo(Common.SRT_FUNCERROR); } return obj_ReturnDoc.getXml(); }