public static void ImportTitle()
{
try
{
ImportSqlServerUtility sql = new ImportSqlServerUtility();
string strsql = "select * from POSTRANKCODE";
RelationSqlServerUtility rsql = new RelationSqlServerUtility();
rsql.ExecuteSql("truncate table rtitle ");
string insertsql = " insert into rtitle(old,new) values('{0}','{1}')";
DataSet ds = sql.ExecuteSqlDataSet(strsql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CY.CSTS.Core.Business.UserPostRank title = new CY.CSTS.Core.Business.UserPostRank();
title.PostRankName = ds.Tables[0].Rows[i][1].ToString();
title.Save();
rsql.ExecuteSql(string.Format(insertsql, ds.Tables[0].Rows[i][0].ToString(), title.Id.ToString()));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btRegister_Click(object sender, EventArgs e)
{
CY.CSTS.Core.Business.User registerUser = new CY.CSTS.Core.Business.User();
// 用户名
if (tbUserName.Text != null && tbUserName.Text.Trim() != "")
{
if (CY.CSTS.Core.Business.User.GetUserByUserId(tbUserName.Text) != null)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('该ID已被其它用户注册，请更换ID')</script>");
return;
}
else
{
registerUser.UserID = tbUserName.Text;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请填写登陆ID')</script>");
return;
}
// 电子邮件
if (tbEmail.Text != null && tbEmail.Text.Trim() != "")
{
string email = tbEmail.Text.Trim();
if (Regex.IsMatch(email, @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"))
{
//IList<CY.CSTS.Core.Business.User> all = CY.CSTS.Core.Business.User.GetAllUser() as List<CY.CSTS.Core.Business.User>;
//List<CY.CSTS.Core.Business.User> users = all.Where(item => item.Email == tbEmail.Text).ToList();
//if (users.Count == 0 || users == null)
//{
registerUser.Email = tbEmail.Text;
//}
//else5
//{
// Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电子邮件错误", "<script>alert('该电子邮件地址已被注册')</script>");
// return;
//}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电子邮件", "<script>alert('电子邮件格式不正确')</script>");
return;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电子邮件", "<script>alert('请填写电子邮件')</script>");
return;
}
// 性别
if (rblSex.SelectedValue != "" && rblSex.SelectedValue != null)
{
registerUser.Gender = rblSex.SelectedValue;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择性别')</script>");
return;
}
// 真实姓名
if (tbRealName.Text != null && tbRealName.Text.Trim() != "")
{
registerUser.Name = tbRealName.Text;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请填写真实姓名')</script>");
return;
}
if (ddlPostRand.Visible)
{
// 职称
if (ddlPostRand.Text.Trim() != "")
{
List<CY.CSTS.Core.Business.UserPostRank> postRankList = CY.CSTS.Core.Business.UserPostRank.GetAllUserPostRank()
as List<CY.CSTS.Core.Business.UserPostRank>;
postRankList = postRankList.Where(Items => Items.PostRankName == ddlPostRand.Text.Trim()).ToList();
Guid postId = new Guid();
if (postRankList.Count == 0)
{
CY.CSTS.Core.Business.UserPostRank post = new CY.CSTS.Core.Business.UserPostRank();
post.PostRankName = ddlPostRand.Text.Trim();
post.Save();
postId = post.Id;
}
else
{
postId = postRankList[0].Id;
}
registerUser.PostRankID = postId;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择职称')</script>");
return;
}
}
if (ddlEdu.Visible)
{
// 学历
if (ddlEdu.SelectedValue != null && ddlEdu.SelectedValue != "")
{
registerUser.EducationID = new System.Guid(ddlEdu.SelectedValue);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择学历')</script>");
return;
}
}
// 头像
if (hfIconPath.Value != null && !hfIconPath.Value.Equals(""))
{
registerUser.PicURL = hfIconPath.Value;
}
else
{
registerUser.PicURL = "Content/Icon/defaultIcon.jpg";
}
// 密码
if (tbPwd.Text != null && tbPwd.Text != "" && tbPwdConfirm.Text != null && tbPwdConfirm.Text != "")
{
if (tbPwd.Text != tbPwdConfirm.Text)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('两次密码不一致')</script>");
return;
}
else
{
registerUser.Password = tbPwd.Text;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请确认密码填写正确')</script>");
return;
}
// 出生日期
if (tbBirthday.Text.Trim() != "" && tbBirthday.Text != null)
{
registerUser.BirthDate = Convert.ToDateTime(tbBirthday.Text);
}
else
{
registerUser.BirthDate = new DateTime();
}
// 通信地址
registerUser.Address = tbAddress.Text.Trim();
// 邮政编码
if (tbCode.Text != null && !tbCode.Text.Trim().Equals(""))
{
int temp = 0;
string code = tbCode.Text.Trim();
if (!int.TryParse(code, out temp))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "邮政编码错误", "<script>alert('邮政编码格式不对')</script>");
return;
}
else
{
registerUser.Mailcode = code;
}
}
else
{
registerUser.Mailcode = "";
}
// 传真
registerUser.Fax = tbFax.Text;
// 固定电话
if (tbFixPhone.Text != null && !tbFixPhone.Text.Trim().Equals(""))
{
int tempPhone = 0;
string phone = tbFixPhone.Text.Trim();
if (!int.TryParse(phone, out tempPhone))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电话错误", "<script>alert('电话格式不对')</script>");
return;
}
else
{
registerUser.Phone = phone;
}
}
else
{
registerUser.Phone = "";
}
// 移动电话
registerUser.MobilePhone = tbCellFhone.Text;
// 专长
registerUser.Specialty = tbSpecialty.Text;
// 专业简历
registerUser.Resume = fckResume.Value;
// 备注
registerUser.Remark = tbRemark.Text;
// 人员类型
registerUser.UserType = Int32.Parse(ddlUserType.SelectedValue);
if (registerUser.UserType != 1 && registerUser.UserType != 4 && registerUser.UserType != 5)
{
// 单位
if (ddlUnit.SelectedValue != null && ddlUnit.SelectedValue != "")
{
registerUser.UnitID = new System.Guid(ddlUnit.SelectedValue);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "单位", "<script>alert('请选择单位')</script>");
return;
}
}
// 主要论文
registerUser.Discourse = tbPaper.Value;
// 获奖情况
registerUser.Acquire = tbAcquire.Value;
List<CY.CSTS.Core.Business.ExpertField> selectFiled = new List<CY.CSTS.Core.Business.ExpertField>(); // 保存研究领域
if (ddlUserType.SelectedValue == "4")
{
// 所在单位
registerUser.Unit = tbUnitOfExpert.Text;
// 职务
registerUser.Duty = tbDuty.Text;
// 研究领域1
if (ddlField.SelectedValue != null && ddlField.SelectedValue != "")
{
registerUser.FeildID = new System.Guid(ddlField.SelectedValue);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "研究领域", "<script>alert('请选择研究领域')</script>");
return;
}
// 研究领域2
for (int i = 0; i < cblField.Items.Count; i++)
{
if (cblField.Items[i].Selected)
{
CY.CSTS.Core.Business.ExpertField f = new CY.CSTS.Core.Business.ExpertField();
f.FieldID = new Guid(cblField.Items[i].Value);
selectFiled.Add(f);
}
}
}
// 注册时间
registerUser.RegDate = System.DateTime.Now;
// 最后登录时间
//registerUser.LastActiveTime = new DateTime();
// 状态, 2 表示正常
registerUser.Status = 2;
// 保存用户
//registerUser.Save();
// 保存专家研究领域
if (ddlUserType.SelectedValue == "4")
{
// SaveAndGetId保存专家用户，并获取ID
string id = registerUser.SaveAndGetId();
for (int j = 0; j < selectFiled.Count; j++)
{
selectFiled[j].ExpertID = new Guid(id);
selectFiled[j].Save();
}
}
else
{
registerUser.Save();
}
//Server.Transfer("UserInfo.aspx");
// 跳回上一页面
if (ViewState["PrePage"] != null)
{
string url = ViewState["PrePage"].ToString();
Response.Redirect(url);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "添加成功", "<script>alert('添加成功')</script>");
return;
}
}
protected void btModify_Click(object sender, EventArgs e)
{
if ((CY.CSTS.Core.Business.User)Session["User"] != null)
{
CY.CSTS.Core.Business.User registerUser = CY.CSTS.Core.Business.User.Load(((CY.CSTS.Core.Business.User)Session["User"]).Id);
if (registerUser.UserType != 4 || (registerUser.UserType == 4 && registerUser.Status == 5))
{
// 性别
if (rblSex.SelectedValue != "" && rblSex.SelectedValue != null)
{
registerUser.Gender = rblSex.SelectedValue;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择性别')</script>");
return;
}
// 真实姓名
if (tbRealName.Text != null && tbRealName.Text.Trim() != "")
{
registerUser.Name = tbRealName.Text;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请填写真实姓名')</script>");
return;
}
// 职称
if (tbPost.Text.Trim()!= "")
{
List<CY.CSTS.Core.Business.UserPostRank> postRankList = CY.CSTS.Core.Business.UserPostRank.GetAllUserPostRank()
as List<CY.CSTS.Core.Business.UserPostRank>;
postRankList = postRankList.Where(Items => Items.PostRankName == tbPost.Text.Trim()).ToList();
Guid postId = new Guid();
if (postRankList.Count == 0)
{
CY.CSTS.Core.Business.UserPostRank post = new CY.CSTS.Core.Business.UserPostRank();
post.PostRankName = tbPost.Text.Trim();
post.Save();
postId = post.Id;
}
else
{
postId = postRankList[0].Id;
}
registerUser.PostRankID = postId;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请填写职称')</script>");
return;
}
// 学历
if (ddlEdu.SelectedValue != null && ddlEdu.SelectedValue != "")
{
registerUser.EducationID = new System.Guid(ddlEdu.SelectedValue);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择学历')</script>");
return;
}
// 头像
if (hfIconPath.Value != null && !hfIconPath.Value.Equals(""))
{
registerUser.PicURL = hfIconPath.Value;
}
else
{
if (imgIcon.ImageUrl != null && !imgIcon.ImageUrl.Equals(""))
{
if (imgIcon.ImageUrl.Contains("../.."))
{
imgIcon.ImageUrl = imgIcon.ImageUrl.Remove(imgIcon.ImageUrl.IndexOf("../.."), 6);
}
registerUser.PicURL = imgIcon.ImageUrl;
}
else
{
registerUser.PicURL = "";
}
}
// 密码
if (tbPwd.Text != null && tbPwd.Text != "" && tbPwdConfirm.Text != null && tbPwdConfirm.Text != "")
{
if (tbPwd.Text != tbPwdConfirm.Text)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('两次密码不一致')</script>");
return;
}
else
{
registerUser.Password = tbPwd.Text;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请确认密码填写正确')</script>");
return;
}
// 出生日期
if (tbBirthday.Text.Trim() != "" && tbBirthday.Text != null)
{
registerUser.BirthDate = Convert.ToDateTime(tbBirthday.Text);
}
else
{
registerUser.BirthDate = new DateTime();
}
// 通信地址
registerUser.Address = tbAddress.Text.Trim();
// 邮政编码
if (tbCode.Text != null && !tbCode.Text.Trim().Equals(""))
{
int temp = 0;
string code = tbCode.Text.Trim();
if (!int.TryParse(code, out temp))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "邮政编码错误", "<script>alert('邮政编码格式不对')</script>");
return;
}
else
{
registerUser.Mailcode = code;
}
}
else
{
registerUser.Mailcode = "";
}
// 传真
registerUser.Fax = tbFax.Text;
// 固定电话
if (tbFixPhone.Text != null && !tbFixPhone.Text.Trim().Equals(""))
{
int tempPhone = 0;
string phone = tbFixPhone.Text.Trim();
//if (!int.TryParse(phone, out tempPhone))
//{
// Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电话错误", "<script>alert('电话格式不对')</script>");
// return;
//}
//else
{
registerUser.Phone = phone;
}
}
else
{
registerUser.Phone = "";
}
// 移动电话
registerUser.MobilePhone = tbCellFhone.Text;
// 电子邮件
if (tbEmail.Text != null && tbEmail.Text.Trim() != "")
{
string email = tbEmail.Text.Trim();
if (Regex.IsMatch(email, @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"))
{
registerUser.Email = tbEmail.Text;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电子邮件", "<script>alert('电子邮件格式不正确')</script>");
return;
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "电子邮件", "<script>alert('请填写电子邮件')</script>");
return;
}
// 专长
registerUser.Specialty = tbSpecialty.Text;
// 专业简历
registerUser.Resume = fckResume.Value;
// 备注
registerUser.Remark = tbRemark.Value;
// 主要论文
registerUser.Discourse = tbPaper.Value;
// 获奖情况
registerUser.Acquire = tbAcquire.Value;
List<CY.CSTS.Core.Business.ExpertField> selectFiled = new List<CY.CSTS.Core.Business.ExpertField>();
if (registerUser.UserType == 4) // 4表示专家
{
// 所在单位
registerUser.Unit = tbUnitOfExpert.Text;
// 职务
registerUser.Duty = tbDuty.Text;
// 研究领域1
if (ddlField.SelectedValue != null && ddlField.SelectedValue != "")
{
registerUser.FeildID = new System.Guid(ddlField.SelectedValue);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "研究领域", "<script>alert('请选择研究领域')</script>");
return;
}
// 研究领域2
for (int i = 0; i < cblExpertField.Items.Count; i++)
{
if (cblExpertField.Items[i].Selected)
{
CY.CSTS.Core.Business.ExpertField f = new CY.CSTS.Core.Business.ExpertField();
f.FieldID = new Guid(cblExpertField.Items[i].Value);
f.ExpertID = registerUser.Id;
selectFiled.Add(f);
}
}
}
// 注册时间
registerUser.RegDate = registerUser.RegDate;
// 最后登录时间
registerUser.LastActiveTime = DateTime.Now;
if (registerUser.UserType == 4)
{
// 原领域
List<CY.CSTS.Core.Business.ExpertField> oldExpertFields = CY.CSTS.Core.Business.ExpertField.GetAllExpertField().Where(item => item.ExpertID == registerUser.Id).ToList<CY.CSTS.Core.Business.ExpertField>();
List<string> strOldExpertFieldId = new List<string>();
foreach (CY.CSTS.Core.Business.ExpertField ef in oldExpertFields)
{
strOldExpertFieldId.Add(ef.FieldID.ToString());
}
// 修改后的领域
List<string> strModifiedExpertFieldId = new List<string>();
foreach (CY.CSTS.Core.Business.ExpertField ef in selectFiled)
{
strModifiedExpertFieldId.Add(ef.FieldID.ToString());
}
// 求解新增的领域
List<string> addedFields = strModifiedExpertFieldId.Except(strOldExpertFieldId).ToList<string>();
// 求解被删掉的领域
List<string> deletedFields = strOldExpertFieldId.Except(strModifiedExpertFieldId).ToList<string>();
List<CY.CSTS.Core.Business.ExpertField> added = new List<CY.CSTS.Core.Business.ExpertField>();
List<CY.CSTS.Core.Business.ExpertField> deleted = new List<CY.CSTS.Core.Business.ExpertField>();
foreach (string strNf in addedFields)
{
CY.CSTS.Core.Business.ExpertField ef = new CY.CSTS.Core.Business.ExpertField();
ef.FieldID = new Guid(strNf);
ef.ExpertID = registerUser.Id;
added.Add(ef);
}
foreach (string strOf in deletedFields)
{
if (CY.CSTS.Core.Business.ExpertField.GetAllExpertField().Where(item => item.ExpertID == registerUser.Id && item.FieldID == new Guid(strOf)).ToList<CY.CSTS.Core.Business.ExpertField>().Count > 0)
{
deleted.Add(CY.CSTS.Core.Business.ExpertField.GetAllExpertField().Where(item => item.ExpertID == registerUser.Id && item.FieldID == new Guid(strOf)).ToList<CY.CSTS.Core.Business.ExpertField>().First());
}
}
foreach (CY.CSTS.Core.Business.ExpertField ef in added)
{
ef.Save();
}
foreach (CY.CSTS.Core.Business.ExpertField of in deleted)
{
CY.CSTS.Core.Business.ExpertField df = CY.CSTS.Core.Business.ExpertField.Load(of.Id);
df.DeleteOnSave();
df.Save();
}
registerUser.Status = 2; // 6 表示修改完成
}
registerUser.Save();
//Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "修改成功", "<script>alert('修改成功')</script>");
// 跳转回个人信息页面
//Server.Transfer("UserInfo.aspx");
// 跳回上一页面
if (ViewState["PrePage"] != null)
{
string url = ViewState["PrePage"].ToString();
Response.Redirect(url);
}
else
{
//Response.Redirect("UserInfo.aspx");
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "修改成功", "<script>alert('修改成功')</script>");
return;
}
}
else if (registerUser.UserType == 4 && registerUser.Status == 2)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "请先申请个人信息", "<script>alert('请申请个人信息')</script>");
return;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('暂不能修改')</script>");
return;
}
}
}
private string HandlerData(HttpContext context)
{
StringBuilder returnvalue = new StringBuilder();
returnvalue.Append("{");
try
{
string UnitId = context.Request["UnitId"];
string UserId = context.Request["UserId"];
string UserName = context.Request["UserName"];
string UserPass = context.Request["UserPass"];
string UserEdu = context.Request["UserEdu"];
string UserSex = context.Request["UserSex"];
string UserPost = context.Request["UserPost"];
CY.CSTS.Core.Business.User u = new CY.CSTS.Core.Business.User();
u.UserID = UserId;
u.Password = UserPass;
u.Name = UserName;
if (!UserEdu.Equals(String.Empty) && CY.Utility.Common.StringHelper.IsGuid(UserEdu))
{
u.EducationID = new Guid(UserEdu);
}
// 职称
if (UserPost.Trim() != "")
{
List<CY.CSTS.Core.Business.UserPostRank> postRankList = CY.CSTS.Core.Business.UserPostRank.GetAllUserPostRank()
as List<CY.CSTS.Core.Business.UserPostRank>;
postRankList = postRankList.Where(Items => Items.PostRankName == UserPost.Trim()).ToList();
Guid postId = new Guid();
if (postRankList.Count == 0)
{
CY.CSTS.Core.Business.UserPostRank post = new CY.CSTS.Core.Business.UserPostRank();
post.PostRankName = UserPost.Trim();
post.Save();
postId = post.Id;
}
else
{
postId = postRankList[0].Id;
}
u.PostRankID = postId;
}
if (!UnitId.Equals(String.Empty) && CY.Utility.Common.StringHelper.IsGuid(UnitId))
{
u.UnitID = new Guid(UnitId);
CY.CSTS.Core.Business.UnitInfo ui = CY.CSTS.Core.Business.UnitInfo.Load(u.UnitID);
if (ui == null)
{
throw (new Exception("单位错误"));
}
else
{
if (ui.IsCooperantUnit == 2) //分中心
{
u.UserType = 2;
}
else if (ui.IsCooperantUnit == 1) //协作单位
{
u.UserType = 3;
}
}
}
else
{
throw (new Exception("单位错误"));
}
u.Gender = UserSex;
u.Save();
returnvalue.Append("status:'0',");
returnvalue.Append("message:'ok'");
}
catch (Exception ex)
{
returnvalue.Append("status:'1',");
returnvalue.Append("message:'发生异常'");
}
finally
{
returnvalue.Append("}");
}
return returnvalue.ToString();
}