public static void ClearDtsPay(string ProjectCode) { QueryAgent agent = new QueryAgent(); try { try { agent.ExecuteSql("exec sp_dts_clear_pay '" + ProjectCode + "'"); string projectCode = ProjectRule.GetSalProjectCode(ProjectCode); if ((projectCode != "") || (ProjectCode == "")) { new SalService().ClearSalImpFlag(projectCode); } } catch (Exception exception) { throw exception; } } finally { agent.Dispose(); } }
public static DataTable GetDtsPayByClient(string ProjectCode, string ClientName) { string projectCode = ""; if ((ProjectCode == null) || (ProjectCode == "")) { projectCode = ProjectRule.GetAllSalProjectCode(); } else { projectCode = ProjectRule.GetSalProjectCode(ProjectCode); } SalService service = new SalService(); return(service.GetSalDataHeadClientByClientName(projectCode, ClientName).Tables[0]); }