Exemplo n.º 1
0
        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();
            }
        }
Exemplo n.º 2
0
        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]);
        }