//public bool IfHaveCountStockDailyDocument(CDBUtil dbUtil, MySqlConnection conn, int shopId) //{ // string sql = "SELECT * FROM document WHERE DocumentID=" + DocumentId + " AND shopid=" + shopId // + " AND documenttypeid=24 AND documentstatus=1"; // MySqlDataReader reader = dbUtil.sqlRetrive(sql, conn); // if (reader.Read()) // { // reader.Close(); // return true; // } // else // reader.Close(); // return false; //} public virtual bool AddAdjustDocument(CDBUtil dbUtil, MySqlConnection conn) { string sql = " INSERT INTO document (DocumentID, ShopID, DocumentTypeID, DocumentYear, DocumentMonth, " + " DocumentNumber, DocumentDate, InputBy, UpdateBy, ApproveBy, DocumentStatus, DocumentIDRef, " + " DocIDRefShopID, ProductLevelID, ToInvID, FromInvID, Remark, InsertDate, UpdateDate, ApproveDate) " + " VALUES(" + DocumentId + ", " + ShopId + ", " + DocumentTypeId + ", " + DocumentYear + ", " + DocumentMonth + ", " + DocumentNumber + ", '" + DocumentDate.ToString("yyyy'-'MM'-'dd", dateProvider) + "', " + InputBy + ", " + UpdateBy + ", " + ApproveBy + ", " + DocumentStatus + ", " + DocumentIdRef + ", " + DocIdRefShopId + ", " + ProductLevelId + ", " + ToInvId + ", " + FromInvId + ", '" + Remark + "', '" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "', '" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "', '" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "')"; try { int exec = dbUtil.sqlExecute(sql, conn); if (exec > 0) { AddMaxDocumentNumber(dbUtil, conn); return(true); } } catch { return(false); } return(false); }
public XElement ToXML() { var xDocumentInfo = new XElement(Fb2Const.fb2DefaultNamespace + "document-info"); foreach (AuthorType author in _documentAuthors) { xDocumentInfo.Add(author.ToXML()); } if (ProgramUsed2Create != null) { xDocumentInfo.Add(ProgramUsed2Create.ToXML(ProgramUsedElementName)); } if (DocumentDate != null) { xDocumentInfo.Add(DocumentDate.ToXML()); } foreach (string srcUrl in _sourceUrLs) { xDocumentInfo.Add(new XElement(Fb2Const.fb2DefaultNamespace + SourceURLElementName, srcUrl)); } if (SourceOCR != null) { xDocumentInfo.Add(SourceOCR.ToXML(SourceOCRElementName)); } if (!string.IsNullOrEmpty(ID)) { xDocumentInfo.Add(new XElement(Fb2Const.fb2DefaultNamespace + IdElementName, ID)); } if (DocumentVersion != null) { var cult = new CultureInfo("", false); xDocumentInfo.Add(new XElement(Fb2Const.fb2DefaultNamespace + VersionElementName, string.Format(cult.NumberFormat, "{0:F}", DocumentVersion))); } if (History != null) { xDocumentInfo.Add(History.ToXML()); } foreach (AuthorType publish in _documentPublishers) { xDocumentInfo.Add(publish.ToXML()); } return(xDocumentInfo); }
public virtual bool AddDocument(CDBUtil dbUtil, MySqlConnection conn) { string sql = ""; if (this.DocumentTypeId == 7 || this.DocumentTypeId == 10) { sql = " SELECT * FROM document WHERE ShopID=" + ShopId + " AND DocumentTypeID = " + DocumentTypeId + " AND DocumentYear=" + this.DocumentYear + " AND DocumentMonth = " + this.DocumentMonth + " AND DocumentStatus=1"; } else if (this.DocumentTypeId == 57) { StockCountWeeklyDoro scd = new StockCountWeeklyDoro(conn, ShopId, 57); string dateFrom = scd.SundayDate(); sql = " SELECT * FROM document \n" + " WHERE ShopID=" + ShopId + " AND DocumentTypeID=" + DocumentTypeId + "\n" + " AND DocumentDate BETWEEN '" + dateFrom + "' AND \n" + " '" + DateTime.Now.ToString("yyyy-MM-dd", dateProvider) + "' \n" + " AND DocumentStatus=1"; } else { sql = " SELECT * FROM document WHERE ShopID=" + ShopId + " AND DocumentTypeID = " + DocumentTypeId + " AND DocumentStatus=1 AND DocumentDate=" + " {d '" + this.DocumentDate.ToString("yyyy'-'MM'-'dd", dateProvider) + "'} " + " AND DocumentStatus=1"; } MySqlDataReader reader = dbUtil.sqlRetrive(sql, conn); if (reader.Read()) { // Add Docdetail if (reader["DocumentID"] != DBNull.Value) { DocumentId = Convert.ToInt32(reader["DocumentID"]); } if (reader["Remark"] != DBNull.Value) { Remark = reader.GetString("Remark"); } reader.Close(); sql = "UPDATE document SET UpdateDate='" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "', " + " Remark = '" + Remark + "' WHERE DocumentID=" + DocumentId + " AND ShopID=" + ShopId; dbUtil.sqlExecute(sql, conn); sql = "DELETE FROM docdetail WHERE DocumentID=" + DocumentId + " AND ShopID=" + ShopId; dbUtil.sqlExecute(sql, conn); sql = "DELETE FROM docdetailtemp WHERE DocumentID=" + DocumentId + " AND ShopID=" + ShopId; dbUtil.sqlExecute(sql, conn); return(true); } else { reader.Close(); sql = " INSERT INTO document (DocumentID, ShopID, " + " DocumentTypeID, DocumentYear, DocumentMonth, DocumentNumber, DocumentDate, InputBy, " + " UpdateBy, DocumentStatus, Remark, DocumentIDRef, DocIDRefShopID, ProductLevelID, InsertDate, UpdateDate) " + " VALUES(" + DocumentId + ", " + ShopId + ", " + DocumentTypeId + ", " + DocumentYear + ", " + DocumentMonth + ", " + DocumentNumber + ", '" + DocumentDate.ToString("yyyy'-'MM'-'dd", dateProvider) + "', " + InputBy + ", " + UpdateBy + ", 1, '" + Remark + "', " + DocumentIdRef + ", " + DocIdRefShopId + ", " + ProductLevelId + ", '" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "', '" + DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss", dateProvider) + "')"; try { int exec = dbUtil.sqlExecute(sql, conn); if (exec > 0) { // add maxdocumentnumber AddMaxDocumentNumber(dbUtil, conn); return(true); } } catch { return(false); } } return(false); }