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));
}
/// <summary>
/// 添加数据库操作错误日志
/// </summary>
/// <param name="lst_SQL">错误的sqlList</param>
public static void addErrorLog(List <string> lst_SQL)
{
DataStorage obj_Storage = new DataStorage();
foreach (string strSQL in lst_SQL)
{
string strPre = General.curYear2() + General.curMonth() + General.curDay();
string strObjID = NumAssign.assignID_B("000011", strPre);
string str_SQL = "INSERT INTO SQLSTORAGE(OBJID,SQLSCRIPT) VALUES ('" + strObjID + "','" + strSQL.Replace(Common.QUOTE, Common.MARK) + "')";
obj_Storage.addSQL(str_SQL);
}
obj_Storage.runSQL();
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string saveFoler = Server.MapPath("upload_files/");
string savePath, fileName, newName = "";
//遍历File表单元素
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
HttpPostedFile postedFile = Request.Files[iFile];
fileName = Path.GetFileName(postedFile.FileName);
if (fileName != "")
{
string fileType = fileName.Substring(fileName.LastIndexOf("."));
if (!fileType.ToLower().Equals(".xls"))
{
throw (new Exception("文件类型错误"));
}
// newName = "dbtask001" + fileType;
newName = Guid.NewGuid().ToString("N") + fileType;
savePath = saveFoler + newName;
//检查是否在服务器上已经存在用户上传的同名文件
if (File.Exists(savePath))
{
File.Delete(savePath);
}
postedFile.SaveAs(savePath);
// 文件保存完成了，现在开始分析Excel 导入到数据库中
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savePath + "; Extended Properties=Excel 8.0;";
OleDbConnection oleConn = new OleDbConnection(strConn);
oleConn.Open();
OleDbCommand mdo = new OleDbCommand("select * from [sheet1$]", oleConn);
Boolean rsOpen = false;
OleDbDataReader rst = mdo.ExecuteReader();
DicCache obj_DicCache = DicCache.getInstance();
DataStorage obj_Storage = new DataStorage();
while (rst.Read())
{
//string dbdate = rst["打标日期"].ToString().Trim();
//string customid = obj_DicCache.getCode("DIC_CUSTOM", rst["客户"].ToString().Trim());
//if(dbdate != "" && customid != "")
//{
//string strtaskid = NumAssign.assignID_B("200001", General.curYear2() + General.curMonth());
//string strtasksubid = NumAssign.assignID_B("200005", customid + General.cDateStr(dbdate));
string PIPEID = NumAssign.assignID_B("100004", General.curYear2() + General.curMonth() + General.curDay());
string DATA1 = rst["管道名称"].ToString().Trim();
string sql = "insert into PIPELINE(PIPEID,DATA1) VALUES('" + PIPEID + "','" + DATA1 + "')";
//string sql = "insert into BARCODETASK (TASKID,DQ,CUSTOMID,DBDATE,WRITETIME,TASKSUBID,SELLNO,XS,JB,DCTYPE,MODEL,ZPLX,CDZH,DBJDM,ZY,GROUPNUM,ORDNUM,STATUS,BAK) values ('" + strtaskid
// + "','" + obj_DicCache.getCode("DIC_DQ", rst["地区"].ToString().Trim()) + "','"
// + customid + "'," + General.formatDate(dbdate) + "," + General.formatDate(rst["任务下达日期"].ToString().Trim()) + ",'" + strtasksubid + "','"
// + rst["销售单据号"].ToString().Trim() + "'," + rst["系数"].ToString().Trim() + ",'"
// + obj_DicCache.getCode("DIC_JB", rst["极板"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_DCTYPE", rst["电池类型"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_MODEL", rst["型号"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_ZPLX", rst["装配类型"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_CDZH", rst["充电组号"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_DBJDM", rst["打码机器"].ToString().Trim()) + "','"
// + obj_DicCache.getCode("DIC_ZY", rst["专用"].ToString().Trim()) + "'," + rst["组数"].ToString().Trim() + ",0,'0','"
// + rst["备注"].ToString().Trim() + "')";
obj_Storage.addSQL(sql);
//}
rsOpen = true;
}
/// 执行
string str_Return = obj_Storage.runSQL();
if (!General.empty(str_Return))
{
throw (new Exception(str_Return));
}
if (rsOpen)
{
rst.Close();
}
oleConn.Close();
}
}
jSONString = "{success:true,message:'上传完成!',filename:'" + newName + "'}";
}//try
catch (Exception ex)
{
jSONString = "{success:false,message:'" + ex.Message.Replace('\'', '"') + "'}";
}//catch
Response.Write(jSONString);
Response.Flush();
}
