public HttpResponseMessage Put(BD03AddModel model, string Org, string Dept, string User_id) { try { service.SaveUser(model, Org, Dept, User_id); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString())); } }
public HttpResponseMessage Post(BD03AddModel model) { try { service.addBD03(model); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message.ToString())); } }
/// <summary>新增BD03使用者資料</summary> public void addBD03(BD03AddModel viewmodel) { bd03_user _model = new bd03_user(); _model.user_org = viewmodel.user_org; _model.user_dept = viewmodel.user_dept; _model.user_id = viewmodel.user_id; _model.user_name = viewmodel.user_name; _model.user_pwd = viewmodel.user_pwd; _model.user_sex = viewmodel.user_sex; _model.user_mail = viewmodel.user_mail; _model.user_tel = viewmodel.user_tel; _model.auth_type = viewmodel.auth_type; _model.usable = viewmodel.usable; _model.make_date = DateTime.Now; _model.modify_date = DateTime.Now; _model.maker_id = "evan"; db.Insert(_model); }
/// <summary>修改使用者資料</summary> public void SaveUser(BD03AddModel viewmodel, string user_org, string user_dept, string user_id) { var dbresult = db.GetByUserInfo(user_org, user_dept, user_id); Delete(user_org, user_dept, user_id); dbresult.user_org = viewmodel.user_org; dbresult.user_dept = viewmodel.user_dept; dbresult.user_id = viewmodel.user_id; dbresult.user_name = viewmodel.user_name; dbresult.user_pwd = viewmodel.user_pwd; dbresult.user_sex = viewmodel.user_sex; dbresult.user_mail = viewmodel.user_mail; dbresult.user_tel = viewmodel.user_tel; dbresult.auth_type = viewmodel.auth_type; dbresult.usable = viewmodel.usable; dbresult.modify_date = DateTime.Now; db.Insert(dbresult); //db.Update(dbresult); }
/// <summary>取得特定使用者資料</summary> public BD03AddModel getUser(string user_org, string user_dept, string user_id) { List <bd03_user> model = new List <bd03_user>(); //var dbresult = db.Get().ToList(); var dbresult = db.GetByUserInfo(user_org, user_dept, user_id); //int i = 0; bool isfound = false; bd03_user result = new bd03_user(); //whil;le (i < dbresult.Count) //{ if (dbresult.user_org.Trim() == user_org && dbresult.user_dept.Trim() == user_dept && dbresult.user_id.Trim() == user_id) { result = dbresult; isfound = true; } // i++; //} if (isfound) { BD03AddModel _model = new BD03AddModel(); _model.user_org = result.user_org.Trim(); _model.user_dept = result.user_dept.Trim(); _model.user_id = result.user_id.Trim(); _model.user_name = result.user_name.Trim(); _model.user_pwd = result.user_pwd.Trim(); _model.user_sex = result.user_sex.Trim(); _model.user_mail = result.user_mail.Trim(); _model.user_tel = result.user_tel.Trim(); _model.auth_type = result.auth_type; _model.usable = result.usable; return(_model); } else { return(new BD03AddModel()); } }