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);
}
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);
}
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);
}