public int UpdateThird(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PT_D_Role set ");
builder.Append("RoleTypeName='" + model.RoleTypeName + "',");
builder.Append("DutyTask='" + model.DutyTask + "',");
builder.Append("Achievement='" + model.Achievement + "',");
builder.Append("MoralCharacter='" + model.MoralCharacter + "',");
builder.Append("Expand='" + model.Expand + "',");
builder.Append("AgeRequet='" + model.AgeRequet + "',");
builder.Append("SexRequest='" + model.SexRequest + "',");
builder.Append("StatureRequest='" + model.StatureRequest + "',");
builder.Append("Avoirdupois='" + model.Avoirdupois + "',");
builder.Append("Audition='" + model.Audition + "',");
builder.Append("Eye='" + model.Eye + "',");
builder.Append("DucationalBackground='" + model.DucationalBackground + "',");
builder.Append("Experience='" + model.Experience + "',");
builder.Append("Talk='" + model.Talk + "',");
builder.Append("Communicate='" + model.Communicate + "',");
builder.Append("DutyExplain='" + model.DutyExplain + "',");
builder.Append("Competency='" + model.Competency + "',");
builder.Append("DutyDescribe='" + model.DutyDescribe + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where RoleTypeCode='" + model.RoleTypeCode + "'");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int AddThird(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PT_D_Role(");
builder.Append("RoleTypeCode,RoleTypeName,ParentCode,DutyTask,Achievement,MoralCharacter,Expand,AgeRequet,SexRequest,StatureRequest,Avoirdupois,Audition,Eye,DucationalBackground,Experience,Talk,Communicate,DutyExplain,Competency,DutyDescribe,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.RoleTypeCode + "',");
builder.Append("'" + model.RoleTypeName + "',");
builder.Append("'" + model.ParentCode + "',");
builder.Append("'" + model.DutyTask + "',");
builder.Append("'" + model.Achievement + "',");
builder.Append("'" + model.MoralCharacter + "',");
builder.Append("'" + model.Expand + "',");
builder.Append("'" + model.AgeRequet + "',");
builder.Append("'" + model.SexRequest + "',");
builder.Append("'" + model.StatureRequest + "',");
builder.Append("'" + model.Avoirdupois + "',");
builder.Append("'" + model.Audition + "',");
builder.Append("'" + model.Eye + "',");
builder.Append("'" + model.DucationalBackground + "',");
builder.Append("'" + model.Experience + "',");
builder.Append("'" + model.Talk + "',");
builder.Append("'" + model.Communicate + "',");
builder.Append("'" + model.DutyExplain + "',");
builder.Append("'" + model.Competency + "',");
builder.Append("'" + model.DutyDescribe + "',");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
private PTDRole GetData()
{
PTDRole pTDRole = new PTDRole();
pTDRole.RoleTypeCode = this.txtRoleTypeCode.Text;
if (this.OperateType == "add")
{
pTDRole.ParentCode = this.RoleTypeCode;
}
else
{
pTDRole.ParentCode = this.txtRoleTypeCode.Text.Substring(0, 6);
}
pTDRole.Achievement = this.txtAchievement.Text;
pTDRole.AgeRequet = this.txtAgeRequet.Text;
pTDRole.Audition = this.txtAudition.Text;
pTDRole.Avoirdupois = this.txtAvoirdupois.Text;
pTDRole.Communicate = this.txtCommunicate.Text;
pTDRole.Competency = this.txtCompetency.Text;
pTDRole.DucationalBackground = this.txtDucationalBackground.Text;
pTDRole.DutyDescribe = this.txtDutyDescribe.Text;
pTDRole.DutyExplain = this.txtDutyExplain.Text;
pTDRole.DutyTask = this.txtDutyTask.Text;
pTDRole.Expand = this.txtExpand.Text;
pTDRole.Experience = this.txtExperience.Text;
pTDRole.Eye = this.txtEye.Text;
pTDRole.MoralCharacter = this.txtMoralCharacter.Text;
pTDRole.Remark = this.txtRemark.Text;
pTDRole.RoleTypeName = this.txtRoleTypeName.Text;
pTDRole.SexRequest = this.txtSexRequest.Text;
pTDRole.StatureRequest = this.txtStatureRequest.Text;
pTDRole.Talk = this.txtTalk.Text;
return(pTDRole);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
PTDRole data = this.GetData();
if (this.OperateType == "add")
{
int num = this.mcAction.AddThird(data);
if (num > 0)
{
this.JS.Text = "returnValue=true;window.close();";
}
else
{
this.JS.Text = "没有相关数据可添加!";
}
}
if (this.OperateType == "upd")
{
int num = this.mcAction.UpdateThird(data);
if (num > 0)
{
this.JS.Text = "returnValue=true;window.close();";
return;
}
this.JS.Text = "没有相关数据可更新!";
}
}
public int Add(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PT_D_Role(");
builder.Append("RoleTypeCode,RoleTypeName,ParentCode,DutyTask,Achievement,MoralCharacter,Expand,AgeRequet,SexRequest,StatureRequest,Avoirdupois,Audition,Eye,DucationalBackground,Experience,Talk,Communicate,DutyExplain,Competency,DutyDescribe,Remark)");
builder.Append(" values (");
builder.Append("@RoleTypeCode,@RoleTypeName,@ParentCode,@DutyTask,@Achievement,@MoralCharacter,@Expand,@AgeRequet,@SexRequest,@StatureRequest,@Avoirdupois,@Audition,@Eye,@DucationalBackground,@Experience,@Talk,@Communicate,@DutyExplain,@Competency,@DutyDescribe,@Remark)");
SqlParameter[] commandParameters = new SqlParameter[] {
new SqlParameter("@RoleTypeCode", SqlDbType.VarChar, 9), new SqlParameter("@RoleTypeName", SqlDbType.VarChar, 20), new SqlParameter("@ParentCode", SqlDbType.VarChar, 6), new SqlParameter("@DutyTask", SqlDbType.VarChar, 200), new SqlParameter("@Achievement", SqlDbType.VarChar, 200), new SqlParameter("@MoralCharacter", SqlDbType.VarChar, 200), new SqlParameter("@Expand", SqlDbType.VarChar, 200), new SqlParameter("@AgeRequet", SqlDbType.VarChar, 200), new SqlParameter("@SexRequest", SqlDbType.VarChar, 200), new SqlParameter("@StatureRequest", SqlDbType.VarChar, 200), new SqlParameter("@Avoirdupois", SqlDbType.VarChar, 200), new SqlParameter("@Audition", SqlDbType.VarChar, 200), new SqlParameter("@Eye", SqlDbType.VarChar, 200), new SqlParameter("@DucationalBackground", SqlDbType.VarChar, 200), new SqlParameter("@Experience", SqlDbType.VarChar, 500), new SqlParameter("@Talk", SqlDbType.VarChar, 200),
new SqlParameter("@Communicate", SqlDbType.VarChar, 200), new SqlParameter("@DutyExplain", SqlDbType.Text), new SqlParameter("@Competency", SqlDbType.VarChar, 200), new SqlParameter("@DutyDescribe", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 200)
};
commandParameters[0].Value = model.RoleTypeCode;
commandParameters[1].Value = model.RoleTypeName;
commandParameters[2].Value = model.ParentCode;
commandParameters[3].Value = model.DutyTask;
commandParameters[4].Value = model.Achievement;
commandParameters[5].Value = model.MoralCharacter;
commandParameters[6].Value = model.Expand;
commandParameters[7].Value = model.AgeRequet;
commandParameters[8].Value = model.SexRequest;
commandParameters[9].Value = model.StatureRequest;
commandParameters[10].Value = model.Avoirdupois;
commandParameters[11].Value = model.Audition;
commandParameters[12].Value = model.Eye;
commandParameters[13].Value = model.DucationalBackground;
commandParameters[14].Value = model.Experience;
commandParameters[15].Value = model.Talk;
commandParameters[0x10].Value = model.Communicate;
commandParameters[0x11].Value = model.DutyExplain;
commandParameters[0x12].Value = model.Competency;
commandParameters[0x13].Value = model.DutyDescribe;
commandParameters[20].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public int Update(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PT_D_Role set ");
builder.Append("RoleTypeName='" + model.RoleTypeName + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where RoleTypeCode='" + model.RoleTypeCode + "'");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Update(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PT_D_Role set ");
builder.Append("RoleTypeName=@RoleTypeName,");
builder.Append("ParentCode=@ParentCode,");
builder.Append("DutyTask=@DutyTask,");
builder.Append("Achievement=@Achievement,");
builder.Append("MoralCharacter=@MoralCharacter,");
builder.Append("Expand=@Expand,");
builder.Append("AgeRequet=@AgeRequet,");
builder.Append("SexRequest=@SexRequest,");
builder.Append("StatureRequest=@StatureRequest,");
builder.Append("Avoirdupois=@Avoirdupois,");
builder.Append("Audition=@Audition,");
builder.Append("Eye=@Eye,");
builder.Append("DucationalBackground=@DucationalBackground,");
builder.Append("Experience=@Experience,");
builder.Append("Talk=@Talk,");
builder.Append("Communicate=@Communicate,");
builder.Append("DutyExplain=@DutyExplain,");
builder.Append("Competency=@Competency,");
builder.Append("DutyDescribe=@DutyDescribe,");
builder.Append("Remark=@Remark");
builder.Append(" where RoleTypeCode=@RoleTypeCode ");
SqlParameter[] commandParameters = new SqlParameter[] {
new SqlParameter("@RoleTypeCode", SqlDbType.VarChar, 9), new SqlParameter("@RoleTypeName", SqlDbType.VarChar, 20), new SqlParameter("@ParentCode", SqlDbType.VarChar, 6), new SqlParameter("@DutyTask", SqlDbType.VarChar, 200), new SqlParameter("@Achievement", SqlDbType.VarChar, 200), new SqlParameter("@MoralCharacter", SqlDbType.VarChar, 200), new SqlParameter("@Expand", SqlDbType.VarChar, 200), new SqlParameter("@AgeRequet", SqlDbType.VarChar, 200), new SqlParameter("@SexRequest", SqlDbType.VarChar, 200), new SqlParameter("@StatureRequest", SqlDbType.VarChar, 200), new SqlParameter("@Avoirdupois", SqlDbType.VarChar, 200), new SqlParameter("@Audition", SqlDbType.VarChar, 200), new SqlParameter("@Eye", SqlDbType.VarChar, 200), new SqlParameter("@DucationalBackground", SqlDbType.VarChar, 200), new SqlParameter("@Experience", SqlDbType.VarChar, 500), new SqlParameter("@Talk", SqlDbType.VarChar, 200),
new SqlParameter("@Communicate", SqlDbType.VarChar, 200), new SqlParameter("@DutyExplain", SqlDbType.Text), new SqlParameter("@Competency", SqlDbType.VarChar, 200), new SqlParameter("@DutyDescribe", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 200)
};
commandParameters[0].Value = model.RoleTypeCode;
commandParameters[1].Value = model.RoleTypeName;
commandParameters[2].Value = model.ParentCode;
commandParameters[3].Value = model.DutyTask;
commandParameters[4].Value = model.Achievement;
commandParameters[5].Value = model.MoralCharacter;
commandParameters[6].Value = model.Expand;
commandParameters[7].Value = model.AgeRequet;
commandParameters[8].Value = model.SexRequest;
commandParameters[9].Value = model.StatureRequest;
commandParameters[10].Value = model.Avoirdupois;
commandParameters[11].Value = model.Audition;
commandParameters[12].Value = model.Eye;
commandParameters[13].Value = model.DucationalBackground;
commandParameters[14].Value = model.Experience;
commandParameters[15].Value = model.Talk;
commandParameters[0x10].Value = model.Communicate;
commandParameters[0x11].Value = model.DutyExplain;
commandParameters[0x12].Value = model.Competency;
commandParameters[0x13].Value = model.DutyDescribe;
commandParameters[20].Value = model.Remark;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
public int Add(PTDRole model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into PT_D_Role(");
builder.Append("RoleTypeCode,RoleTypeName,ParentCode,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.RoleTypeCode + "',");
builder.Append("'" + model.RoleTypeName + "',");
builder.Append("'" + model.ParentCode + "',");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public PTDRole GetModel(string RoleTypeCode)
{
StringBuilder builder = new StringBuilder();
builder.Append("select RoleTypeCode,RoleTypeName,ParentCode,DutyTask,Achievement,MoralCharacter,Expand,AgeRequet,SexRequest,StatureRequest,Avoirdupois,Audition,Eye,DucationalBackground,Experience,Talk,Communicate,DutyExplain,Competency,DutyDescribe,Remark from PT_D_Role ");
builder.Append(" where RoleTypeCode=@RoleTypeCode ");
PTDRole role = new PTDRole();
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@RoleTypeCode", RoleTypeCode) }))
{
if (reader.Read())
{
role = this.ReaderBind(reader);
}
}
return(role);
}
private PTDRole GetData()
{
PTDRole pTDRole = new PTDRole();
if (this.OperateType == "upd")
{
pTDRole.RoleTypeCode = this.RoleTypeCode;
}
else
{
pTDRole.RoleTypeCode = this.mcAction.GetNewRoleTypeCode(this.RoleTypeCode);
pTDRole.ParentCode = this.RoleTypeCode;
}
pTDRole.RoleTypeName = this.txtBookLibraryName.Text.Trim();
pTDRole.Remark = this.txtRemark.Text;
return(pTDRole);
}
public string GetDutyName(string id)
{
PTDRole model = this.pTDRoleBll.GetModel(id);
return(model.RoleTypeName);
}
public int Update(PTDRole model)
{
return(this.pTDRoleService.Update(model));
}
public int Add(PTDRole model)
{
return(this.pTDRoleService.Add(model));
}
