/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Insert(TestMasterInfo entity)
{
var result = 0;
try
{
//int x = 1;
//int y = 0;
//using(TransactionS)
var dbMaster = new TestMasterDB();
int rMaster = dbMaster.Insert(entity);
var dbDetail = new TestDetailDB();
int rDetail = dbDetail.Insert(new TestDetailInfo
{
ID = Guid.NewGuid().ToString(),
MasterID = entity.ID,
A = "asdfad"
});
result = rMaster + rDetail;
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Insert", ErrMsg = ex.Message
});
}
return(result);
}
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_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 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);
}
}
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 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));
}
}
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 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 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();
}
public ActionResult Edit(TestMasterInfo entity, bool isPartialView = true)
{
if (isPartialView)
{
return(PartialView("~/Views/Shared/Test/_Edit.cshtml", entity));
}
else
{
return(View(entity));
}
}
/// <summary>
/// 修改更新
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(TestMasterInfo entity)
{
if (entity == null || string.IsNullOrEmpty(entity.ID))
{
return(0);
}
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(@"
UPDATE [TestMaster]
SET [Name] = @Name
,[Phone] = @Phone
,[Address] = @Address
,[Birthday] = @Birthday
,[Age] = @Age
,[UpdateTime] = @UpdateTime
WHERE ID=@ID
");
//if (SID.HasValue)
//sbCmd.Append("AND SID=@SID ");
//if (!string.IsNullOrEmpty(entity.ID))
//sbCmd.Append("");
//if (!string.IsNullOrEmpty(NO))
//sbCmd.Append("AND NO=@NO ");
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region
//if (SID.HasValue)
// db.AddInParameter(dbCommand, "@SID", DbType.String, SID.Value);
//if (!string.IsNullOrEmpty(entity.ID))
db.AddInParameter(dbCommand, "@ID", DbType.String, entity.ID);
if (!string.IsNullOrEmpty(entity.NO))
{
db.AddInParameter(dbCommand, "@NO", DbType.String, entity.NO);
}
db.AddInParameter(dbCommand, "@Name", DbType.String, entity.Name);
db.AddInParameter(dbCommand, "@Phone", DbType.String, entity.Phone);
db.AddInParameter(dbCommand, "@Address", DbType.String, entity.Address);
db.AddInParameter(dbCommand, "@Birthday", DbType.DateTime, entity.Birthday);
db.AddInParameter(dbCommand, "@Age", DbType.Decimal, entity.Age);
db.AddInParameter(dbCommand, "@UpdateTime", DbType.DateTime, DateTime.Now);
#endregion
return(db.ExecuteNonQuery(dbCommand));
}
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_DataBound(object sender, EventArgs e)
{
var control = fvMaster.FindControl("ddlAddress");
if (control != null)
{
var ddl = ((DropDownList)control);
ddl.DataSource = Address();
ddl.DataBind();
TestMasterInfo drv = (TestMasterInfo)fvMaster.DataItem;
if (drv != null && !DBNull.Value.Equals(drv.Address))
{
ddl.SelectedValue = drv.Address;
}
}
}
// 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();
}
/// <summary>
/// 取一筆資料
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <returns></returns>
public TestMasterInfo Load(int?SID = null, string ID = null, string NO = null)
{
TestMasterInfo result = null;
try
{
var db = new TestMasterDB();
result = db.Load(SID, ID, NO);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Load", ErrMsg = ex.Message
});
}
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(TestMasterInfo entity)
{
var result = 0;
try
{
var db = new TestMasterDB();
result = db.Update(entity);
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Update", ErrMsg = ex.Message
});
}
return(result);
}
public int Insert(TestMasterInfo entity)
{
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(@"
INSERT INTO [TestMaster]
([ID]
,[NO]
,[Name]
,[Phone]
,[Address]
,[Birthday]
,[Age]
,[CreateTime]
,[UpdaueTime])
VALUES
(@ID
,@NO
,@Name
,@Phone
,@Address
,@Birthday
,@Age
,@CreateTime
,@UpdaueTime)
");
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region Add In Parameter
db.AddInParameter(dbCommand, "@ID", DbType.String, entity.ID);
db.AddInParameter(dbCommand, "@NO", DbType.String, entity.NO);
db.AddInParameter(dbCommand, "@Name", DbType.String, entity.Name);
db.AddInParameter(dbCommand, "@Phone", DbType.String, entity.Phone);
db.AddInParameter(dbCommand, "@Address", DbType.String, entity.Address);
db.AddInParameter(dbCommand, "@Birthday", DbType.DateTime, entity.Birthday);
db.AddInParameter(dbCommand, "@Age", DbType.Decimal, entity.Age);
db.AddInParameter(dbCommand, "@CreateTime", DbType.DateTime, entity.CreateTime);
db.AddInParameter(dbCommand, "@UpdaueTime", DbType.DateTime, entity.UpdaueTime);
#endregion
return(db.ExecuteNonQuery(dbCommand));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Insert(TestMasterInfo entity)
{
var result = 0;
try
{
//TestMasterInfo result = null;
//int x = 1;
//int y = 0;
using (TransactionScope scope =
new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted
}))
{
var dbMaster = new TestMasterDB();
int rMaster = dbMaster.Insert(entity);
//decimal z = x / y;
var dbDteail = new TestDeatailDB();
int rDteail = dbDteail.Insert(new TestDeatailInfo
{
ID = Guid.NewGuid().ToString(),
MasterID = entity.ID,
A = "adaasad"
});
result = rMaster + rDteail;
scope.Complete();
}
}
catch (Exception ex)
{
var dbExpLog = new ExpLogDB();
dbExpLog.Insert(new ExpLogInfo {
ClassName = "TestBiz.Master", MethodName = "Insert", ErrMsg = ex.Message
});
}
return(result);
}
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);
}
}
/// <summary>
/// 讀取
/// </summary>
/// <param name="SID"></param>
/// <param name="ID"></param>
/// <param name="NO"></param>
/// <returns></returns>
public TestMasterInfo Load(int?SID = null, string ID = null, string NO = null)
{
if (!SID.HasValue & string.IsNullOrEmpty(ID) & string.IsNullOrEmpty(NO))
{
return(null);
}
TestMasterInfo Result = new TestMasterInfo();
Database db = base.GetDatabase();
StringBuilder sbCmd = new StringBuilder();
sbCmd.Append(" SELECT * FROM [TestMaster] WITH (Nolock) ");
sbCmd.Append(" WHERE (1=1) ");
if (SID.HasValue)
{
sbCmd.Append("AND SID = @SID ");
}
if (!string.IsNullOrEmpty(ID))
{
sbCmd.Append("AND ID = @ID ");
}
if (!string.IsNullOrEmpty(NO))
{
sbCmd.Append("AND NO = @NO");
}
DbCommand dbCommand = db.GetSqlStringCommand(sbCmd.ToString());
#region Add In Parameter
if (SID.HasValue)
{
db.AddInParameter(dbCommand, "@SID", DbType.String, SID.Value);
}
if (!string.IsNullOrEmpty(ID))
{
db.AddInParameter(dbCommand, "@ID", DbType.String, ID);
}
if (!string.IsNullOrEmpty(NO))
{
db.AddInParameter(dbCommand, "@NO", DbType.String, NO);
}
#endregion
try
{
base.ErrFlag = true;
DataTable dtTemp = db.ExecuteDataSet(dbCommand).Tables[0];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
DataRow dr = dtTemp.Rows[0];
Result.SID = Convert.ToInt32(dr["SID"]);
Result.ID = Convert.ToString(dr["ID"]);
Result.NO = Convert.ToString(dr["NO"]);
Result.Name = Convert.ToString(dr["Name"]);
Result.Phone = Convert.ToString(dr["Phone"]);
Result.Address = Convert.ToString(dr["Address"]);
Result.Birthday = dr["Birthday"] == DBNull.Value ? new Nullable <DateTime>() : Convert.ToDateTime(dr["Birthday"]);
Result.Age = dr["Age"] == DBNull.Value ? new Nullable <decimal>() : Convert.ToDecimal(dr["Age"]);
Result.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
Result.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
else
{
Result = null;
}
}
catch (Exception ex)
{
Result = null;
throw; //將原來的 exception 再次的抛出去
}
return(Result);
}
