public string updateDbWithoutSend2(updateOAStorageData data, string filename) { List <updateOAStorageData> list = new List <updateOAStorageData>(); list.Add(data); return(updateDB(list, filename, "")); }
private string createFile(string tempDir, string vartOrdernr) { string error = ""; string fileName = ""; List <updateOAStorageData> updateList = new List <updateOAStorageData>(); try { if (!tempDir.EndsWith("/")) { tempDir += "/"; } fileName = getFileName(vartOrdernr); tempDir += fileName; tempDir = HttpContext.Current.Server.MapPath(tempDir); XmlSerializer serializer = new XmlSerializer(typeof(CCompStoreData.TRANSACTION)); var appendMode = false; Encoding encoding = Encoding.GetEncoding("ISO-8859-1"); TextWriter writer = new StreamWriter(tempDir, appendMode, encoding); CCompStoreData.TRANSACTION trans = new CCompStoreData.TRANSACTION(); trans.Company = 1; string s = System.DateTime.Today.ToString().Replace("-", ""); trans.Date = System.DateTime.Today.ToString("yyMMdd"); trans.Time = System.DateTime.Now.ToString(); DataTable dt = getOrderArtRows(vartOrdernr, ref error); if (error != "") { return(error); } List <CCompStoreData.TRANSACTIONORDERLINE> transLines = new List <CCompStoreData.TRANSACTIONORDERLINE>(); foreach (DataRow dr in dt.Rows) { Decimal stockToSend = 0; string errTxt = ""; try { errTxt = ""; stockToSend = Convert.ToDecimal(dr["sum_antal"]) - Convert.ToDecimal(dr["oa_sum"]); if (stockToSend > -0.001M && stockToSend < 0.001M) { continue; } CCompStoreData.TRANSACTIONORDERLINE transOrder = new CCompStoreData.TRANSACTIONORDERLINE(); int AssignmentTypeId = 2; if (stockToSend < 0) { AssignmentTypeId = 1; } transOrder.AssignmentTypeId = Convert.ToSByte(AssignmentTypeId); transOrder.ItemDescription = dr["artnamn"].ToString(); transOrder.ItemNo = dr["artikelkod"].ToString(); transOrder.OrderlineNo = getNextRowNo().ToString(); transOrder.OrderNo = vartOrdernr; transOrder.ReqQuantity = calculateQuantity(stockToSend); transOrder.Status = 0; transLines.Add(transOrder); } catch (Exception ex) { errTxt = ex.Message; } updateOAStorageData us = new updateOAStorageData(); Decimal stockToSend2 = errTxt == "" ? stockToSend : 0; us.orderArtId = Convert.ToInt32(dr["orderArtId"]); us.stockToSend = stockToSend2; us.error = errTxt; updateList.Add(us); } trans.ORDERLINES = transLines; serializer.Serialize(writer, trans); writer.Close(); error = copyToCSshare(tempDir, fileName); } catch (Exception ex) { error = ex.Message; } if (error == "") { error = updateDB(updateList, fileName, error); } return(error); }