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());
}
}
