Ejemplo n.º 1
0
 public void PTU_Header_INSERT(PTU_Header OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PTU_Header_LAB] " +
                         " ([SoPTU] " +
                         " ,[VENDCode] " +
                         " ,[VENDName] " +
                         " ,[NgayLapPhieu] " +
                         " ,[NgayTamUng] " +
                         " ,[NoiDung] " +
                         " ,[SoTienTamUng] " +
                         " ,[SoTienDaTamUng] " +
                         " ,[SoTienDeNghiThanhToan] " +
                         " ,[PaymentTerm] " +
                         " ,[CreatedDate] " +
                         " ,[CreatedBy] " +
                         " ,[Note] " +
                         " ,[Locked]) " +
                         " VALUES " +
                         "(N'" + OBJ.SoPTU +
                         "',N'" + OBJ.VENDCode +
                         "',N'" + OBJ.VENDName +
                         "',CONVERT(datetime,'" + OBJ.NgayLapPhieu +
                         "',103),CONVERT(datetime,'" + OBJ.NgayTamUng +
                         "',103),N'" + OBJ.NoiDung +
                         "'," + OBJ.SoTienTamUng +
                         "," + OBJ.SoTienDaTamUng +
                         "," + OBJ.SoTienDeNghiThanhToan +
                         ",'" + OBJ.PaymentTerm +
                         "',CONVERT(datetime,'" + DateTime.Now +
                         "',103),N'" + OBJ.CreatedBy +
                         "',N'" + OBJ.Note +
                         "','" + OBJ.Locked +
                         "')", CommandType.Text);
 }
Ejemplo n.º 2
0
 public void PTU_Header_UPDATE(PTU_Header OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PTU_Header_LAB] SET " +
                         "[SoPTU]                                              = N'" + OBJ.SoPTU + "'" +
                         "[VENDCode]                                          = N'" + OBJ.VENDCode + "'" +
                         ",[VENDName]                                         = N'" + OBJ.VENDName + "'" +
                         ",[NgayLapPhieu]                                     = CONVERT(datetime,'" + OBJ.NgayLapPhieu + "',103)" +
                         ",[NgayTamUng]                                     = CONVERT(datetime,'" + OBJ.NgayTamUng + "',103)" +
                         ",[NoiDung]                                   = N'" + OBJ.NoiDung + "'" +
                         ",[PaymentTerm]                                      = N'" + OBJ.PaymentTerm + "'" +
                         ",[SoTienTamUng]                                      = " + OBJ.SoTienTamUng +
                         ",[SoTienDaTamUng]                                      = " + OBJ.SoTienDaTamUng +
                         ",[SoTienDeNghiThanhToan]                                      = " + OBJ.SoTienDeNghiThanhToan +
                         ",[CreatedDate]                                      = CONVERT(datetime,'" + DateTime.Now + "',103)" +
                         ",[CreatedBy]                                        = N'" + OBJ.CreatedBy + "' " +
                         ",[Note]                                             = N'" + OBJ.Note + "' " +
                         ",[Locked]                                           = '" + OBJ.Locked + "' " +
                         " WHERE [ID]                                         = " + OBJ.ID, CommandType.Text);
 }
Ejemplo n.º 3
0
 public void PTU_Header_INSERT(PTU_Header OBJ)
 {
     DAO.PTU_Header_INSERT(OBJ);
 }
Ejemplo n.º 4
0
 public void PTU_Header_UPDATE(PTU_Header OBJ)
 {
     DAO.PTU_Header_UPDATE(OBJ);
 }