Example #1
0
        public static bool DeleteProject(ClsProject project)
        {
            bool             isTrue = false;
            StringBuilder    strBuilder;
            List <string>    listNames;
            List <SqlDbType> listDBTypes;
            List <object>    listValues;

            strBuilder = new StringBuilder("DELETE FROM [项目列表] WHERE [项目ID]=@intProjectID");

            listNames   = new List <string>();
            listDBTypes = new List <SqlDbType>();
            listValues  = new List <object>();

            listNames.Add("@intProjectID");
            listDBTypes.Add(SqlDbType.Int);
            listValues.Add(project.intProjectID);

            try
            {
                object obj = EventUpdateTableUsePara(strBuilder.ToString(), listNames, listDBTypes, listValues);
                isTrue = true;
            }
            catch (Exception ex)
            {
                throw new Exception("失败", new Exception(ex.Message));
            }
            return(isTrue);
        }
Example #2
0
        public int ModifyProject(ClsProject project)
        {
            int              _intProjectID = 0;
            StringBuilder    strBuilder;
            List <string>    listNames;
            List <SqlDbType> listDBTypes;
            List <object>    listValues;

            strBuilder = new StringBuilder("UPDATE [项目列表] SET [项目名称]=@projectName,[创建人]=@testStuff,[备注]=@description WHERE [项目ID]=@intProjectID");

            listNames   = new List <string>();
            listDBTypes = new List <SqlDbType>();
            listValues  = new List <object>();

            listNames.Add("@intProjectID");
            listDBTypes.Add(SqlDbType.VarChar);
            listValues.Add(project.intProjectID);

            listNames.Add("@projectName");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.strProjectName);

            listNames.Add("@testStuff");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.strProjectBuilder);

            listNames.Add("@description");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.description);

            if (0 == EventUpdateTableUsePara(strBuilder.ToString(), listNames, listDBTypes, listValues))
            {
                throw new Exception("用户信息修改失败");
            }
            try
            {
                object obj = EventUpdateTableUsePara(strBuilder.ToString(), listNames, listDBTypes, listValues);
                _intProjectID        = int.Parse(obj.ToString());
                project.intProjectID = _intProjectID;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return(_intProjectID);
        }
Example #3
0
        public int AddProject(ClsProject project)
        {
            int              projectID = 0;
            StringBuilder    strBuilder;
            List <string>    listNames;
            List <SqlDbType> listDBTypes;
            List <object>    listValues;

            strBuilder = new StringBuilder("INSERT INTO [项目列表]([项目名称],[测试时间],[创建人],[备注])");
            strBuilder.Append(" VALUES(@projectName,@testTime,@testStuff,@description);SELECT SCOPE_IDENTITY()");

            listNames   = new List <string>();
            listDBTypes = new List <SqlDbType>();
            listValues  = new List <object>();

            listNames.Add("@projectName");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.strProjectName);

            listNames.Add("@testTime");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.dtpTime);

            listNames.Add("@testStuff");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.strProjectBuilder);

            listNames.Add("@description");
            listDBTypes.Add(@SqlDbType.VarChar);
            listValues.Add(project.description);
            try
            {
                object obj = EventReturnObjectUserPara(strBuilder.ToString(), listNames, listDBTypes, listValues);
                projectID            = int.Parse(obj.ToString());
                project.intProjectID = projectID;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return(projectID);
        }