protected void Button1_Click(object sender, EventArgs e)
{
Cart cr = new Cart()
{
Description = desp1.Text,
price = itemprc1.Text
};
db.Carts.InsertOnSubmit(cr);
db.SubmitChanges();
}
private void userDataBindingNavigatorSaveItem_Click(object sender, EventArgs e) //tab1中的保存按钮
{
try
{
Validate();
userDataBindingSource.EndEdit();
udc.SubmitChanges();
MessageBox.Show("数据保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void addUser(User user)
{
var dataContext = new UserDataContext();
dataContext.Users.InsertOnSubmit(user);
dataContext.SubmitChanges();
}
internal static void AddUser(string userName, long chatId)
{
try
{
if (GetUser(chatId: chatId)?.ChatId == chatId)
{
return;
}
var user = new User()
{
ChatId = chatId,
UserName = userName,
};
var context = new UserDataContext();
context.Users.InsertOnSubmit(entity: user);
context.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
if (Request.Form["u_username"] == "" || Request.Form["u_password"] == "")
{
runClientScript("addError", "parent.layer.msg('用户名或密码为空！', { time: 2500 });closeLayer();");
return;
}
T_user user = new T_user()
{
u_username = Request.Form["u_username"].Trim(),
u_password = md5.MD5Encrypt(Request.Form["u_password"].Trim(), md5.GetKey()),
u_actor = Request.Form["actor"].Trim()
};
dataContext.T_users.InsertOnSubmit(user);
try
{
dataContext.SubmitChanges();
runClientScript("addOK", "parent.layer.msg('用户添加成功！', { time: 2500 });closeLayer();");
}
catch (Exception catchMessage)
{
runClientScript("addError", "parent.layer.msg('服务器失败：" + catchMessage.Message + "', { time: 2500 });closeLayer();");
}
}
}
public IEnumerable <Detail> Edit(Detail data)
{
List <Detail> results = new List <Detail>();
try
{
using (UserDataContext Context = new UserDataContext())
{
var sql = (from xx in Context.MAS_USERs
where xx.US_ID == data.Ticket_ID
select xx).FirstOrDefault();
sql.A_ID = byte.Parse(data.Dep);
Context.SubmitChanges();
}
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public void deleteUserById(int?id)
{
var dataContext = new UserDataContext();
var query = (from m in dataContext.Users
where m.Id == id
select m);
dataContext.Users.DeleteOnSubmit(query.First());
dataContext.SubmitChanges();
}
public void Run()
{
using (UserDataContext context = new UserDataContext())
{
var tbUser = context.TB_USER.Where(u => u.ID == "U009").First();
context.TB_USER.DeleteOnSubmit(tbUser);
context.SubmitChanges();
}
}
public void Run()
{
using (UserDataContext context = new UserDataContext())
{
var tbUser = context.TB_USER.Where(u => u.ID == "U002").First();
tbUser.AGE = 30;
context.SubmitChanges();
}
}
public void updateUser(int id, User user)
{
var dataContext = new UserDataContext();
var query = (from m in dataContext.Users
where m.Id == id
select m);
query.First().Id = user.Id;
query.First().username = user.username;
query.First().password = user.password;
query.First().type = user.type;
dataContext.SubmitChanges();
}
public JObject AddUser(JObject inputJson)
{
JObject returnObject = new JObject();
try
{
UserDataContext d = new UserDataContext();
tbl_User user = new tbl_User();
user.Name = inputJson["name"].ToString();
user.Email = inputJson["email"].ToString();
user.Address = inputJson["address"].ToString();
user.MobileNo = inputJson["mobile"].ToString();
user.city = inputJson["city"].ToString();
user.isActive = 1;
d.tbl_Users.InsertOnSubmit(user);
d.SubmitChanges();
tbl_login login = new tbl_login();
login.id = user.id;
login.username = inputJson["email"].ToString();
login.password = inputJson["password"].ToString();
d.tbl_logins.InsertOnSubmit(login);
d.SubmitChanges();
returnObject.Add("Status", "Successful");
}
catch (Exception ex)
{
returnObject.Add("Status", "un Successful");
returnObject.Add("Error", ex.Message);
}
return(returnObject);
}
public void Run()
{
using (UserDataContext context = new UserDataContext())
{
TB_USER tb_user = new TB_USER()
{
ID = "U008",
NAME = "Julie",
AGE = 32,
JOB = "디자이너"
};
context.TB_USER.InsertOnSubmit(tb_user);
context.SubmitChanges();
}
}
protected void contactbtn_Click(object sender, EventArgs e)
{
UserDataContext db = new UserDataContext();
ContactUs user = new ContactUs()
{
FirstName = TextBox1.Text,
LastName = TextBox2.Text,
Email = TextBox3.Text,
ContactNo = TextBox4.Text,
Feedback = TextBox5.Text
};
db.ContactUs.InsertOnSubmit(user);
db.SubmitChanges();
TextBox1.Text = TextBox2.Text = TextBox3.Text = TextBox4.Text = TextBox5.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//初始化
string u_id = Request["u_id"] != null ? Request["u_id"].ToString() : "-1";
T_user user = udb.T_users.Where(u => u.u_id == Int32.Parse(u_id)).SingleOrDefault();
if (user == null)
{
return;
}
u_username.Value = user.u_username;
hfU_id.Value = u_id;
runClientScript("radioCheck", "$('input[value=" + user.u_actor + "]').attr(\"checked\",\"true\");");
//$('input[value=user]').attr("checked","true");
}
else
{
//保存
string u_id = hfU_id.Value;
if (Request.Form["u_password"].ToString().Trim() == "")
{
runClientScript("addError", "parent.layer.msg('用户名或密码不能为空！', { time: 2500 });");
return;
}
T_user user = udb.T_users.Where(u => u.u_id == Int32.Parse(u_id)).SingleOrDefault();
if (Request.Form["u_old_password"].ToString() != md5.MD5Decrypt(user.u_password, md5.GetKey()))
{
runClientScript("addError", "parent.layer.msg('原始密码错误！', { time: 2500 });");
return;
}
user.u_password = md5.MD5Encrypt(Request.Form["u_password"].ToString().Trim(), md5.GetKey());
try
{
udb.SubmitChanges();
runClientScript("addOK", "parent.layer.msg('修改成功！', { time: 2500 });closeLayer();");
}
catch (Exception exc)
{
runClientScript("addError", "parent.layer.msg('修改失败：'" + exc.Message + ", { time: 2500 });");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text == "")
{
MessageBox.Show("您必须设定一个有效密码来保护您的信息！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox2.Focus();
}
else
{
UserData newpassword = pass.UserData.Where(p => p.UserName == ChangePasswordZhiName).SingleOrDefault();
if (label2.Text == "原始密码：")
{
newpassword.Password = textBox2.Text;
}
else if (label2.Text == "电子邮箱原始密码：")
{
newpassword.EmailPassword = textBox2.Text;
}
pass.SubmitChanges();
MessageBox.Show("密码修改成功，是否要退出该窗体？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string u_id = context.Request["u_id"] == null || context.Request["u_id"].ToString() == "" ? "-1" : context.Request["u_id"].ToString();
string result = "error";
var user = uDC.T_users.Where(u => u.u_id == Int32.Parse(u_id)).SingleOrDefault();
if (user != null)
{
uDC.T_users.DeleteOnSubmit(user);
}
try
{
uDC.SubmitChanges();
result = "ok";
}
catch (Exception Exc)
{
result = Exc.Message.ToString();
}
context.Response.Write(result);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request.Form["username"] == "" || Request.Form["password"] == "")
{
App_RegisterClientScriptBlock("infoMessage", "错误", "用户名或密码为空！");
return;
}
T_user user = new T_user()
{
u_username = Request.Form["username"],
u_password = md5.MD5Encrypt(Request.Form["password"], md5.GetKey()),
u_actor = Request.Form["select_actor"]
};
dataContext.T_users.InsertOnSubmit(user);
try
{
dataContext.SubmitChanges();
App_RegisterClientScriptBlock("infoMessage", "提示", "用户" + Request.Form["username"] + "添加成功！");
}
catch (Exception catchMessage)
{
App_RegisterClientScriptBlock("infoMessage", "错误", "用户添加失败，请重试！错误代码：" + catchMessage.Message);
}
//ado.net模式
//string sqlAdd = "insert into T_user values(@username,@password,@actor)";
//if (Sqlhelper.ExcuteNonQuery(sqlAdd, new SqlParameter("username", Request.Form["username"]), new SqlParameter("password", md5.MD5Encrypt(Request.Form["password"], md5.GetKey())), new SqlParameter("actor", Request.Form["select_actor"])) > 0)
//{
// App_RegisterClientScriptBlock("infoMessage", "提示", "用户" + Request.Form["username"] + "添加成功！");
//}
//else
//{
// App_RegisterClientScriptBlock("infoMessage", "错误", "用户" + Request.Form["username"] + "添加失败，请重试！");
//}
}
internal static void DeleteUser(long chatId)
{
try
{
if (GetUser(chatId: chatId)?.ChatId == null)
{
return;
}
AccountUtils.GetAccountByUser(chatId: chatId);
var context = new UserDataContext();
var user = context.Users.Single(predicate: e => e.ChatId == chatId);
context.Users.DeleteOnSubmit(entity: user);
context.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
