protected void dvMaster_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { int SID = Convert.ToInt32(dvMaster.DataKey.Values[0]); string ID = dvMaster.DataKey.Values[1].ToString(); var entity = new TestMasterInfo { SID = SID, ID = ID, NO = e.NewValues["NO"]?.ToString(), Name = e.NewValues["Name"]?.ToString(), Address = e.NewValues["Address"]?.ToString(), Phone = e.NewValues["Phone"]?.ToString(), Birthday = e.NewValues["Birthday"] == null ? default(DateTime?) : Convert.ToDateTime(e.NewValues["Birthday"]) }; var biz = new TestBiz.Master(); int i = biz.Update(entity); if (i == 0) { e.Cancel = true; } else { dvMaster.ChangeMode(DetailsViewMode.ReadOnly); bindMasterDetail(SID, ID); bindMaster(null); } }
protected void fvMaster_ItemUpdating(object sender, FormViewUpdateEventArgs e) { int SID = Convert.ToInt32(fvMaster.DataKey.Values[0]); string ID = fvMaster.DataKey.Values[1].ToString(); var entity = new TestMasterInfo { SID = SID, ID = ID, NO = e.NewValues["NO"]?.ToString(), Name = e.NewValues["Name"]?.ToString(), Address = e.NewValues["Address"]?.ToString(), Phone = e.NewValues["Phone"]?.ToString(), Birthday = string.IsNullOrEmpty(e.NewValues["Birthday"].ToString()) ? default(DateTime?) : Convert.ToDateTime(e.NewValues["Birthday"]), }; var biz = new TestBiz.Master(); int i = biz.Update(entity); if (i == 0) { e.Cancel = true; } else { fvMaster.ChangeMode(FormViewMode.ReadOnly); bindMasterForm(null, entity.ID); bindMaster(null); } }
public ActionResult Insert(TestMasterInfo entity, bool isPartialView = false, string fun = null) { if (!string.IsNullOrEmpty(fun) && fun == "Cancel") { return(Content("")); } var biz = new TestBiz.Master(); if (biz.Load(null, null, entity.NO) != null) { ModelState.AddModelError("NO", "編號已存在"); } if (ModelState.IsValid)//如果必要有值的話就執行 不然就拋回去 { if (biz.Insert(entity) > 0) { //return Read(new TestMasterInfo.Conditions { ID = entity.ID, NO = entity.NO }); string js = string.Format("$('#dumyID').val('{0}');$('#dumyList').submit();$('#dumyRead').submit();", entity.ID); return(JavaScript(js)); } } if (isPartialView) { return(PartialView("~/Views/Shared/Test/_Create.cshtml", entity)); } else { return(View(entity)); } }
protected void fvMaster_ItemUpdating(object sender, FormViewUpdateEventArgs e) { int SID = Convert.ToInt32(fvMaster.DataKey.Values[0]); string ID = fvMaster.DataKey.Values[1].ToString(); var entity = new TestMasterInfo { SID = SID, ID = ID, //NO = e.Values["NO"] == null ? null: e.Values["NO"].ToString(), //原本寫法 NO = e.NewValues["NO"]?.ToString(), //精簡寫法 Name = e.NewValues["Name"]?.ToString(), //Address = e.NewValues["Address"]?.ToString(), Address = e.NewValues["Address"]?.ToString().Split(new string[] { ":::" }, System.StringSplitOptions.None)[0], //Address = ((DropDownList)fvMaster.FindControl("ddlAddress")).SelectedValue, Phone = e.NewValues["Phone"]?.ToString(), Birthday = string.IsNullOrEmpty(e.NewValues["Birthday"].ToString())? default(DateTime?) : Convert.ToDateTime(e.NewValues["Birthday"]) }; var biz = new TestBiz.Master(); int i = biz.Update(entity); if (i == 0) { e.Cancel = true; //失敗的話執行這個 } else { fvMaster.ChangeMode(FormViewMode.ReadOnly); bindMasterForm(null, entity.ID); bindMaster(null); } }
public ActionResult Save(TestMasterInfo entity, bool isPartialView = true, string fun = null) { if (!string.IsNullOrWhiteSpace(fun)) { if (fun == "Cancel") { return(Content("")); } if (fun == "Close") { return(Read(new TestMasterInfo.Conditions { SID = entity.SID, ID = entity.ID })); } } if (ModelState.IsValid) { var biz = new TestBiz.Master(); if (biz.Update(entity) > 0) { //return Read(new TestMasterInfo.Conditions { ID = entity.ID }); string js = string.Format("$('#dumyID').val('{0}');$('#dumyList').submit();$('#dumyRead').submit();", entity.ID); return(JavaScript(js)); } } if (isPartialView) { return(PartialView("~/Views/Shared/Test/_Edit.cshtml", entity)); } else { return(View(entity)); } }
// protected void fvMaster_DoCommand(object sender, EventArgs e) // { // int? SID = null; // string ID = string.Empty; // if (fvMaster.CurrentMode == FormViewMode.Insert) // { // if(gvMaster.SelectedDataKey !=null) // { // SID = Convert.ToInt32(gvMaster.SelectedDataKey.Values[0]); // ID = gvMaster.SelectedDataKey.Values[1].ToString(); // } // } // else // { // SID = Convert.ToInt32(dvMaster.DataKey.Values[0]); // ID = dvMaster.DataKey.Values[1].ToString(); // } // Button btn = (Button)sender; //if (btn.CommandName == "Create") { // //TestBiz biz == new TestBiz.Master(); // // No=e. // } // if (btn.CommandName == "Canel") { // fvMaster.ChangeMode(FormViewMode.ReadOnly); // bindMasterForm(SID, ID); // } // } protected void fvMaster_ItemInserting(object sender, FormViewInsertEventArgs e) { var entity = new TestMasterInfo { //NO = e.Values["NO"] == null ? null: e.Values["NO"].ToString(), //原本寫法 NO = e.Values["NO"]?.ToString(), //精簡寫法 Name = e.Values["Name"]?.ToString(), //Address = e.Values["Address"]?.ToString(), //Address = ((DropDownList)fvMaster.FindControl("ddlAddress")).SelectedValue, Address = e.Values["Address"]?.ToString().Split(new string[] { ":::" }, System.StringSplitOptions.None)[0], Phone = e.Values["Phone"]?.ToString(), Birthday = e.Values[" Birthday"] == null ? default(DateTime?) : Convert.ToDateTime(e.Values["Birthday"]) }; if (Page.IsValid) { var biz = new TestBiz.Master(); int i = biz.Insert(entity); if (i == 0) { e.Cancel = true; //失敗的話執行這個 } else { fvMaster.ChangeMode(FormViewMode.ReadOnly); bindMasterDetails(null, entity.ID); bindMaster(null); upGridView.Update(); } } }
protected void CustomValidator2_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = false; var cv = (CustomValidator)source; var ctl = fvMaster.FindControl(cv.ControlToValidate); if (ctl != null) { var c = (TextBox)ctl; if (!string.IsNullOrEmpty(c.Text)) { var biz = new TestBiz.Master(); var e = biz.Load(null, null, c.Text.Trim()); if (e == null) { args.IsValid = true; } else { cv.ErrorMessage = "編號重複"; } } else { cv.ErrorMessage = "請輸入"; } } }
protected void fvMaster_ItemInserting(object sender, FormViewInsertEventArgs e) { var entity = new TestMasterInfo { NO = e.Values["NO"]?.ToString(), Name = e.Values["Name"]?.ToString(), Address = e.Values["Address"]?.ToString(), Phone = e.Values["Phone"]?.ToString(), Birthday = string.IsNullOrEmpty(e.Values["Birthday"].ToString()) ? default(DateTime?) : Convert.ToDateTime(e.Values["Birthday"]), }; var biz = new TestBiz.Master(); int i = biz.Insert(entity); if (i == 0) { e.Cancel = true; } else { fvMaster.ChangeMode(FormViewMode.ReadOnly); bindMasterForm(null, entity.ID); bindMaster(null); upGVMaster.Update(); } }
protected void bindMasterDetail(int?SID, string ID) { TestBiz.Master biz = new TestBiz.Master(); TestMasterInfo e = biz.Load(SID, ID, null); //單條件查詢(因查詢到後,點選取,只會load一筆出來顯示在Detail) dvMaster.DataSource = (e == null ? new List <TestMasterInfo> { } :new List <TestMasterInfo> { e }); dvMaster.DataBind(); }
protected void bindMasterForm(int?SID, string ID) { TestBiz.Master biz = new TestBiz.Master(); TestMasterInfo e = biz.Load(SID, ID, null); fvMaster.DataSource = e == null ? new List <TestMasterInfo>() : new List <TestMasterInfo> { e }; fvMaster.DataBind(); upFormView.Update(); }
protected void bindMaster(string name) { TestBiz.Master biz = new TestBiz.Master(); var _pagination = pagination; DataTable dt = biz.Load(ref _pagination, Name: name); pagination = _pagination; gvMaster.DataSource = dt; //先存他的SOURCE gvMaster.DataBind(); //在BIND Pager.pagination = pagination; upGridView.Update(); }
protected void bindMaster(string name) { TestBiz.Master biz = new TestBiz.Master(); var _pagination = pagination; DataTable dt = biz.Load(pagination: ref _pagination, Name: name);//多條件查詢 pagination = _pagination; gvMaster.DataSource = dt; gvMaster.DataBind(); Pager.pagination = pagination; Pager.Bind = true; }
public ActionResult Delete(string id) { var biz = new TestBiz.Master(); int i = biz.Delete(SID: null, ID: id, null); if (i > 0) { string js = string.Format("$('#dumyList').submit();$('#divajax').html('');"); return(JavaScript(js)); } else { return(JavaScript("alert('刪除失敗');")); } }
public ActionResult Do(string mode, int?sid = null, string id = null) { switch (mode) { case "Insert": return(Create(true)); case "Edit": var biz = new TestBiz.Master(); return(Edit(biz.Load(SID: sid, ID: id, null))); case "Delete": return(Delete(id)); } return(JavaScript("")); }
protected void bindMasterDetails(int?SID, string ID) { TestBiz.Master biz = new TestBiz.Master(); TestMasterInfo e = biz.Load(SID, ID, null); //防呆 e == null ? new List<TestMasterInfo>() dvMaster.DataSource = e == null ? new List <TestMasterInfo>(): new List <TestMasterInfo> { e }; dvMaster.DataBind(); //gvMaster.DataSource = dt; //gvMaster.DataBind(); }
protected void fvMaster_ItemDeleting(object sender, FormViewDeleteEventArgs e) { int SID = Convert.ToInt32(fvMaster.DataKey.Values[0]); string ID = fvMaster.DataKey.Values[1].ToString(); var biz = new TestBiz.Master(); int i = biz.Delete(SID, ID, null); if (i == 0) { e.Cancel = true; } else { bindMaster(null); bindMasterForm(null, null); } }
// POST api/<controller> public dynamic Post(string id, [FromBody] dynamic value) { bool result = false; if (id == "load") { ModelRequest model = JsonConvert.DeserializeObject <ModelRequest>(JsonConvert.SerializeObject(value)); var biz = new TestBiz.Master(); PageInationInfo pagination = model.pagination; ModelResponse resultLoad = new ModelResponse { conditions = model.conditions }; resultLoad.data = biz.Load(ref pagination, model.conditions).AsEnumerable() .Select(i => new TestMasterInfo { SID = i.Field <int>("SID"), ID = i.Field <string>("ID"), NO = i.Field <string>("NO"), Name = i.Field <string>("Name"), Address = i.Field <string>("Address"), Phone = i.Field <string>("Phone"), Age = i.Field <decimal?>("Age"), Birthday = i.Field <DateTime?>("Birthday"), CreateTime = i.Field <DateTime>("CreateTime"), UpdaueTime = i.Field <DateTime>("UpdaueTime") }) .ToList(); resultLoad.pagination = new ModelResponse.PaginationInfo { Index = pagination.Index, Size = pagination.Size, Total = pagination.Total }; return(resultLoad); } if (id == "create") { TestMasterInfo model = JsonConvert.DeserializeObject <TestMasterInfo>(JsonConvert.SerializeObject(value)); if (ModelState.IsValid) { var biz = new TestBiz.Master(); return(biz.Insert(model)); } return("資料驗證錯誤"); } return(result); }
protected void bindMasterForm(int?SID, string ID) { //var Control = fvMaster.FindControl("ddlAddress"); //if (Control != null) //{ // var ddl = ((DropDownList)Control); // ddl.DataSource = Address(); // ddl.DataBind(); //} TestBiz.Master biz = new TestBiz.Master(); TestMasterInfo e = biz.Load(SID, ID, null); fvMaster.DataSource = e == null ? new List <TestMasterInfo>() : new List <TestMasterInfo> { e }; fvMaster.DataBind(); }
protected void dvMaster_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int SID = Convert.ToInt32(dvMaster.DataKey.Values[0]); string ID = dvMaster.DataKey.Values[1].ToString(); var biz = new TestBiz.Master(); int i = biz.Delete(SID, ID, null); if (i == 0) { e.Cancel = true; //失敗的話執行這個 } else { bindMasterDetails(null, null); bindMaster(null); } }
protected void dvMaster_ItemInserting(object sender, DetailsViewInsertEventArgs e) { var entity = new TestMasterInfo { //NO = e.Values["NO"] == null ? null: e.Values["NO"].ToString(), //原本寫法 NO = e.Values["NO"]?.ToString(), //精簡寫法 Name = e.Values["Name"]?.ToString(), Address = e.Values["Address"]?.ToString(), Phone = e.Values["Phone"]?.ToString(), Birthday = e.Values[" Birthday"] == null ? default(DateTime?) : Convert.ToDateTime(e.Values["Birthday"]) }; var biz = new TestBiz.Master(); int i = biz.Insert(entity); if (i == 0) { e.Cancel = true; //失敗的話執行這個 } else { dvMaster.ChangeMode(DetailsViewMode.ReadOnly); bindMasterDetails(null, entity.ID); bindMaster(null); } //精簡寫法 // var biz = new TestBiz.Master(); // biz.Insert(new TestMasterInfo // { // Name = e.Values["Name"].ToString(), // Address = e.Values["Address"].ToString(), // Phone = e.Values["Phone"].ToString(), // Birthday = Convert.ToDateTime(e.Values["Birthday"]) // } // ); }
protected void dvMaster_ItemInserting(object sender, DetailsViewInsertEventArgs e) { var entity = new TestMasterInfo { NO = e.Values["NO"]?.ToString(), Name = e.Values["Name"]?.ToString(), Address = e.Values["Address"]?.ToString(), Phone = e.Values["Phone"]?.ToString(), Birthday = e.Values["Birthday"]?.ToString() == null ? default(DateTime?) : Convert.ToDateTime(e.Values["Birthday"]?.ToString()) }; var biz = new TestBiz.Master(); int i = biz.Insert(entity); if (i == 0) { e.Cancel = true; } else { dvMaster.ChangeMode(DetailsViewMode.ReadOnly); bindMasterDetail(null, entity.ID); bindMaster(null); } }
// GET api/<controller>/5 public TestMasterInfo Get(string id) { var biz = new TestBiz.Master(); return(biz.Load(SID: null, ID: id, NO: null)); }