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="strXml"></param> /// <returns></returns> public static string addNew2(string strXml) { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXml); // 分配学生编码 string strpersonid = NumAssign.assignID_B("100002", "1007"); XmlFun.setNodeValue(obj_Doc, "//PERSONID", strpersonid); string op_xml = obj_Doc.InnerXml; /// 调用统一的标准操作型xml的处理方法 return(Operation.dealWithXml(op_xml)); }
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> /// 添加订单 /// </summary> /// <param name="strXml"></param> /// <returns></returns> public static string OrdersAdd(string strXml) { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXml); // 循环遍历所有的订单编号节点,为其分配统一的订单编码 // 分配订单编码 string strOrdID = NumAssign.assignID_B("100004", General.curYear2() + General.curMonth() + General.curDay()); for (int i = 0; i < obj_Doc.SelectNodes("//PIPEID").Count; i++) { // obj_Doc.SelectNodes("//ORDID").Item(i).InnerText = strOrdID; XmlFun.setNodeValue(obj_Doc, "//PIPEID", i, strOrdID); } /// 调用统一的标准操作型xml的处理方法 return(Operation.dealWithXml(obj_Doc.InnerXml)); }
/// <summary> /// 添加新的班级,并重新生成字典文件 /// </summary> /// <param name="strXml"></param> /// <returns></returns> public static string ClassAdd(string strXml) { XmlDocument obj_Doc = XmlFun.CreateNewDoc(strXml); // 分配班级编码 string strClassID = NumAssign.assignID_B("100003", "A"); XmlFun.setNodeValue(obj_Doc, "//CLASSID", strClassID); string op_xml = obj_Doc.InnerXml; /// 调用统一的标准操作型xml的处理方法 string strRetXml = Operation.dealWithXml(op_xml); DicCache.getInstance().createDicFile("DIC_STUCLASS", "SELECT CLASSID,CLASSNAME FROM STUCLASS ORDER BY CLASSID"); return(strRetXml); }