protected void btnOK_Click(object sender, EventArgs e) { if (!Valid()) { mpeInfo.Show(); return; } try { ProjectInfoEntity entity = new ProjectInfoEntity { ProjectName = txtDialogProjectName.Text.Trim(), PKID = hfPKID.Value.SafeToInt() }; if (entity.PKID > 0) { ProjectInfoLogic.UpdateProjectInfo(entity); } else { ProjectInfoLogic.InsertProjectInfo(entity); } mpeInfo.Hide(); BindDataSource(); } catch (Exception ex) { DialogMessage = "<span class='fontred'>" + ex.Message + "</span>"; mpeInfo.Show(); } }
public static void UpdateProjectInfo(ProjectInfoEntity projectInfoEntity) { var project = ProjectInfoDA.GetProjectInfoByPKID(projectInfoEntity.PKID); if (project != null) { Valid(projectInfoEntity); ProjectInfoDA.UpdateProjectInfo(projectInfoEntity, project.ProjectName); } }
public static void InsertProjectInfo(ProjectInfoEntity projectInfoEntity) { using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString)) { dataOperator.CommandText = @" INSERT INTO [dbo].[TProjectInfo]( [ProjectName] ) VALUES( @ProjectName) SELECT @@IDENTITY "; dataOperator.SetParameter("@ProjectName", projectInfoEntity.ProjectName, SqlDbType.NVarChar, 200); object obj = dataOperator.ExecuteScalar(); int returnValue; int.TryParse(obj.ToString(), out returnValue); projectInfoEntity.PKID = returnValue; } }
public static ProjectInfoEntity GetProjectInfoByName(string name) { using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString)) { dataOperator.CommandText = @" SELECT [PKID], [ProjectName] FROM [dbo].[TProjectInfo] WITH(NOLOCK) WHERE [ProjectName]=@ProjectName "; dataOperator.SetParameter("@ProjectName", name, SqlDbType.NVarChar, 200); ProjectInfoEntity projectInfoEntity = dataOperator.ExecuteEntity <ProjectInfoEntity>(); return(projectInfoEntity); } }
public static void UpdateProjectInfo(ProjectInfoEntity projectInfoEntity, string oldProjectName) { using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString)) { dataOperator.CommandText = @" UPDATE [dbo].[TProjectInfo] SET [ProjectName]=@ProjectName WHERE [PKID]=@PKID UPDATE [dbo].TReimburse set Project=@ProjectName where Project=@OldProjectName "; dataOperator.SetParameter("@PKID", projectInfoEntity.PKID, SqlDbType.Int); dataOperator.SetParameter("@ProjectName", projectInfoEntity.ProjectName, SqlDbType.NVarChar, 200); dataOperator.SetParameter("@OldProjectName", oldProjectName, SqlDbType.NVarChar, 200); dataOperator.ExecuteNonQuery(); } }
public static ProjectInfoEntity GetProjectInfoByPKID(int pKID) { using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString)) { dataOperator.CommandText = @" SELECT [PKID], [ProjectName] FROM [dbo].[TProjectInfo] WITH(NOLOCK) WHERE [PKID]=@PKID "; dataOperator.SetParameter("@PKID", pKID, SqlDbType.Int); ProjectInfoEntity projectInfoEntity = dataOperator.ExecuteEntity <ProjectInfoEntity>(); return(projectInfoEntity); } }
private static void Valid(ProjectInfoEntity projectInfoEntity) { if (ProjectInfoDA.GetExistsByNameDiffPKID(projectInfoEntity.ProjectName, projectInfoEntity.PKID)) { throw new Exception("项目名称重复"); } if (projectInfoEntity.ProjectName.Split(' ').Length > 1) { var code = projectInfoEntity.ProjectName.Split(' ')[0]; if (code.Split('-').Length > 1) { code = code.Split('-')[1]; } if (ProjectInfoDA.GetExistsByCodeDiffPKID(code, projectInfoEntity.PKID)) { throw new Exception("项目编号重复"); } } else { throw new Exception("请填写项目编号"); } }
public static void InsertProjectInfo(ProjectInfoEntity projectInfoEntity) { Valid(projectInfoEntity); ProjectInfoDA.InsertProjectInfo(projectInfoEntity); }