public void Result_COA_TDDAO_INSERT(Result_COA_TD OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD] " +
                         " ([SoCOA] " +
                         " ,[COATemplateID] " +
                         " ,[WO] " +
                         " ,[ManfBy] " +
                         " ,[SmpDate] " +
                         " ,[ExpDate] " +
                         " ,[AnlDate] " +
                         " ,[ManfDate] " +
                         " ,[LB_MAT] " +
                         " ,[CreatedDate] " +
                         " ,[CreatedBy] " +
                         " ,[Note] " +
                         " ,[Locked]) " +
                         " VALUES " +
                         "(N'" + OBJ.SoCOA +
                         "'," + OBJ.COATemplateID +
                         ",N'" + OBJ.WO +
                         "',N'" + OBJ.ManfBy +
                         "',Convert(datetime,'" + OBJ.SmpDate +
                         "',103),Convert(datetime,'" + OBJ.ExpDate +
                         "',103),Convert(datetime,'" + OBJ.AnlDate +
                         "',103),Convert(datetime,'" + OBJ.ManfDate +
                         "',103),'" + OBJ.LB_MAT +
                         "',Convert(datetime,'" + DateTime.Now +
                         "',103),N'" + OBJ.CreatedBy +
                         "',N'" + OBJ.Note +
                         //"','" + OBJ.Locked +
                         "','False" +
                         "')", CommandType.Text);
 }
 public void Result_COA_TDDAO_UPDATE(Result_COA_TD OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD] SET" +
                         "[SoCOA]          = N'" + OBJ.SoCOA + "'" +
                         ",[COATemplateID] = " + OBJ.COATemplateID +
                         ",[WO]            = N'" + OBJ.WO + "'" +
                         ",[ManfBy]        = N'" + OBJ.ManfBy + "'" +
                         ",[SmpDate]       = Convert(datetime,'" + OBJ.SmpDate + "',103)" +
                         ",[ExpDate]       = Convert(datetime,'" + OBJ.ExpDate + "',103)" +
                         ",[AnlDate]       = Convert(datetime,'" + OBJ.AnlDate + "',103)" +
                         ",[ManfDate]      = Convert(datetime,'" + OBJ.ManfDate + "',103)" +
                         ",[LB_MAT]        = '" + OBJ.LB_MAT + "'" +
                         ",[CreatedDate]   = Convert(datetime,'" + DateTime.Now + "',103)" +
                         ",[CreatedBy]     = N'" + OBJ.CreatedBy + "' " +
                         ",[Note]          = N'" + OBJ.Note + "' " +
                         //",[Locked]        = '" + OBJ.Locked + "' " +
                         ",[Locked]        = 'False' " +
                         " WHERE [ID]      =" + OBJ.ID, CommandType.Text);
 }
Exemple #3
0
 public DataTable COA_Template_Details_SELECT(Result_COA_TD OBJ)
 {
     //XtraMessageBox.Show(OBJ.COATemplateID.ToString());
     return(Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] " +
                                 " WHERE [COATemplateID] =" + OBJ.COATemplateID, CommandType.Text));
 }
 public void Result_COA_KQDAO_DELETE(Result_COA_TD OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_KQ] " +
                         " WHERE [SoCOA]= '" + OBJ.SoCOA + "'", CommandType.Text);
 }
Exemple #5
0
 public DataTable COA_Template_Details_SELECT(Result_COA_TD OBJ)
 {
     return(DAO.COA_Template_Details_SELECT(OBJ));
 }
 public void Result_COA_TDDAO_DELETE(Result_COA_TD OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD] " +
                         " WHERE [ID]=" + OBJ.ID, CommandType.Text);
 }