[ProducesDefaultResponseType] //其他沒包括在上述設定ProducesResponseType的狀態會使用此屬性
//public IActionResult GetFromEndThreeYard(string StoreNo, [FromBody] string EndThreeYard)
public IActionResult GetFromEndThreeYard([FromBody] StoreAndThree param)
{
// 從Db根據店號及末三碼取得EC資料
//var objList = _ecRepo.GetECDataAsync(StoreNo,EndThreeYard).ToList();
try
{
var objList = _ecRepo.GetECDataAsync(param.StoreNo, param.EndThreeYard).ToList();
if (objList == null | objList.Count() == 0)
{
return(NotFound());
}
//將資料mapping到IFECCUTFDto
var objDto = new List <IFECCUTFDto>();
foreach (var item in objList)
{
objDto.Add(_mapper.Map <IFECCUTFDto>(item));
}
//取得指定頁次的EC資料
ECService service = new ECService();
var objShow = service.SortECData(objDto, ECSort.InDate);
return(Ok(objShow));
}
catch (Exception ex)
{
Serilog.Log.Error($"End GetFromEndThreeYard:{ex.Message}");
return(StatusCode(500, ModelState));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Helper helper = new Helper();
ECService ec = new ECService(Label1.Text);
Guid Pid = Guid.NewGuid();
Guid XiaoYanid = Guid.NewGuid();
XiaoYan x = new XiaoYan();
Person p = new Person();
Account a = new Account();
a.Password = TextBox17.Text;
a.Username = TextBox17.Text;
a.UserID = Guid.NewGuid();
x.isActive = true;
x.isEC = false;
x.Sid = ec._ec.Sid;
x.PID = Pid;
x.XYID = XiaoYanid;
p.PID = Pid;
p.Username = TextBox17.Text;
p.Pname = TextBox13.Text;
p.Pgrade = "XiaoYan";
p.Ppro = TextBox15.Text;
p.Psex = DropDownList1.Text;
p.Ptel = TextBox4.Text;
p.PwechatID = TextBox5.Text;
p.Pemail = TextBox6.Text;
p.Pcontact = TextBox7.Text;
p.Pjob4u = TextBox8.Text;
p.Ptime = helper.string2long(datel.Value);
p.Pwork_years = Convert.ToInt16(TextBox16.Text);
p.Padvs = TextBox9.Text;
p.Pact4water = TextBox10.Text;
p.Pact4fire = TextBox11.Text;
p.Pfield_of_firm = TextBox12.Text;
//XiaoYanDal xd= new XiaoYanDal();
//PersonDal pd= new PersonDal();
//AccountDal ad = new AccountDal();
//ad.Insert(a);
//pd.Insert(p);
//xd.Insert(x);
try
{
ec.insertMem(a, p, x);
Response.Write("<script>alert('插入成功!')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('插入失败!')</script>");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
Helper helper = new Helper();
ECService ec = new ECService(Label1.Text);
xiaoyan = new XiaoYanService(TextBox17.Text);
xiaoyan._xiaoyan.isActive = true;
xiaoyan._xiaoyan.isEC = false;
xiaoyan._xiaoyan.Sid = ec._ec.Sid;
xiaoyan._person.Username = TextBox17.Text;
xiaoyan._person.Pname = TextBox13.Text;
xiaoyan._person.Pgrade = "XiaoYan";
xiaoyan._person.Ppro = TextBox15.Text;
xiaoyan._person.Psex = DropDownList1.Text;
xiaoyan._person.Ptel = TextBox4.Text;
xiaoyan._person.PwechatID = TextBox5.Text;
xiaoyan._person.Pemail = TextBox6.Text;
xiaoyan._person.Pcontact = TextBox7.Text;
xiaoyan._person.Pjob4u = TextBox8.Text;
xiaoyan._person.Ptime = helper.string2long(datel.Value);
xiaoyan._person.Pwork_years = Convert.ToInt16(TextBox16.Text);
xiaoyan._person.Padvs = TextBox9.Text;
xiaoyan._person.Pact4water = TextBox10.Text;
xiaoyan._person.Pact4fire = TextBox11.Text;
xiaoyan._person.Pfield_of_firm = TextBox12.Text;
//XiaoYanDal xd= new XiaoYanDal();
//PersonDal pd= new PersonDal();
//AccountDal ad = new AccountDal();
//ad.Insert(a);
//pd.Insert(p);
//xd.Insert(x);
try
{
ec.updateMem(xiaoyan._person, xiaoyan._xiaoyan);
Response.Write("<script>alert('更新成功!')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('更新失败!')</script>");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
Helper helper = new Helper();
ECService ec = new ECService(Label1.Text);
School sch = new School();
sch.Sid = ec._ec.Sid;
sch.Sname = TextBox4.Text;
sch.Sloc = TextBox5.Text;
try
{
ec.updateSchool(sch);
Response.Write("<script>alert('更新成功!')</script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('更新失败!')</script>");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
Helper helper = new Helper();
ECService ec = new ECService(Label1.Text);
Participant pt = new Participant();
XiaoYanService xy = new XiaoYanService(TextBox5.Text);
pt.Aid = Convert.ToInt32(TextBox4.Text);
pt.Rid = Convert.ToInt32(TextBox6.Text);
pt.PID = xy._person.PID;
pt.PTtime = helper.string2long(datel.Value);
try
{
ec.insertParticipant(pt);
Response.Write("<script>alert('插入成功!')</script>");
}catch (Exception ex)
{
Response.Write("<script>alert('插入失败!')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
ECService ec = new ECService(Label1.Text);
PersonDal pd = new PersonDal();
var pers = pd.GetEntities(m => m.Username == TextBox1.Text);
Person ps = null;
foreach (var per in pers)
{
ps = per;
}
if (ps != null)
{
ec.deleteMem(ps.PID);
Response.Write("<script>alert('删除成功!')</script>");
}
else
{
Response.Write("<script>alert('未找到该用户!')</script>");
}
}
[ProducesDefaultResponseType] //其他沒包括在上述設定ProducesResponseType的狀態會使用此屬性
//public IActionResult GetAll(string StoreNo, [FromBody] ECSort sort = ECSort.InDate)
public IActionResult GetAll([FromBody] StoreAndSort param)
{
try
{
Serilog.Log.Information("Start GetAll");
if (param == null)
{
Serilog.Log.Warning("End GetAll:No content");
return(NoContent());
}
//從Db根據店號取得EC資料
var objList = _ecRepo.GetECDataAsync(param.StoreNo).Result;
if (objList == null || objList.Count() == 0)
{
return(NotFound());
}
//將資料mapping到IFECCUTFDto
var objDto = new List <IFECCUTFDto>();
foreach (var item in objList)
{
objDto.Add(_mapper.Map <IFECCUTFDto>(item));
}
//取得排序後的EC資料
ECService service = new ECService();
var objShow = service.SortECData(objDto, param.Sort);
Serilog.Log.Information("End GetAll");
return(Ok(objShow));
}
catch (Exception ex)
{
Serilog.Log.Error($"End GetAll:{ex.Message}");
return(StatusCode(500, ModelState));
}
}
public BaseRequest(string username, string password)
{
this.service = new ECService(username, password);
service.Username = username;
service.Password = password;
}
