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