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