public static OnBizReqAppdOperationModel DetailDataFormat(OnBizReqAppdOperationBean Detaildatas)
{
var result = new OnBizReqAppdOperationModel();
result.CompID_Name = Detaildatas.CompID_Name;
result.EmpID_NameN = Detaildatas.EmpID_NameN;
result.WriteDate = Detaildatas.WriteDate;
result.WriterID_Name = Detaildatas.WriterID_Name;
result.VisitFormNo = Detaildatas.VisitFormNo;
result.DeptName = Detaildatas.DeptName;
result.TitleName = Detaildatas.TitleName;
result.Position = Detaildatas.Position;
result.Tel_1 = Detaildatas.Tel_1;
result.Tel_2 = Detaildatas.Tel_2;
result.VisitDate = Detaildatas.VisitDate;
result.VisitTime = Detaildatas.VisitTime;
result.DeputyID_Name = Detaildatas.DeputyID_Name;
result.LocationType = Detaildatas.LocationType;
result.InterLocationName = Detaildatas.InterLocationName;
result.ExterLocationName = Detaildatas.ExterLocationName;
result.VisiterName = Detaildatas.VisiterName;
result.VisiterTel = Detaildatas.VisiterTel;
result.VisitReason = Detaildatas.VisitReason;
result.VisitReasonDesc = Detaildatas.VisitReasonDesc;
result.LastChgComp_Name = Detaildatas.LastChgComp_Name;
result.LastChgID_Nanme = Detaildatas.LastChgID_Nanme;
result.LastChgDate = Detaildatas.LastChgDate;
result.FlowCaseID = Detaildatas.FlowCaseID;
return(result);
}
protected void subGetData()
{
var isSuccess = false;
var msg = "";
var Detaildatas = new OnBizReqAppdOperationBean();
var ViewData = new OnBizReqAppdOperationModel();
CheckVisitPKModel QueryData = new CheckVisitPKModel();
QueryData.CompID = _SessionCheckVisitPKModel.CompID;
QueryData.EmpID = _SessionCheckVisitPKModel.EmpID;
QueryData.WriteDate = _SessionCheckVisitPKModel.WriteDate;
QueryData.FormSeq = _SessionCheckVisitPKModel.FormSeq;
isSuccess = FN_OnBizReqAppdOperation.GetVisitFormDetailData(QueryData, out Detaildatas, out msg);
if (isSuccess && Detaildatas != null)
{
ViewData = FN_OnBizReqAppdOperation.DetailDataFormat(Detaildatas); //Format Data
lblWriterID_Nametxt.Text = ViewData.WriterID_Name;
lblWriteDatetxt.Text = ViewData.WriteDate;
lblEmpID_NameNtxt.Text = ViewData.EmpID_NameN;
lblVisitFormNotxt.Text = ViewData.VisitFormNo;
lblCompNametxt.Text = ViewData.CompID_Name;
lblDeptNametxt.Text = ViewData.DeptName;
lblTitleNametxt.Text = ViewData.TitleName;
lblPositiontxt.Text = ViewData.Position;
lblTel_1txt.Text = ViewData.Tel_1;
lblTel_2txt.Text = ViewData.Tel_2;
lblVisitDatetxt.Text = ViewData.VisitDate;
lblVisitTimetxt.Text = ViewData.VisitTime;
lblDeputyID_Nametxt.Text = ViewData.DeputyID_Name;
if (ViewData.LocationType.Equals("1"))
{
chkInterLocation.Checked = true;
lblInterLocationNametxt.Text = ViewData.InterLocationName;
}
else if (ViewData.LocationType.Equals("2"))
{
chkExterLocation.Checked = true;
lblExterLocationNametxt.Text = ViewData.ExterLocationName;
}
else if (ViewData.LocationType.Equals("3"))
{
chkInterLocation.Checked = true;
lblInterLocationNametxt.Text = ViewData.InterLocationName;
chkExterLocation.Checked = true;
lblExterLocationNametxt.Text = ViewData.ExterLocationName;
}
lblVisiterNametxt.Text = ViewData.VisiterName;
lblVisiterTeltxt.Text = ViewData.VisiterTel;
lblVisitReasontxt.Text = ViewData.VisitReason;
lblVisitReasonDesctxt.Text = ViewData.VisitReasonDesc;
lblLastChgComptxt.Text = ViewData.LastChgComp_Name;
lblLastChgIDtxt.Text = ViewData.LastChgID_Nanme;
lblLastChgDatetxt.Text = ViewData.LastChgDate;
ViewState["FlowCaseID"] = ViewData.FlowCaseID;
}
}
/// <summary>
/// 載入資料
/// </summary>
private void LoadData()
{
var isSuccess = false;
var msg = "";
var datas = new List <CheckVisitGridDataBean>();
var viewData = new OnBizReqAppdOperationModel()
{
CompID = UserInfo.getUserInfo().CompID,
ValidID = UserInfo.getUserInfo().UserID
};
isSuccess = FN_OnBizReqAppdOperation.GetVisitFormGridViewData(viewData, out datas, out msg);
if (isSuccess && datas != null && datas.Count > 0)
{
viewData.CheckVisitGridDataList = FN_OnBizReqAppdOperation.GridDataFormat(datas); //Format Data
}
gvCheckVisitForm.DataSource = viewData.CheckVisitGridDataList;
gvCheckVisitForm.DataBind();
_OnBizReqAppdOperationModel = viewData;
}
public static bool GetVisitFormGridViewData(OnBizReqAppdOperationModel model, out List <CheckVisitGridDataBean> ReturnDatas, out string msg)
{
bool result = false;
msg = "";
ReturnDatas = new List <CheckVisitGridDataBean>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
CheckVisitGridDataBean dataBean = new CheckVisitGridDataBean()
{
CompID = model.CompID,
ValidID = model.ValidID
};
StringBuilder sb = new StringBuilder();
OnBizReqAppdOperationSql.GetOnBizReqAppdOperationData(dataBean, ref sb);
try
{
ReturnDatas = conn.Query <CheckVisitGridDataBean>(sb.ToString(), dataBean).ToList();
}
catch (Exception)
{
throw;
}
if (ReturnDatas == null || ReturnDatas.Count == 0)
{
throw new Exception("查無資料!");
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
