protected void Bt_login_Click(object sender, EventArgs e)
{
string expertID = txtUserID.Text;
string expertPwd = txtUserPwd.Text;
Expert expert = new Expert();
int flag = expert.Login(expertID, expertPwd);
if (flag == 1)
{
expert.LoadInfo(expertID);
Response.Cookies["userID"].Value = txtUserID.Text;
Response.Cookies["userID"].Expires = DateTime.Now.AddDays(7);
Response.Cookies["userName"].Value = expert.expertName;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(7);
Response.Cookies["userPwd"].Value = txtUserPwd.Text;
Response.Cookies["userPwd"].Expires = DateTime.Now.AddDays(7);
Response.Redirect("main.htm");
}
else if (flag == -1)
{
Response.Write("<Script Language=JavaScript>alert(\"密码错误！\")</Script>");
}
else if (flag == 0)
{
Response.Write("<Script Language=JavaScript>alert(\"用户名不存在！\")</Script>");
}
}
public string AddExpert(Expert expert)
{
var checkExpert = GetCourses(expert.Zid);
if (checkExpert.Any(course => course.Course == expert.Course))
{
return("You already enrolled for this course");
}
var insertExpert = new SqlCommand(@"INSERT INTO [dbo].[Ks_Expert] ([ZID], [Course], [First_Name], [Last_Name], [Email])
VALUES (@zid, @course, @firstMan, @lastName, @email)", _connection);
insertExpert.Parameters.AddWithValue("@zid", expert.Zid == null ? DBNull.Value.ToString() : expert.Zid);
insertExpert.Parameters.AddWithValue("@firstMan", expert.FirstName == null ? DBNull.Value.ToString() : expert.FirstName);
insertExpert.Parameters.AddWithValue("@lastName", expert.LastName == null ? DBNull.Value.ToString() : expert.LastName);
insertExpert.Parameters.AddWithValue("@email", expert.Email == null ? DBNull.Value.ToString() : expert.Email);
insertExpert.Parameters.AddWithValue("@course", expert.Course == null ? DBNull.Value.ToString() : expert.Course);
_connection.Open();
insertExpert.ExecuteNonQuery();
_connection.Close();
try
{
SendEmail(expert);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return("Successfully Enrolled As Expert");
}
public async Task AddAsync(ExpertRequest request)
{
var user = await _userRepository.GetByAddressAsync(request.Address);
if (user == null)
{
throw new AppErrorException(ErrorCode.UserNotFound);
}
user.SecondName = request.SecondName;
user.FirstName = request.FirstName;
user.Email = request.Email;
user.About = request.About;
await _userRepository.AddRoleAsync(user.Id, RoleType.Expert);
await _userRepository.SaveChangesAsync();
var expert = new Expert(user.Id, true);
expert.SetAreas(request.Areas);
_expertRepository.Add(expert);
await _expertRepository.SaveChangesAsync();
}
protected void Bt_add_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Editor ed = new Editor();
ed.LoadInfo(Request.Cookies["userID"].Value.ToString());
string column = ed.editorColumn;
Hashtable ht = new Hashtable();
ht.Add("expertID", SQLString.GetQuotedString(txtID.Text));
ht.Add("expertPwd", SQLString.GetQuotedString(txtID.Text));//51(aspx)
ht.Add("expertName", SQLString.GetQuotedString(txtName.Text));
ht.Add("expertColumn", SQLString.GetQuotedString(column));
Expert ep = new Expert();
if (ep.Add(ht))
{
Response.Write("<script>alert('添加成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('添加失败！');window.location=window.location;</script>");
}
txtID.Text = "";
txtName.Text = "";
}
}
public static void CallTaxi(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Element origin = (Element)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Travel)bwxExpert).CallTaxiProc(bwxTask, origin));
}
private void LoadExperts()
{
//ugly implementation
experts = new List <Expert>();
Expert e = new Expert("李玲", ExpertSourceEnum.Factory, "Sprites/Expert/Portrait1");
experts.Add(e);
e = new Expert("马寄梅", ExpertSourceEnum.Factory, "Sprites/Expert/Portrait2");
experts.Add(e);
e = new Expert("吕代薇", ExpertSourceEnum.Factory, "Sprites/Expert/Portrait3");
experts.Add(e);
e = new Expert("林莽", ExpertSourceEnum.Factory, "Sprites/Expert/Portrait6");
experts.Add(e);
e = new Expert("刘巧安", ExpertSourceEnum.Vendor, "Sprites/Expert/Portrait4");
experts.Add(e);
e = new Expert("李山荷", ExpertSourceEnum.Vendor, "Sprites/Expert/Portrait5");
experts.Add(e);
e = new Expert("赵南青", ExpertSourceEnum.Vendor, "Sprites/Expert/Portrait7");
experts.Add(e);
e = new Expert("Elton Gates", ExpertSourceEnum.Vendor, "Sprites/Expert/Portrait8");
experts.Add(e);
}
public override void MapFromEntity(Expert entity)
{
base.MapFromEntity(entity);
UrlToSeparatedPage = String.IsNullOrWhiteSpace(entity.Site.WidgetAsSeparatePageUrl) ? null :
$"{entity.Site.WidgetAsSeparatePageUrl}#expertId={Id}";
WorkingHours = DayOfWeekInterval.Parse(entity.WorkingHours);
}
public async Task <IActionResult> OnPost(int expertId)
{
Expert = expertData.GetById(expertId);
if (!ModelState.IsValid)
{
return(Page());
}
MemoryStream ms = new MemoryStream();
foreach (var file in Request.Form.Files)
{
file.CopyTo(ms);
}
Expert.firstName = Input.firstName;
Expert.lastName = Input.lastName;
Expert.specialty = Input.specialty;
Expert.bio = Input.bio;
Expert.image = ms.ToArray();
expertData.Update(Expert);
if (await expertData.Commit())
{
TempData["Message"] = $"Expert {Expert.id} updated";
return(RedirectToPage("./ExpertList"));
}
return(RedirectToPage("./NotFound"));
}
private IEnumerable <Expert> CreateCollection()
{
var p1 = new Prediction(1, 1, "1:0");
var p2 = new Prediction(2, 2, "0:5");
var e1 = new Expert()
{
ExpertId = 1,
Nickname = "Spiderman",
Predictions = new List <Prediction>()
{
p1
},
};
var e2 = new Expert()
{
ExpertId = 2,
Nickname = "Batman",
Predictions = new List <Prediction>()
{
p2
},
};
return(new List <Expert>()
{
e1, e2
});
}
private void Create()
{
string Id = Request["Id"];
Project pEnt = Project.Find(Id);
IList <ProjectUser> puEnts = ProjectUser.FindAllByProperty(ProjectUser.Prop_ProjectId, Id);
pEnt.Status = "已下达";
pEnt.DoUpdate();
foreach (ProjectUser puEnt in puEnts)
{
ExamineTask etEnt = new ExamineTask();
etEnt.ProjectId = Id;
etEnt.ProjectUserId = puEnt.Id;//str ProjectUser 的主键
etEnt.MajorName = puEnt.MajorName;
etEnt.PlanBackTime = Convert.ToDateTime(Request["BackTime"]);
etEnt.State = "未结束";
etEnt.CreateId = WebPortalService.CurrentUserInfo.UserID;
etEnt.CreateName = WebPortalService.CurrentUserInfo.UserID;
etEnt.CreateTime = DateTime.Now;
etEnt.DoCreate();
Expert eEnt = Expert.Find(puEnt.UserId);
//发送邮件
try
{
//string url = "http://192.168.15.81:7007/ConsultationManage/ExamineOpinionEdit.aspx?ExamineTaskId=" + etEnt.Id;
//PhoneMessage.SendWebMail("*****@*****.**", eEnt.Email, "审查任务", "项目名称:【" + pEnt.ProjectName + "】 专业：" + eEnt.MajorName + "，填写审查意见请点击此链接：" + url, "fpxt", "000000", "mail.nerin.com");
}
catch (Exception ex)
{
}
}
}
void GetData()
{
ExpertInfo.Clear();
if (!File.Exists(comboBox_type.Text + ".txt"))
{
MessageBox.Show("尚未建立该类型的专家库", "出错", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
StreamReader sr = new StreamReader(comboBox_type.Text + ".txt", Encoding.Default);
try
{
while (!sr.EndOfStream)
{
Expert exp = new Expert();
exp.Name = sr.ReadLine();
if (exp.Name != "")
{
exp.Unit = sr.ReadLine();
exp.Tel = sr.ReadLine();
}
ExpertInfo.Add(exp);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "出错", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
sr.Close();
}
}
public static void IncrementApply(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom g = (Atom)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Counting)bwxExpert).IncrementApplyProc(bwxTask, g));
}
public static void NotGoalElab(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom g = bwxMsg.Clause;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Counting)bwxExpert).NotGoalElabProc(bwxTask, g));
}
public static void GoalElab(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom g = bwxMsg.Clause;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((BloxAchieve)bwxExpert).GoalElabProc(bwxTask, g));
}
public AssignedEstimationsPage(Problem currentProblem)
{
_currentProblem = currentProblem;
_assignedestimationsOnExpert = AppContext.Client.CheckForAssignedEstimationsOnExperts(_currentProblem.Id);
_assignedestimationsOnALternative = AppContext.Client.CheckForAssignedEstimationsOnAlternatives(_currentProblem.Id);
_currentExpert = AppContext.Client.GetCurrentExpert();
InitializeComponent();
labelCurrentProblem.Text += $" {_currentProblem.Name}";
foreach (var expert in _assignedestimationsOnExpert)
{
dataGridViewEstimationsOnExperts.Rows.Add();
var lastRowIndex = dataGridViewEstimationsOnExperts.Rows.GetLastRow(DataGridViewElementStates.Visible);
dataGridViewEstimationsOnExperts.Rows[lastRowIndex].SetValues(new object[] { expert.Id, expert.Name });
}
foreach (var alternative in _assignedestimationsOnALternative)
{
dataGridViewEstimationsOnAternatives.Rows.Add();
var lastRowIndex = dataGridViewEstimationsOnAternatives.Rows.GetLastRow(DataGridViewElementStates.Visible);
dataGridViewEstimationsOnAternatives.Rows[lastRowIndex].SetValues(new object[] { alternative.Id, alternative.Name, alternative.Description });
}
}
protected void Bt_Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Expert expert = new Expert();
expert.LoadInfo(Request.Cookies["userID"].Value.ToString());
if (txtPwdold.Text == expert.expertPwd)
{
string xwhere = "where expertID=" + SQLString.GetQuotedString(Request.Cookies["userID"].Value.ToString());
Hashtable ht = new Hashtable();
ht.Add("expertPwd", SQLString.GetQuotedString(txtPwdnew.Text));
if (expert.Update(ht, xwhere))
{
Response.Write("<Script Language=JavaScript>alert(\"密码修改成功！\")</Script>");
}
else
{
Response.Write("<Script Language=JavaScript>alert(\"密码修改失败！\")</Script>");
}
}
else
{
Response.Write("<Script Language=JavaScript>alert(\"旧密码错误！\")</Script>");
}
}
}
public void Get_Excel()
{
using (ExcelPackage pck = new ExcelPackage())
{
// date columns
List <string> dateColumns = new List <string>()
{
"WCPC_FECHAPED",
"Fecha Pedido"
};
// hide columns
List <string> hideColumns = new List <string>()
{
"RecordID",
"CategoryID"
};
Expert data = new Expert();
DataTable table = data.Sql_Datatable(sql());
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Datos");
ws.Cells["A1"].LoadFromDataTable(table, true, OfficeOpenXml.Table.TableStyles.Medium14);
FormatWorksheetData(dateColumns, hideColumns, table, ws);
// make sure it is sent as a XLSX file
Response.ContentType = "application/vnd.ms-excel";
// make sure it is downloaded rather than viewed in the browser window
Response.AddHeader("Content-disposition", "attachment; filename=Pedidos_tablet.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
}
}
protected void Bt_send_Click(object sender, EventArgs e)
{
if (IsValid)
{
Expert expert = new Expert();
expert.LoadInfo(Request.Cookies["userID"].Value.ToString());
string msgTo = expert.expertColumn;
Hashtable ht = new Hashtable();
ht.Add("messageFrom", SQLString.GetQuotedString(Request.Cookies["userID"].Value.ToString()));
ht.Add("messageTo", SQLString.GetQuotedString(msgTo));
ht.Add("messageTime", SQLString.GetQuotedString(DateTime.Now.ToString()));
ht.Add("messageTitle", SQLString.GetQuotedString(txtTitle.Text));
ht.Add("messageContent", SQLString.GetQuotedString(txtContent.Text));
ht.Add("messageState", SQLString.GetQuotedString("0"));
Message msg = new Message();
if (msg.NewMesg(ht))
{
Response.Write("<Script Language=JavaScript>alert(\"发送成功！\")</Script>");
}
else
{
Response.Write("<Script Language=JavaScript>alert(\"发送失败！\")</Script>");
}
txtContent.Text = "";
txtTitle.Text = "";
}
}
private bool Get_Excel()
{
Expert con = new Expert();
string sql = datos_aprovisiona();
List <string> hideColumns = new List <string>()
{
"orden"
};
using (ExcelPackage pck = new ExcelPackage())
{
DataTable table = con.Sql_Datatable(sql);
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Datos");
ws.Cells["A1"].LoadFromDataTable(table, true, OfficeOpenXml.Table.TableStyles.Medium14);
FormatWorksheetData(hideColumns, table, ws);
// make sure it is sent as a XLSX file
Response.ContentType = "application/vnd.ms-excel";
// make sure it is downloaded rather than viewed in the browser window
Response.AddHeader("Content-disposition", "attachment; filename=Fuentes_Aprovisionamiento.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
Response.End();
}
return(true);
}
protected void Bt_login_Click(object sender, EventArgs e)
{
string expertID = txtUserID.Text;
string expertPwd = txtUserPwd.Text;
Expert expert = new Expert();
int flag = expert.Login(expertID, expertPwd);
if (flag == 1)
{
expert.LoadInfo(expertID);
Response.Cookies["userID"].Value = txtUserID.Text;
Response.Cookies["userID"].Expires = DateTime.Now.AddDays(7);
Response.Cookies["userName"].Value = expert.expertName;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(7);
Response.Cookies["userPwd"].Value = txtUserPwd.Text;
Response.Cookies["userPwd"].Expires = DateTime.Now.AddDays(7);
Response.Redirect("main.htm");
}
else if (flag == -1)
{
Response.Write("<Script Language=JavaScript>alert(\"密码错误！\")</Script>");
}
else if (flag == 0)
{
Response.Write("<Script Language=JavaScript>alert(\"用户名不存在！\")</Script>");
}
}
/// <summary>
/// Deserialization constructor.
/// </summary>
public ExpertHost(SerializationInfo info, StreamingContext context)
: base(info, context)
{
_expertType = (Type)info.GetValue("expertType", typeof(Type));
_expert = (Expert)info.GetValue("expert", typeof(Expert));
_sessions = (List <PlatformExpertSession>)info.GetValue("existingSessions", _sessions.GetType());
}
public override Expert MapToEntity()
{
Expert expert = base.MapToEntity();
expert.WorkingHours = String.Join(DayOfWeekInterval.DayOfWeekIntervalsSeparator.ToString(), DayOfWeekInterval.Purify(WorkingHours).Select(r => r.ToString()));
return(expert);
}
public static void TravelByTaxi(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Element destination = (Element)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Travel)bwxExpert).TravelByTaxiProc(bwxTask, destination));
}
public void deleteExpert(int id)
{
Expert expert = dbcontext.expert.Find(id);
dbcontext.expert.Remove(expert);
dbcontext.SaveChanges();
}
public static void WriteLine(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
object text = (object)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((SequenceTest)bwxExpert).WriteLineProc(bwxTask, text));
}
public static void GoalElab(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Element g = bwxMsg.Clause;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Travel)bwxExpert).GoalElabProc(bwxTask, g));
}
public static void Foo(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom y = bwxMsg.Clause.Subject;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((RuleTest)bwxExpert).FooProc(bwxTask, y));
}
/// <summary>
/// 获取分页内容列表.
/// </summary>
/// <param name="expertId">评委id.</param>
/// <param name="pageNum">当前页码.</param>
/// <param name="contentNumPerPage">每页显示内容数.</param>
/// <returns>json.</returns>
public ActionResult GetContentList(int expertId, int pageNum, int contentNumPerPage)
{
Expert expert = Db.Queryable <Expert>().Where(it => it.Id == expertId).Single();
// 为了防止某些皮玩家投票完成后按返回键再改数据，这里做多一次判断
if (expert.Status == "已投票")
{
return(Json(new { code = 404 }, JsonRequestBehavior.AllowGet));
}
Project project = Db.Queryable <Project>().Where(it => it.Id == expert.ProjectId).Single();
List <Content> list = new List <Content>();
list = Db.Queryable <Content>().Where(it => it.ProjectId == project.Id).OrderBy(it => it.Id).ToList();
int count = list.Count();
list = list.Skip((pageNum - 1) * contentNumPerPage).Take(contentNumPerPage).ToList();
int hasVoteNum = Db.Queryable <Record>().Where(it => it.ExpertId == expertId && it.Value != null).ToList().Count();
for (int i = 0; i < list.Count(); i++)
{
// 查询是否有值
Record record = Db.Queryable <Record>().Where(it => it.ContentId == list[i].Id && it.ExpertId == expertId).Single();
if (record != null && record.Value != null)
{
list[i].Result = record.Value.ToString();
}
}
return(Json(new { code = 200, totalVoteNum = count, list, hasVoteNum }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Edit(int id, [Bind("ExpertID,FirstName,LastName,Email")] Expert expert)
{
if (id != expert.ExpertID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(expert);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ExpertExists(expert.ExpertID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(expert));
}
public static void BobLikes(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom x = (Atom)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((RuleTest)bwxExpert).BobLikesProc(bwxTask, x));
}
public JsonResult UpdateActive(int?id)
{
var result = false;
if (id != null)
{
Expert xdb = db.Expert.FirstOrDefault(w => w.Id == id);
if (xdb.isActive == false)
{
xdb.isActive = true;
}
else
{
xdb.isActive = false;
}
db.Entry(xdb).State = EntityState.Modified;
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Expert expert, HttpPostedFileBase fileUpload)
{
if (ModelState.IsValid)
{
#region Upload and resize image if needed
if (fileUpload != null)
{
string filename = Path.GetFileName(fileUpload.FileName);
string newFilename = Guid.NewGuid().ToString().Replace("-", string.Empty)
+ Path.GetExtension(filename);
string newFilenameUrl = "/Uploads/team/" + newFilename;
string physicalFilename = Server.MapPath(newFilenameUrl);
fileUpload.SaveAs(physicalFilename);
expert.ImageUrl = newFilenameUrl;
}
#endregion
expert.IsDeleted = false;
expert.CreationDate = DateTime.Now;
expert.Id = Guid.NewGuid();
db.Experts.Add(expert);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(expert));
}
public static void Clear(Process bwxProcess, Expert bwxExpert, Message bwxMsg)
{
Atom x = (Atom)bwxMsg.Clause.Object;
MentalTask bwxTask = new Method(bwxProcess, bwxMsg);
bwxProcess.ScheduleTask(bwxTask, ((Blox)bwxExpert).ClearProc(bwxTask, x));
}
protected void Bt_Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Expert expert = new Expert();
expert.LoadInfo(Request.Cookies["userID"].Value.ToString());
if (txtPwdold.Text == expert.expertPwd)
{
string xwhere = "where expertID=" + SQLString.GetQuotedString(Request.Cookies["userID"].Value.ToString());
Hashtable ht = new Hashtable();
ht.Add("expertPwd", SQLString.GetQuotedString(txtPwdnew.Text));
if (expert.Update(ht, xwhere))
{
Response.Write("<Script Language=JavaScript>alert(\"密码修改成功！\")</Script>");
}
else
{
Response.Write("<Script Language=JavaScript>alert(\"密码修改失败！\")</Script>");
}
}
else
{
Response.Write("<Script Language=JavaScript>alert(\"旧密码错误！\")</Script>");
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string expert = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
Expert ed = new Expert();
if (ed.Del(expert))
{
Response.Write("<script>alert('删除成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('删除失败！');window.location=window.location;</script>");
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string expert = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
string column = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1")).SelectedValue;
Expert ed = new Expert();
if (ed.Update_Column(expert, column))
{
Response.Write("<script>alert('更新成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('更新失败！');window.location=window.location;</script>");
}
}
private static void Main(string[] args)
{
Expert expert = new Expert
{
Email = "mail",
LastName = "LastName"
};
Int32[,] matrix = { { 2, 3 }, { 4, 5 }, { 6, 7 }, {8, 9} };
JavaScriptSerializer serializer = new JavaScriptSerializer();
var st = serializer.Serialize(matrix);
Console.ReadKey();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string userID = Request.Cookies["userID"].Value.ToString();
Expert expert = new Expert();
expert.LoadInfo(userID);
txtName.Text = expert.expertName;
rblSex.SelectedValue = expert.expertSex;
txtMail.Text = expert.expertMail;
txtPhone.Text = expert.expertPhone;
txtAddress.Text = expert.expertAddress;
txtInfo.Text = expert.expertInfo;
ddlcolumn.SelectedValue = expert.expertColumn;
}
}
protected void Bt_update_Click(object sender, EventArgs e)
{
string userID = Request.Cookies["userID"].Value.ToString();
string where = " where editorID=" + SQLString.GetQuotedString(userID);
Hashtable ht = new Hashtable();
ht.Add("expertName", SQLString.GetQuotedString(txtName.Text));
ht.Add("expertSex", SQLString.GetQuotedString(rblSex.SelectedValue));
ht.Add("expertMail", SQLString.GetQuotedString(txtMail.Text));
ht.Add("expertPhone", SQLString.GetQuotedString(txtPhone.Text));
ht.Add("expertAddress", SQLString.GetQuotedString(txtAddress.Text));
ht.Add("expertInfo", SQLString.GetQuotedString(txtInfo.Text));
Expert expert = new Expert();
if (expert.Update(ht, where))
{
Response.Write("<Script Language=JavaScript>alert(\"修改成功！\")</Script>");
}
}
protected void wizRegister_FinishButtonClicked(object sender, EventArgs e)
{
Expert a = new Expert();
a.Email = txtEmail.Text;
a.Username = txtUsername.Text;
a.Password = txtPassword.Text;
a.Name = txtName.Text;
a.Company = txtCompany.Text;
a.Position = txtPosition.Text;
a.Industry = txtIndustry.Text;
a.WorkAddress = txtAddress.Text;
if (listAvailability.SelectedValue == "1")
a.OneOff = true;
else
a.OneOff = false;
a.EventDate = Calendar1.SelectedDate.Date;
Presentation p = new Presentation();
p.Confirmed = false;
p.Date = a.EventDate;
p.Time = 7;
p.Topic = "my first topic";
if (us.EmailInUse(a.Email))
{
ShowErrorMessage("This email is already in use!");
ToggleWizardIndex(1);
}
else if (us.UsernameInUse(a.Username))
{
ShowErrorMessage("This username is already in use!");
ToggleWizardIndex(1);
}
else
{
repository.SaveUser(a);
p.EventExpertID = a.UserID;
repository.SavePresentation(p);
ShowUserCreatedPanel();
}
}
protected void Bt_add_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Hashtable ht = new Hashtable();
ht.Add("expertID", SQLString.GetQuotedString(txtID.Text));
ht.Add("expertPwd", SQLString.GetQuotedString(txtID.Text));
ht.Add("expertName", SQLString.GetQuotedString(txtName.Text));
ht.Add("expertColumn", SQLString.GetQuotedString(ddlcolumn.SelectedValue));
Expert ep = new Expert();
if (ep.Add(ht))
{
Response.Write("<script>alert('添加成功！');window.location=window.location;</script>");
}
else
{
Response.Write("<script>alert('添加失败！');window.location=window.location;</script>");
}
txtID.Text = "";
txtName.Text = "";
}
}
public void SaveUser(Expert user)
{
using (DataClassesDataContext dc = GetContext())
{
if (user.UserID > 0)
{
dc.Experts.Attach(user, true);
}
else
{
dc.Experts.InsertOnSubmit(user);
}
dc.SubmitChanges();
}
}
//根据专家姓名查找专家
public JsonResult SearchExpert()
{
try
{
IMongoQuery q = null;
var name = Request.Params["expertname"];
string status = Request.Params["sta"];
if(!string.IsNullOrWhiteSpace(status)&&status!="0")
{
q = Query.And(Query<专家>.Where(m => (int)m.身份信息.专家类型 == int.Parse(status)));
}
if(!string.IsNullOrWhiteSpace(name))
{
q = Query.And(Query<专家>.Where(m => m.身份信息.姓名 == name));
}
List<Expert> elist = new List<Expert>();
long pageCount = 0;
int cpg = 1;
if (!string.IsNullOrWhiteSpace(Request.QueryString["cp"]))
{
cpg = int.Parse(Request.QueryString["cp"]);
}
string names = name.Trim();
pageCount = 用户管理.计数用户<专家>(0, 0,q) / 15;
if (用户管理.计数用户<专家>(0, 0,q) % 15 > 0)
{
pageCount++;
}
IEnumerable<专家> _zj = 用户管理.查询用户<专家>(15 * (cpg - 1), 15,q);
foreach (var k in _zj)
{
Expert exp = new Expert();
exp.ID = k.Id;
exp.Name=k.身份信息.姓名;
exp.Zjjb=k.身份信息.专家级别.ToString();
exp.Minzu = k.身份信息.民族.ToString();
exp.type = k.身份信息.专家类型.ToString();
exp.Shzt = k.审核数据.审核状态.ToString();
if(k.入库类型!= 入库类型.入库)
{
exp.rk = "未入库";
}
else
{
exp.rk = "已入库";
}
elist.Add(exp);
}
JsonResult json = new JsonResult() { Data = new { expert = elist,pCount=pageCount } };
return Json(json, JsonRequestBehavior.AllowGet);
}
catch
{
JsonResult json = new JsonResult() { Data = new { expert = new List<Expert>(),pCount=0 } };
return Json(json, JsonRequestBehavior.AllowGet);
}
}
private void GridviewBind()
{
string ID = txtexpertID.Text;
string column = Dropcolumn.SelectedValue;
string Name = txtexpertName.Text;
Expert ep = new Expert();
DataSet ds = ep.LoadInfo(ID,column,Name);
GridView1.DataSource = ds;
GridView1.DataBind();
}
public JsonResult AddBehavior(string pid, string name, string behavior)
{
int p = Int32.Parse(pid);
string enterprisecode = StandardDataMapper.Get().QueryForObject<string>("EnterpriseCode.QueryCompanyCode", name);
Expert exp = new Expert();
exp.Behavior = double.Parse(behavior);
exp.EnterpriseCode = enterprisecode;
exp.ProjectID = p;
try
{
new ExpertDao().Insert(exp);
}
catch (Exception e)
{
return Json(e.Message);
}
return Json("更新成功");
}
