/// <summary>
/// 單筆審核資料
/// </summary>
/// <param name="dataBean">查詢條件</param>
/// <param name="sb">傳入之前組好Command</param>
/// <param name="isReset">StringBuilder Reset or not</param>
public static void GetVisitFormDetailData(OnBizReqAppdOperationBean dataBean, ref StringBuilder sb, bool isReset = false)
{
if (isReset)
{
sb = new StringBuilder();
}
sb.Append("SELECT VF.CompID + '-' + C.CompName AS CompID_Name,VF.WriterID + '-' + VF.WriterName AS WriterID_Name");
sb.Append(" ,CONVERT(NVARCHAR(10),VF.WriteDate,111) AS WriteDate,VF.EmpID + '-' + VF.EmpNameN AS EmpID_NameN,VF.VisitFormNo");
sb.Append(" ,VF.DeptName,VF.TitleName,VF.Position,VF.Tel_1,VF.Tel_2");
sb.Append(" ,CONVERT(NVARCHAR(10),VF.VisitBeginDate,111) + '~' + CONVERT(NVARCHAR(10),VF.VisitEndDate,111) AS VisitDate");
sb.Append(" ,CONVERT(NVARCHAR (5),VF.BeginTime) + '~' + CONVERT(NVARCHAR (5),VF.EndTime) AS VisitTime");
sb.Append(" ,VF.DeputyID + '-' + VF.DeputyName AS DeputyID_Name,VF.LocationType,VF.InterLocationName,VF.ExterLocationName,VF.VisiterName,VF.VisiterTel");
sb.Append(" ,VF.VisitReasonID + '-' + VF.VisitReasonCN AS VisitReason,VF.VisitReasonDesc,VF.LastChgComp + '-' + Co.CompName AS LastChgComp_Name");
sb.Append(" ,VF.LastChgID + '-' + P.NameN AS LastChgID_Nanme,REPLACE(CONVERT(NVARCHAR(19),VF.LastChgDate,111),'-','/') AS LastChgDate");
sb.Append(" ,FlowCaseID ");
sb.Append(" FROM VisitForm VF");
sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Company C ON VF.CompID = C.CompID");
sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Company Co ON VF.CompID = Co.CompID");
sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Personal P ON VF.LastChgComp = P.CompID AND VF.LastChgID = P.EmpID");
sb.Append(" WHERE VF.CompID=@CompID");
sb.Append(" AND VF.EmpID=@EmpID");
sb.Append(" AND VF.WriteDate=@WriteDate");
sb.Append(" AND VF.FormSeq=@FormSeq");
sb.Append(" ; ");
}
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;
}
}
public static bool GetVisitFormDetailData(CheckVisitPKModel model, out OnBizReqAppdOperationBean ReturnDatas, out string msg)
{
bool result = false;
msg = "";
ReturnDatas = new OnBizReqAppdOperationBean();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
OnBizReqAppdOperationBean dataBean = new OnBizReqAppdOperationBean()
{
CompID = model.CompID,
EmpID = model.EmpID,
WriteDate = model.WriteDate,
FormSeq = model.FormSeq
};
StringBuilder sb = new StringBuilder();
OnBizReqAppdOperationSql.GetVisitFormDetailData(dataBean, ref sb);
try
{
ReturnDatas = conn.Query <OnBizReqAppdOperationBean>(sb.ToString(), dataBean).FirstOrDefault();
}
catch (Exception)
{
throw;
}
if (ReturnDatas == null)
{
throw new Exception("查無資料!");
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
