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