/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
if (User_Name.Value.ToLower() == "")
{
User_Name.Focus();
errorMsg.InnerHtml = "请输入姓名！";
return;
}
if (User_Account.Value.ToLower() == "")
{
User_Name.Focus();
errorMsg.InnerHtml = "请输入账号/手机号码！";
return;
}
int i = 0;
Hashtable ht_User = new Hashtable();
ht_User["User_Name"] = User_Name.Value;
ht_User["User_Account"] = User_Account.Value;
ht_User["User_Sex"] = User_Sex.Value;
i = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", RequestSession.GetSessionUser().UserId.ToString(), ht_User);
if (i > 0)
{
Session.Abandon(); //取消当前会话
Session.Clear(); //清除当前浏览器所以Session
Response.Write("<script>alert('修改成功,请重新登录');top.location.href='/Frame/login.aspx'</script>");
}
else
{
errorMsg.InnerHtml = "修改登录密码失败";
}
}
private void Create_Click(object sender, EventArgs e)
{
conn = new OracleConnection(ordb);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select username from useraccounts where username=:username";
cmd.Parameters.Add("username", User_Name.Text);
OracleDataReader dr = cmd.ExecuteReader();
int count = 0;
while (dr.Read())
{
count++;
}
dr.Close();
if (count != 0)
{
MessageBox.Show("UserName already taken");
User_Name.Clear();
Password.Clear();
Confirm.Clear();
conn.Close();
}
else if (Password.Text != Confirm.Text)
{
MessageBox.Show("Password doesn't match");
Password.Clear();
Confirm.Clear();
conn.Close();
}
else
{
if (checkBox1.Checked)
{
Global.Admin = 1;
}
OracleCommand cmd2 = new OracleCommand();
cmd2.Connection = conn;
cmd2.CommandText = "insert into UserAccounts values (:username,:name,:password,:email,null,:phone,:flat,:building,:city,:street,:admin)";
cmd2.Parameters.Add("username", User_Name.Text);
cmd2.Parameters.Add("name", Name.Text);
cmd2.Parameters.Add("password", Password.Text);
cmd2.Parameters.Add("email", Email.Text);
cmd2.Parameters.Add("phone", int.Parse(Phone.Text));
cmd2.Parameters.Add("flat", int.Parse(Flat.Text));
cmd2.Parameters.Add("building", int.Parse(building.Text));
cmd2.Parameters.Add("city", City.Text);
cmd2.Parameters.Add("street", int.Parse(Street.Text));
cmd2.Parameters.Add("admin", Global.Admin);
int r = cmd2.ExecuteNonQuery();
MessageBox.Show("UserAccount Created");
conn.Close();
Global.CurrentUser = Name.Text;
Search S = new Search();
S.Show();
}
}
public async Task Turn(User_Name user, int cell, int number)
{
var(world, result) = ArenaEngine.Turn(user, cell, number);
await Clients.All.Turned(result.Turn, result.IsWin, result.IsFail);
if (result.IsWin || result.IsFail)
{
await Clients.All.Game(world.Game);
await Clients.All.Top(world.Top);
}
}
//
// Function: public void Remove_User(int user_type, int index_no)
//
// Arguments: int user_type = Type of user to remove (0 = System User, 1 = Site)
// int index_no = Index number of user to remove from list
//
// Purpose: Removes an entire record of a user at a certain index
//
public void Remove_User(int user_type, int index_no)
{
User_Name.RemoveAt(index_no);
User_ID.RemoveAt(index_no);
Access.RemoveAt(index_no);
if (user_type == 1)
{
Site_User_ID.RemoveAt(index_no);
Site_ID.RemoveAt(index_no);
View_Resources.RemoveAt(index_no);
Add_Resources.RemoveAt(index_no);
Modify_Resources.RemoveAt(index_no);
Del_Resources.RemoveAt(index_no);
View_Tickets.RemoveAt(index_no);
Add_Tickets.RemoveAt(index_no);
}
}
//重置登录表单
private void Resetting_Button(object sender, RoutedEventArgs e)
{
User_Name.Clear();
User_Password.Clear();
}
//
// Function: public void Get_List(int mode, long site_id)
//
// Arguments: int mode = Mode of list to get (0 = All Users, 1 = Only Users For This Site)
// long site_id = Site ID to get the list for (if mode is 1)
//
// Purpose: Gets a list of all users (mode = 0) or ones granted rights to see a site (mode = 1)
//
public void Get_List(int mode, long site_id = 0)
{
List <int> site_users = new List <int>();
Initialize();
// If the user name is blank then get it from the system and try to log in with AD security
string connString = SQLConnString;
// Query the User Database for the user
StringBuilder query = new StringBuilder("SELECT * FROM ");
switch (mode)
{
// All Users
case 0:
query.Append(tblUserInfo);
query.Append(" ORDER BY User_Name");
using (SqlConnection sqlCon = new SqlConnection(connString))
{
sqlCon.Open();
SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon);
using SqlDataReader reader = SqlCmd.ExecuteReader();
while (reader.Read())
{
User_ID.Add((int)reader[0]);
User_Name.Add(String.Format("{0}", reader[1]));
Access.Add((int)reader[2]);
}
sqlCon.Close();
}
break;
// Site_ID users
case 1:
query.Append(tblSiteUsers);
query.Append(" WHERE Site_ID = ");
query.Append(site_id.ToString());
// Get list of User_ID's
using (SqlConnection sqlCon = new SqlConnection(connString))
{
sqlCon.Open();
SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon);
using SqlDataReader reader = SqlCmd.ExecuteReader();
while (reader.Read())
{
Site_User_ID.Add((long)reader[0]);
Site_ID.Add((long)reader[1]);
site_users.Add((int)reader[2]);
User_ID.Add((int)reader[2]);
View_Resources.Add((bool)reader[3]);
Add_Resources.Add((bool)reader[4]);
Modify_Resources.Add((bool)reader[5]);
Del_Resources.Add((bool)reader[6]);
View_Tickets.Add((bool)reader[7]);
Add_Tickets.Add((bool)reader[8]);
Mark_Delete.Add(false);
}
sqlCon.Close();
}
// Convert that list to actual names for display
foreach (int id in site_users)
{
query.Clear();
query.Append("SELECT * FROM ");
query.Append(tblUserInfo);
query.Append(" WHERE User_ID = ");
query.Append(id.ToString());
using (SqlConnection sqlCon = new SqlConnection(connString))
{
sqlCon.Open();
SqlCommand SqlCmd = new SqlCommand(query.ToString(), sqlCon);
using SqlDataReader reader = SqlCmd.ExecuteReader();
while (reader.Read())
{
User_Name.Add(String.Format("{0}", reader[1]));
}
sqlCon.Close();
}
}
break;
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (txt_Apn.Text != "" && txt_Apn.Text.Length > 0)
{
StringBuilder bs = new StringBuilder();
bs.AppendLine("ORDER NO # :" + " " + txt_OrderNo.Text.ToString());
bs.AppendLine("ADDRESS :"+ " " + txt_Address.Text.ToString());
bs.AppendLine("COUNTY :"+ " " + txt_County.Text.ToString());
bs.AppendLine("APN :"+ " " + txt_Apn.Text.ToString());
bs.AppendLine("BORROWER NAME :" + " " + txt_BorrowerName.Text.ToString());
bs.AppendLine("EFFECTIVE DATE :" + " " + txt_Effective_date.Text.ToString());
bs.AppendLine(Environment.NewLine);
bs.AppendLine("Names Run :"+ "" + Environment.NewLine);
bs.AppendLine(txt_Names_Run.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Legal Reference :" + " " + txt_LegalRef.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Data Depth :" + " " + txt_DataDepth.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Open Items:" + "" + Environment.NewLine);
bs.AppendLine("Deeds: " + "" + Environment.NewLine);
bs.AppendLine(txt_Deeds.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Mortgages: " + "" + Environment.NewLine);
bs.AppendLine(txt_Mortgages.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Judgments/Liens: " + "" + Environment.NewLine);
bs.AppendLine(txt_JudgmentLies.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Additional documents : " + "" + Environment.NewLine);
bs.AppendLine(txt_Additional_Documents.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Closed Items:" + "" + Environment.NewLine);
bs.AppendLine(txt_Closed_Items.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("General Comments:" + "" + Environment.NewLine);
bs.AppendLine(txt_Comments.Text.ToString() + "" + Environment.NewLine);
bs.AppendLine("Client instructions/requirements:" + "" + Environment.NewLine);
bs.AppendLine(txt_client_Instructions.Text.ToString() + "" + Environment.NewLine);
if (Directory.Exists(@"C:\OMS_Notes"))
{
src = @"C:\OMS_Notes\Searcher Notes-" + User_Name.ToString() + ".txt";
des = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId + @"\Searcher Notes-" + User_Name.ToString() + ".txt";
src_qc = @"C:\OMS_Notes\Searcher QC Notes-" + User_Name.ToString() + ".txt";
des_qc = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId + @"\Searcher QC Notes-" + User_Name.ToString() + ".txt";
}
else
{
//strisrc1=@"C:\OMS_Notes";
Directory.CreateDirectory(@"C:\OMS_Notes"); //Directory.CreateDirectory(src_qc);
src = @"C:\OMS_Notes\Searcher Notes-" + User_Name.ToString() + ".txt";
des = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId + @"\Searcher Notes-" + User_Name.ToString() + ".txt";
src_qc = @"C:\OMS_Notes\Searcher QC Notes-" + User_Name.ToString() + ".txt";
des_qc = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId + @"\Searcher QC Notes-" + User_Name.ToString() + ".txt";
}
Directory.CreateDirectory(@"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId);
DirectoryEntry de = new DirectoryEntry(@"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + OrderId, "administrator", "password1$");
de.Username = "******";
de.Password = "******";
if (Order_Task == "2")
{
FileStream fs = new FileStream(src, FileMode.Append, FileAccess.Write, FileShare.Write);
fs.Flush();
fs.Close();
File.WriteAllText(src, bs.ToString());
File.Copy(src, des, true);
System.IO.FileInfo f = new System.IO.FileInfo(src);
System.IO.FileInfo f1 = new System.IO.FileInfo(des);
filesize = f.Length;
file_extension = f.Extension;
}
else if (Order_Task == "3")
{
FileStream fs = new FileStream(src_qc, FileMode.Append, FileAccess.Write, FileShare.Write);
fs.Flush();
fs.Close();
File.WriteAllText(src_qc, bs.ToString());
File.Copy(src_qc, des_qc, true);
System.IO.FileInfo f = new System.IO.FileInfo(src_qc);
System.IO.FileInfo f1 = new System.IO.FileInfo(des_qc);
filesize = f.Length;
file_extension = f.Extension;
}
GetFileSize(filesize);
if (Order_Searcherid != 0 && Order_Taskid == int.Parse(Order_Task.ToString()) && Inserted_User_Id != 0)
{
Hashtable htup = new Hashtable();
DataTable dtup = new DataTable();
htup.Add("@Trans", "CHECK_EXIST_DOCUMENT");
htup.Add("@OrderId", OrderId);
if (Order_Task == "2")
{
htup.Add("@Document_Name", "Searcher Notes");
}
else if (Order_Task == "3")
{
htup.Add("@Document_Name", "Search_QC Notes");
}
dtup = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htup);
if (dtup.Rows.Count > 0)
{
//UPDATE_DOCUMENT_PATH
htup.Clear(); dtup.Clear();
htup.Add("@Trans", "UPDATE_DOCUMENT_PATH");
if (Order_Task == "2")
{
htup.Add("@Document_Path", des);
}
else if (Order_Task == "3")
{
htup.Add("@Document_Path", des_qc);
}
htup.Add("@OrderId", OrderId);
dtup = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htup);
}
else
{
//INSERT
htup.Clear(); dtup.Clear();
htup.Add("@Trans", "INSERT");
htup.Add("@Order_ID", int.Parse(OrderId.ToString()));
htup.Add("@File_Size", File_size);
if (Order_Task == "2")
{
htup.Add("@Instuction", "Searcher Notes");
htup.Add("@Document_Path", des);
htup.Add("@Document_Name", "Searcher Notes");
}
else if (Order_Task == "3")
{
htup.Add("@Instuction", "Search_QC Notes");
htup.Add("@Document_Path", des_qc);
htup.Add("@Document_Name", "Search_QC Notes");
}
htup.Add("@Extension", file_extension);
htup.Add("@Inserted_By", User_Id);
htup.Add("@Inserted_date", DateTime.Now);
dtup = dataaccess.ExecuteSP("Sp_Document_Upload", htup);
}
//update the order search notes record
htup.Clear(); dtup.Clear();
htup.Add("@Trans", "UPDATE_NOTES");
htup.Add("@Order_Searcher_Notes_Id", Order_Searcherid);
htup.Add("@Names_Run", txt_Names_Run.Text);
htup.Add("@Effective_Date", txt_Effective_date.Text);
htup.Add("@Legal_Reference", txt_LegalRef.Text);
htup.Add("@Data_Depth", txt_DataDepth.Text);
htup.Add("@Deeds", txt_Deeds.Text);
htup.Add("@Mortgages", txt_Mortgages.Text);
htup.Add("@Judgments_Liens", txt_JudgmentLies.Text);
htup.Add("@Closed_Items", txt_Closed_Items.Text);
htup.Add("@General_Comments", txt_Comments.Text);
htup.Add("@Client_Instruction", txt_client_Instructions.Text);
htup.Add("@Additional_Documents", txt_Additional_Documents.Text);
htup.Add("@Modified_by", User_Id);
//htup.Add("@OrderId", OrderId);
dtup = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htup);
MessageBox.Show("Record Updated Successfully");
}
else if (Order_Taskid != int.Parse(Order_Task.ToString()))
{
Hashtable htin = new Hashtable();
DataTable dtin = new DataTable();
htin.Add("@Trans", "CHECK_EXIST_DOCUMENT");
htin.Add("@OrderId", OrderId);
if (Order_Task == "2")
{
htin.Add("@Document_Name", "Searcher Notes");
}
else if (Order_Task == "3")
{
htin.Add("@Document_Name", "Search_QC Notes");
}
dtin = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htin);
if (dtin.Rows.Count > 0)
{
//UPDATE_DOCUMENT_PATH
htin.Clear(); dtin.Clear();
htin.Add("@Trans", "UPDATE_DOCUMENT_PATH");
if (Order_Task == "2")
{
htin.Add("@Document_Path", des);
}
else if (Order_Task == "3")
{
htin.Add("@Document_Path", des_qc);
}
htin.Add("@OrderId", OrderId);
dtin = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htin);
}
else
{
//INSERT
htin.Clear(); dtin.Clear();
htin.Add("@Trans", "INSERT");
htin.Add("@Order_ID", int.Parse(OrderId.ToString()));
htin.Add("@File_Size", File_size);
if (Order_Task == "2")
{
htin.Add("@Instuction", "Searcher Notes");
htin.Add("@Document_Path", des);
htin.Add("@Document_Name", "Searcher Notes");
}
else if (Order_Task == "3")
{
htin.Add("@Instuction", "Search_QC Notes");
htin.Add("@Document_Path", des_qc);
htin.Add("@Document_Name", "Search_QC Notes");
}
htin.Add("@Extension", file_extension);
htin.Add("@Inserted_By", User_Id);
htin.Add("@Inserted_date", DateTime.Now);
dtin = dataaccess.ExecuteSP("Sp_Document_Upload", htin);
}
htin.Clear(); htin.Clear();
//insert
htin.Add("@Trans", "INSERT_NOTES");
htin.Add("@Names_Run", txt_Names_Run.Text);
htin.Add("@Effective_Date", txt_Effective_date.Text);
htin.Add("@Legal_Reference", txt_LegalRef.Text);
htin.Add("@Data_Depth", txt_DataDepth.Text);
htin.Add("@Deeds", txt_Deeds.Text);
htin.Add("@Mortgages", txt_Mortgages.Text);
htin.Add("@Judgments_Liens", txt_JudgmentLies.Text);
htin.Add("@General_Comments", txt_Comments.Text);
htin.Add("@Closed_Items", txt_Closed_Items.Text);
htin.Add("@Inserted_by", User_Id);
htin.Add("@OrderId", OrderId.ToString());
htin.Add("@Order_Task_Id", int.Parse(Order_Task.ToString()));
htin.Add("@Client_Instruction", txt_client_Instructions.Text);
htin.Add("@Additional_Documents", txt_Additional_Documents.Text);
dtin = dataaccess.ExecuteSP("Sp_Order_Searcher_Notes", htin);
//Update APN
MessageBox.Show("Record Inserted Successfully");
}
Hashtable htapn = new Hashtable();
DataTable dtapn = new DataTable();
htapn.Add("@Trans", "UPDATE_APN");
htapn.Add("@APN", txt_Apn.Text);
htapn.Add("@Order_ID", OrderId);
dtapn = dataaccess.ExecuteSP("Sp_Order", htapn);
}
else
{
MessageBox.Show("Please Enter APN Number");
txt_Apn.Focus();
}
}
