/// <summary> /// 新增附件 /// </summary> /// <param name="AttachID"></param> /// <param name="attach"></param> /// <returns></returns> public bool InsertAttach(string AttachID, string attach) { bool isSuccess = false; try { DbHelper db = new DbHelper(_overtimeDBName); CommandHelper strSQL = db.CreateCommandHelper(); DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); strSQL.Reset(); strSQL.AppendStatement(" UPDATE AttachInfo SET FileSize = -1, FileBody = null WHERE AttachID = '" + AttachID + "'"); strSQL.AppendStatement(" INSERT INTO AttachInfo (AttachID, SeqNo, FileName, FileExtName, FileSize, AnonymousAccess, UpdUser, UpdDate, UpdTime, FileBody, MD5Check) "); strSQL.Append(" SELECT '" + AttachID + "'"); strSQL.Append(" , SeqNo, FileName, FileExtName, FileSize, AnonymousAccess, UpdUser, UpdDate, UpdTime, FileBody, MD5Check "); strSQL.Append(" FROM AttachInfo "); strSQL.Append(" WHERE AttachID = '" + attach + "'"); using (DataTable dtSchedule = db.ExecuteDataSet(strSQL.BuildCommand()).Tables[0]) { db.ExecuteNonQuery(strSQL.BuildCommand(), tx); tx.Commit(); } } catch (Exception ex) { Debug.Print(">>>InsertAttach: " + ex.Message); LogHelper.WriteSysLog(ex); //將 Exception 丟給 Log 模組 } return(isSuccess); }
/// <summary> /// 值勤班表 /// </summary> /// <param name="compID">公司別</param> /// <param name="empID">員工編號</param> /// <param name="SBStartDate">留守起日</param> /// <param name="SBEndDate">留守迄日</param> /// <param name="errMsg">錯誤訊息</param> /// <param name="schedule">班表</param> /// <returns></returns> private bool GetDutySchedule(string compID, string empID, string SBStartDate, string SBEndDate, out StringBuilder errMsg, out DataTable schedule) { errMsg = new StringBuilder(); schedule = new DataTable(); try { DbHelper db = new DbHelper(_overtimeDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("SELECT"); sb.Append(" WTBeginTime AS BeginTime, WTEndTime AS EndTime "); sb.Append(" FROM EmpGuardWorkTime "); sb.Append(" WHERE 0 = 0 "); sb.Append(" AND CompID = '" + compID + "' "); sb.Append(" AND EmpID = '" + empID + "' "); sb.Append(" AND DutyDate BETWEEN '" + SBStartDate + "' AND '" + SBEndDate + "' "); using (DataTable dtSchedule = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]) { schedule = dtSchedule; return(dtSchedule.Rows.Count > 0 ? true : false); } } catch (Exception ex) { Debug.Print(">>>GetDutySchedule: " + ex.Message); LogHelper.WriteSysLog(ex); //將 Exception 丟給 Log 模組 errMsg.AppendLine(ex.Message); schedule = null; return(false); } }
protected void fmMainRefresh() { DbHelper db = new DbHelper(LegalSample._LegalSysDBName); DataTable dt = null; CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement(string.Format("Select * From {0} Where CaseNo = ", LegalSample._LegalConsultCaseTableName)).AppendParameter("CaseNo", _CurrCaseNo).Append(" and CaseStatus <> 'Draft' "); dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { //DataRow dr = dt.Rows[0]; if (string.IsNullOrEmpty(_CurrFlowID) && string.IsNullOrEmpty(_CurrFlowLogID)) { fmMain.ChangeMode(FormViewMode.ReadOnly); } else { fmMain.ChangeMode(FormViewMode.Edit); } fmMain.DataSource = dt; fmMain.DataBind(); } else { fmMain.Visible = false; labMsg.Visible = true; labMsg.Text = Util.getHtmlMessage(Util.HtmlMessageKind.ParaError, string.Format(RS.Resources.Msg_DataNotFound1, _CurrCaseNo) + "<br><br>"); return; } }
public static void insertFromAdvanceToData(string flow, ref CommandHelper sb) { DbHelper db = new DbHelper(_DBName); CommandHelper sb2 = db.CreateCommandHelper(); Aattendant At = new Aattendant(); string OTTxnID = ""; sb2.Append(" SELECT * FROM OverTimeAdvance WHERE FlowCaseID='" + flow.Substring(0, 14) + "'"); DataTable dtOT = db.ExecuteDataSet(sb2.BuildCommand()).Tables[0]; if (dtOT.Rows.Count > 0) { sb2.Reset(); for (int i = 0; i < dtOT.Rows.Count; i++) { //leo modify 20170110 OTTxnID OTSeqNo int OTSeq = At.QuerySeq("OverTimeDeclaration", dtOT.Rows[i]["OTCompID"].ToString(), dtOT.Rows[i]["OTEmpID"].ToString(), dtOT.Rows[i]["OTStartDate"].ToString()); if (dtOT.Rows[i]["OTSeqNo"].ToString() == "1") { OTTxnID = (UserInfo.getUserInfo().CompID + dtOT.Rows[i]["OTEmpID"].ToString() + Convert.ToDateTime(dtOT.Rows[i]["OTStartDate"]).ToString("yyyyMMdd") + OTSeq.ToString("00")); } sb.Append(" INSERT INTO OverTimeDeclaration(OTCompID,OTEmpID,OTStartDate,OTEndDate,OTSeq,OTTxnID,OTSeqNo,OTFromAdvanceTxnId,DeptID,OrganID,DeptName,OrganName,FlowCaseID,OTStartTime,OTEndTime,OTTotalTime,SalaryOrAdjust,AdjustInvalidDate,AdjustStatus,AdjustDate,MealFlag,MealTime,OTTypeID,OTReasonID,OTReasonMemo,OTAttachment,OTFormNO,OTRegisterID,OTRegisterDate,OTStatus,OTValidDate,OTValidID,OTRejectDate,OTRejectID,OTGovernmentNo,OTSalaryPaid,HolidayOrNot,ProcessDate,OTPayDate,OTModifyDate,OTRemark,KeyInComp,KeyInID,HRKeyInFlag,LastChgComp,LastChgID,LastChgDate,OTRegisterComp) "); sb.Append(" VALUES('" + dtOT.Rows[i]["OTCompID"] + "', '" + dtOT.Rows[i]["OTEmpID"] + "', '" + dtOT.Rows[i]["OTStartDate"] + "', '" + dtOT.Rows[i]["OTEndDate"] + "', '" + OTSeq + "',"); sb.Append(" '" + OTTxnID + "','" + dtOT.Rows[i]["OTSeqNo"] + "','" + dtOT.Rows[i]["OTTxnID"] + "',"); //leo modify 20170110 sb.Append(" '" + dtOT.Rows[i]["DeptID"] + "', '" + dtOT.Rows[i]["OrganID"] + "','" + dtOT.Rows[i]["DeptName"] + "','" + dtOT.Rows[i]["OrganName"] + "',"); sb.Append(" '', "); //流程ID sb.Append(" '" + dtOT.Rows[i]["OTStartTime"] + "', '" + dtOT.Rows[i]["OTEndTime"] + "', '" + dtOT.Rows[i]["OTTotalTime"] + "',"); sb.Append(" '" + dtOT.Rows[i]["SalaryOrAdjust"] + "' ,"); //轉薪資或補休 sb.Append(" '" + Convert.ToDateTime(dtOT.Rows[i]["AdjustInvalidDate"]).ToString("yyyy-MM-dd") + "', "); //失效時間 " '1900-01-01 00:00:00.000', " //失效時間 " '" + dtOT.Rows[i]["AdjustInvalidDate"] + "', " //20170309-leo modify //失效時間 " '" + Convert.ToDateTime(dtOT.Rows[i]["AdjustInvalidDate"]).ToString("yyyy-MM-dd") + "', " sb.Append(" '', "); sb.Append(" '1900-01-01 00:00:00.000', "); sb.Append(" '" + dtOT.Rows[i]["MealFlag"] + "', '" + dtOT.Rows[i]["MealTime"] + "', '" + dtOT.Rows[i]["OTTypeID"] + "',"); sb.Append(" '" + dtOT.Rows[i]["OTReasonID"] + "', "); //加班原因的代號 sb.Append(" '" + dtOT.Rows[i]["OTReasonMemo"] + "', "); sb.Append(" '" + dtOT.Rows[i]["OTAttachment"] + "', '" + dtOT.Rows[i]["OTFormNO"] + "', "); sb.Append(" '" + dtOT.Rows[i]["OTRegisterID"] + "', '" + Convert.ToDateTime(dtOT.Rows[i]["OTRegisterDate"]).ToString("yyyy-MM-dd HH:mm:ss.fff") + "', '1',");//申請單狀態 sb.Append(" '1900-01-01 00:00:00.000', "); sb.Append(" '', "); sb.Append(" '1900-01-01 00:00:00.000', "); sb.Append(" '', "); sb.Append(" '', "); sb.Append(" '0', "); sb.Append(" '" + dtOT.Rows[i]["HolidayOrNot"] + "', "); sb.Append(" '1900-01-01 00:00:00.000', "); sb.Append(" '', "); sb.Append(" '1900-01-01 00:00:00.000', "); sb.Append(" '', "); sb.Append(" '" + dtOT.Rows[i]["LastChgComp"] + "', '" + dtOT.Rows[i]["OTRegisterID"] + "', "); sb.Append(" '', "); sb.Append(" '" + dtOT.Rows[i]["LastChgComp"] + "', "); sb.Append(" '" + dtOT.Rows[i]["OTRegisterID"] + "', "); sb.Append(" '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "',"); sb.Append(" '" + dtOT.Rows[0]["OTRegisterComp"] + "'); "); } } }
private bool boolUpEmpRankID(string AD, string FlowCaseID, string UpEmpRankID) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); DataTable dt; string MapEmpRankID, OTEmpID; sb.Append(" SELECT Top 1 isnull(P.CompID,'') as CompID,isnull(P.RankID,'')as RankID FROM " + CustVerify.ADTable(AD) + " OT "); sb.Append(" LEFT JOIN " + _eHRMSDB + ".[dbo].[Personal] P ON OT.OTEmpID=P.EmpID and OT.OTCompID=P.CompID"); sb.Append(" WHERE OT.FlowCaseID='" + FlowCaseID + "' and OTSeqNo='1'"); dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; if (dt.Rows.Count == 0) { return(false); } MapEmpRankID = RankIDMapping(UserInfo.getUserInfo().CompID, UpEmpRankID); if (MapEmpRankID == "") { return(false); } OTEmpID = RankIDMapping(dt.Rows[0]["CompID"].ToString(), dt.Rows[0]["RankID"].ToString()); if (OTEmpID == "") { return(false); } return(int.Parse(MapEmpRankID) <= int.Parse(OTEmpID) ? true : false); }
/// <summary> /// 取得個人班表 /// </summary> /// <param name="compID">公司別</param> /// <param name="empID">員工編號</param> /// <param name="SBStartDate">留守起日</param> /// <param name="SBEndDate">留守迄日</param> /// <param name="errMsg">錯誤訊息</param> /// <param name="schedule">班表</param> /// <remarks>StartDate:生效日</remarks> /// <returns>bool</returns> private bool GetPersonalSchedule(string compID, string empID, string SBStartDate, string SBEndDate, out StringBuilder errMsg, out DataTable schedule) { errMsg = new StringBuilder(); schedule = new DataTable(); try { DbHelper db = new DbHelper(_overtimeDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement(" SELECT TOP 1 WT.BeginTime, WT.EndTime FROM EmpWorkTimeLog EL "); sb.Append(" LEFT JOIN [" + _eHRMSDB + "].[dbo].[WorkTime] WT ON WT.CompID = EL.CompID AND WT.WTID = EL.WTID "); sb.Append(" WHERE 1 = 1 "); sb.Append(" AND EL.CompID = '" + compID + "' "); sb.Append(" AND EL.EmpID = '" + empID + "' "); sb.Append(" AND CONVERT(VARCHAR, EL.StartDate, 111) <= '" + SBStartDate + "' "); sb.Append(" AND EL.LastChgDate = ( "); sb.Append(" SELECT TOP 1 LastChgDate FROM EmpWorkTimeLog WHERE 1 = 1 "); sb.Append(" AND CONVERT(VARCHAR, StartDate, 111) <= '" + SBStartDate + "' "); sb.Append(" AND ActionFlag <> 'D' "); sb.Append(" AND CompID = '" + compID + "' "); sb.Append(" AND EmpID = '" + empID + "' "); sb.Append(" ORDER BY StartDate DESC, LastChgDate DESC) "); //留守起迄日不同天需再取得迄日的班表 if (!SBStartDate.Equals(SBEndDate)) { sb.Append(" UNION ALL "); sb.Append(" SELECT TOP 1 WT.BeginTime, WT.EndTime FROM EmpWorkTimeLog EL "); sb.Append(" LEFT JOIN [" + _eHRMSDB + "].[dbo].[WorkTime] WT ON WT.CompID = EL.CompID AND WT.WTID = EL.WTID "); sb.Append(" WHERE 1 = 1 "); sb.Append(" AND EL.CompID = '" + compID + "' "); sb.Append(" AND EL.EmpID = '" + empID + "' "); sb.Append(" AND CONVERT(VARCHAR, EL.StartDate, 111) <= '" + SBEndDate + "' "); sb.Append(" AND EL.LastChgDate = ( "); sb.Append(" SELECT TOP 1 LastChgDate FROM EmpWorkTimeLog WHERE 1 = 1 "); sb.Append(" AND CONVERT(VARCHAR, StartDate, 111) <= '" + SBEndDate + "' "); sb.Append(" AND ActionFlag <> 'D' "); sb.Append(" AND CompID = '" + compID + "' "); sb.Append(" AND EmpID = '" + empID + "' "); sb.Append(" ORDER BY StartDate DESC, LastChgDate DESC) "); } using (DataTable dtSchedule = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]) { schedule = dtSchedule; return(dtSchedule.Rows.Count > 0 ? true : false); } } catch (Exception ex) { Debug.Print(">>>GetPersonalSchedule: " + ex.Message); LogHelper.WriteSysLog(ex); //將 Exception 丟給 Log 模組 errMsg.AppendLine(ex.Message); schedule = null; return(false); } }
/// <summary> /// 公司班表 /// </summary> /// <param name="compID">公司別</param> /// <param name="empID">員工編號</param> /// <param name="errMsg">錯誤訊息</param> /// <param name="schedule">班表</param> /// <returns>bool</returns> /// <remarks>目前不曉得該怎取得過去日期的班表,日後可能需要再修改</remarks> private bool GetCompSchedule(string compID, string empID, out StringBuilder errMsg, out DataTable schedule) { errMsg = new StringBuilder(); schedule = new DataTable(); try { DbHelper db = new DbHelper(_eHRMSDB); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("SELECT"); sb.Append(" WT.BeginTime, WT.EndTime, WT.RestBeginTime, WT.RestEndTime "); sb.Append(" FROM PersonalOther PO "); sb.Append(" LEFT JOIN WorkTime WT ON WT.CompID = PO.CompID AND WT.WTID = PO.WTID "); sb.Append(" WHERE 0 = 0 "); sb.Append(" AND PO.CompID = '" + compID + "' "); sb.Append(" AND PO.EmpID = '" + empID + "' "); sb.Append(" ; "); using (DataTable dtSchedule = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]) { schedule = dtSchedule; return(dtSchedule.Rows.Count > 0 ? true : false); } } catch (Exception ex) { Debug.Print(">>>GetCompSchedule: " + ex.Message); LogHelper.WriteSysLog(ex); //將 Exception 丟給 Log 模組 errMsg.AppendLine(ex.Message); schedule = null; return(false); } }
protected void fmMainRefresh() { DbHelper db = new DbHelper(_DBName); DataTable dt = null; if (!string.IsNullOrEmpty(_RuleID)) { CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Select * From AclAdminRuleArea Where RuleID = ").AppendParameter("RuleID", _RuleID); sb.Append(" and AreaID = ").AppendParameter("AreaID", _AreaID); dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; } if (_IsADD) { // Add,Copy fmMain.ChangeMode(FormViewMode.Insert); fmMain.DataSource = dt; fmMain.DataBind(); } else { //Edit fmMain.ChangeMode(FormViewMode.Edit); fmMain.DataSource = dt; fmMain.DataBind(); } Util.setJS_AlertDirtyData(fmMain); }
protected void fmMainRefresh() { if (string.IsNullOrEmpty(_MainID)) { if (_IsADD) { //新增訂單模式 fmMain.ChangeMode(FormViewMode.Insert); //設定唯讀欄位 Util.setReadOnly("txtCompID", true); Util.setReadOnly("txtDeptID", true); Util.setReadOnly("txtUserID", true); Util.setReadOnly("txtCompName", true); Util.setReadOnly("txtDeptName", true); Util.setReadOnly("txtUserName", true); fmMain.DataSource = null; fmMain.DataBind(); } } else { //顯示既有訂單 DbHelper db = new DbHelper(_DBName); DataTable dt = null; CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Select * From PO Where POID = ").AppendParameter("POID", _MainID); dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; fmMain.ChangeMode(FormViewMode.Edit); fmMain.DataSource = dt; fmMain.DataBind(); } Util.setJS_AlertDirtyData(fmMain); }
/// <summary> /// 事先申請到事後申報的送簽單被駁回,須重寫一筆有OTFromAdvanceTxnId的暫存到事後申報,供使用者再送簽 /// </summary> /// <param name="FlowCaseID">事後的</param> /// <param name="strSQL">要組合並一起執行的SQL字串</param> public static void AfterReject_CheckAndInsert(string FlowCaseID, ref CommandHelper strSQL) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); //sb.Append(" SELECT DISTINCT OTFromAdvanceTxnId "); //sb.Append(" FROM OverTimeDeclaration"); //sb.Append(" WHERE FlowCaseID=").AppendParameter("FlowCaseID", FlowCaseID); //sb.Append(" and OTSeqNo='1' "); /*================*/ sb.Append(" SELECT isnull(A.FlowCaseID,'') as AFlowCaseID "); sb.Append(" FROM OverTimeDeclaration D "); sb.Append(" left join OverTimeAdvance A on D.OTFromAdvanceTxnId=A.OTTxnID and A.OTSeqNo='1' and A.OTTxnID!='' "); sb.Append(" WHERE D.FlowCaseID=").AppendParameter("FlowCaseID", FlowCaseID); sb.Append(" and D.OTSeqNo='1' "); DataTable dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; if (dt.Rows.Count > 0) { string AFlowCaseID = dt.Rows[0]["AFlowCaseID"].ToString(); if (!string.IsNullOrEmpty(AFlowCaseID)) { insertFromAdvanceToData(AFlowCaseID, ref strSQL); } } }
/// <summary> /// 確認刪除主檔(自動刪除相關明細檔) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnMainDelete_Click(object sender, EventArgs e) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Delete PO Where POID = ").AppendParameter("POID", _MainID); sb.AppendStatement("Delete PODetail Where POID = ").AppendParameter("POID", _MainID); DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); try { db.ExecuteNonQuery(sb.BuildCommand(), tx); tx.Commit(); _MainID = ""; _DetailSeq = -1; Refresh(true, true); Util.NotifyMsg("主檔及相關明細檔刪除成功", Util.NotifyKind.Success); } catch { tx.Rollback(); Util.NotifyMsg("主檔及相關明細檔刪除失敗", Util.NotifyKind.Error); } finally { cn.Close(); cn.Dispose(); tx.Dispose(); } }
protected void DeleteDocKind(string strKindNo) { if (string.IsNullOrEmpty(strKindNo)) { Util.MsgBox(Util.getHtmlMessage(Util.HtmlMessageKind.ParaDataError)); return; } else { try { //相關連的子類別會由 LegalDocKind 的 Trigger 自動遞迴刪除 DbHelper db = new DbHelper(LegalSample._LegalSysDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Delete LegalDocKind Where KindNo = ").AppendParameter("KindNo", strKindNo); db.ExecuteNonQuery(sb.BuildCommand()); Util.NotifyMsg(RS.Resources.Msg_DeleteSucceed, Util.NotifyKind.Success); } catch (Exception ex) { Util.MsgBox(Util.getHtmlMessage(Util.HtmlMessageKind.Error, ex.ToString())); } } }
protected void btnMainDelete_Click(object sender, EventArgs e) { DbHelper db = new DbHelper(_DBName); try { Dictionary <string, string> dicKey = new Dictionary <string, string>(); dicKey.Clear(); dicKey.Add("RuleID", _RuleID); dicKey.Add("AreaID", _AreaID); AclExpress.IsAclTableLog("AclAdminRuleArea", dicKey, LogHelper.AppTableLogType.Delete); AclExpress.IsAclTableLog("AclAdminRuleAreaGrantList", dicKey, LogHelper.AppTableLogType.Delete); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Delete AclAdminRuleAreaGrantList Where RuleID = ").AppendParameter("RuleID", _RuleID); sb.Append(" and AreaID = ").AppendParameter("AreaID", _AreaID); sb.AppendStatement("Delete AclAdminRuleArea Where RuleID = ").AppendParameter("RuleID", _RuleID); sb.Append(" and AreaID = ").AppendParameter("AreaID", _AreaID); db.ExecuteNonQuery(sb.BuildCommand()); Util.NotifyMsg("刪除成功", Util.NotifyKind.Success); _RuleID = ""; _AreaID = ""; _GrantID = ""; Refresh(true, true); } catch { throw; } }
/// <summary> /// 依照事先事後找尋最近一筆(行政或功能)線資料,依照AD判別 /// </summary> /// <param name="FlowCaseID">FlowCaseID</param> /// <param name="AD">A事先/D事後</param> /// <returns>全部欄位</returns> public static DataTable HROverTimeLogAD(string FlowCaseID, string AD) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append(" select Top 1 * from HROverTimeLog where FlowCaseID='" + FlowCaseID + "' and OTMode='" + AD + "' order by Seq desc"); return(db.ExecuteDataSet(sb.BuildCommand()).Tables[0]); }
void ucGridView1_GridViewCommand(object sender, Util_ucGridView.GridViewEventArgs e) { string strCmd = e.CommandName; DataTable dt = e.DataTable; if (dt != null && dt.Rows.Count > 0) { UserInfo oUser = UserInfo.getUserInfo(); DbHelper db = new DbHelper(LegalSample._LegalSysDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); for (int i = 0; i < dt.Rows.Count; i++) { switch (e.CommandName) { case "cmdUpdateAll": sb.AppendStatement(string.Format("Update {0} Set DocNo = DocNo ", LegalSample._LegalDocTableName)); for (int j = 1; j < dt.Columns.Count; j++) { sb.Append(" ," + dt.Columns[j].ColumnName + " = ").AppendParameter(dt.Columns[j].ColumnName + i, dt.Rows[i][j].ToString()); } sb.Append(" ,UpdUser = "******"UserID", oUser.UserID); sb.Append(" ,UpdUserName = "******"UserName", oUser.UserName); sb.Append(" ,UpdDateTime = ").AppendDbDateTime(); sb.Append(" Where 0=0 "); sb.Append(" And DocNo =").AppendParameter("DocNo" + i, dt.Rows[i][0].ToString().Split(',')[0]); break; default: break; } } DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); try { db.ExecuteNonQuery(sb.BuildCommand(), tx); tx.Commit(); Util.NotifyMsg(RS.Resources.Msg_Succeed, Util.NotifyKind.Success); //處理成功 } catch { tx.Rollback(); Util.NotifyMsg(RS.Resources.Msg_Error, Util.NotifyKind.Error); //處理失敗 } finally { cn.Close(); cn.Dispose(); tx.Dispose(); } } else { Util.MsgBox(RS.Resources.Msg_DataNotFound); } }
//確定更新 protected void btnUpdate_Click(object sender, EventArgs e) { string strCaseNo = ((TextBox)Util.FindControlEx(fmMain, "txtCaseNo")).Text; string strIsUrgent = ((CheckBox)Util.FindControlEx(fmMain, "chkIsUrgent")).Checked ? "Y" : "N"; string strSubject = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucSubject")).ucTextData; string strOutlined = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucOutlined")).ucTextData; string strPropOpinion = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucPropOpinion")).ucTextData; string strExpectCloseDate = ((Util_ucDatePicker)Util.FindControlEx(fmMain, "ucExpectCloseDate")).ucSelectedDate; DbHelper db = new DbHelper(LegalSample._LegalSysDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement(string.Format("Update {0} Set ", LegalSample._LegalConsultCaseTableName)); sb.Append(" IsUrgent = ").AppendParameter("IsUrgent", strIsUrgent); sb.Append(", Subject = ").AppendParameter("Subject", strSubject); sb.Append(", Outlined = ").AppendParameter("Outlined", strOutlined); sb.Append(", PropOpinion = ").AppendParameter("PropOpinion", strPropOpinion); if (!string.IsNullOrEmpty(strExpectCloseDate)) { sb.Append(", ExpectCloseDate = ").AppendParameter("ExpectCloseDate", strExpectCloseDate); } else { sb.Append(", ExpectCloseDate = null "); } UserInfo oUser = UserInfo.getUserInfo(); sb.Append(", UpdDept = ").AppendParameter("Dept", oUser.DeptID); sb.Append(", UpdDeptName = ").AppendParameter("DeptName", oUser.DeptName); sb.Append(", UpdUser = "******"User", oUser.UserID); sb.Append(", UpdUserName = "******"UserName", oUser.UserName); sb.Append(", UpdDateTime = ").AppendDbDateTime(); sb.Append(" Where CaseNo = ").AppendParameter("CaseNo", strCaseNo); try { if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { Util.NotifyMsg(RS.Resources.Msg_EditSucceed, Util.NotifyKind.Success); //資料更新成功 fmMain.DataSource = null; fmMain.DataBind(); divMainFormView.Visible = false; ucGridView1.Refresh(true); divMainGridview.Visible = true; } } catch (Exception ex) { //將 Exception 丟給 Log 模組 LogHelper.WriteSysLog(ex); //資料更新失敗 Util.NotifyMsg(RS.Resources.Msg_EditFail, Util.NotifyKind.Error); } }
public bool IsDataExists(String strTable, String strWhere) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append("Select Count(*) Cnt From " + strTable); sb.Append(" Where 1 = 1 " + strWhere); return(int.Parse(db.ExecuteScalar(sb.BuildCommand()).ToString()) == 0 ? true : false); }
/// <summary> /// 「更新」按鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpdate_Click(object sender, EventArgs e) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); //取得編輯結果 Dictionary <string, string> oEditResult = Util.getControlEditResult(fmMain); //去除不必要欄位 oEditResult.Remove("UpdUser"); oEditResult.Remove("UpdDateTime"); //組合SQL sb.Reset(); sb.AppendStatement("Update ").Append(_TableName).Append(" set "); //處理非鍵值欄位 bool isComma = false; foreach (var pair in oEditResult) { if (!_PKList.Contains(pair.Key)) { switch (pair.Key) { default: if (isComma) { sb.Append(" , "); } else { isComma = true; } sb.Append(pair.Key).Append(" = ").AppendParameter(pair.Key, pair.Value); break; } } } //處理鍵值欄位 sb.Append(" Where 0 = 0 "); sb.Append(Util.getDataQueryKeySQL(_PKList, oEditResult)); //執行SQL if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { Util.NotifyMsg(RS.Resources.Msg_EditSucceed, Util.NotifyKind.Success); //更新成功 } else { Util.NotifyMsg(RS.Resources.Msg_EditFail, Util.NotifyKind.Error); //更新失敗 } divMainFormView.Visible = false; divMainGridview.Visible = true; ucGridView1.Refresh(); }
public static string getFlowLogID(string FlowCustDB, string FlowCaseID) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append(" select FlowLogID from " + FlowCustDB + "FlowFullLog "); sb.Append(" WHERE FlowCaseID =").AppendParameter("FlowCaseID", FlowCaseID); sb.Append(" Order by FlowLogID desc "); return(db.ExecuteScalar(sb.BuildCommand()).ToString()); }
/// <summary> /// 取得收件人相關資料 /// </summary> /// <returns>回傳DataTable[EMail],[Name]</returns> private DataTable getMailInfo(string CompID, string EmpID) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append(" select distinct isnull(C.EMail,'') as EMail,P.Name from " + _eHRMSDB + ".[dbo].Personal P "); sb.Append(" left join " + _eHRMSDB + ".[dbo].[Communication] C on C.IDNo=P.IDNo "); sb.Append(" where P.CompID='" + CompID + "' and P.EmpID='" + EmpID + "' "); return(db.ExecuteDataSet(sb.BuildCommand()).Tables[0]); }
protected void btnMainUpdate_Click(object sender, EventArgs e) { Dictionary <string, string> oDic = Util.getControlEditResult(fmMain); string strFlowStepMailToList = ((Util_ucCheckBoxList)fmMain.FindControl("chkFlowStepMailToList")).ucSelectedIDList; strFlowStepMailToList = strFlowStepMailToList + "," + ((Util_ucTextBox)fmMain.FindControl("txtFlowStepMailToList")).ucTextData; strFlowStepMailToList = Util.getStringJoin(Util.getFixList(strFlowStepMailToList.Split(','))); UserInfo oUser = UserInfo.getUserInfo(); DbHelper db = new DbHelper(FlowExpress._FlowSysDB); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Update FlowStep Set "); sb.Append(" FlowStepName = ").AppendParameter("txtFlowStepName", oDic["txtFlowStepName"]); sb.Append(", FlowStepBatchEnabled = ").AppendParameter("chkFlowStepBatchEnabled", oDic["chkFlowStepBatchEnabled"]); sb.Append(", FlowStepMailToList = ").AppendParameter("FlowStepMailToList", strFlowStepMailToList); sb.Append(", FlowStepCustVerifyURL = ").AppendParameter("txtFlowStepCustVerifyURL", oDic["txtFlowStepCustVerifyURL"]); sb.Append(", FlowStepAttachMaxQty = ").AppendParameter("txtFlowStepAttachMaxQty", oDic["txtFlowStepAttachMaxQty"]); sb.Append(", FlowStepAttachMaxKB = ").AppendParameter("txtFlowStepAttachMaxKB", oDic["txtFlowStepAttachMaxKB"]); sb.Append(", FlowStepAttachTotKB = ").AppendParameter("txtFlowStepAttachTotKB", oDic["txtFlowStepAttachTotKB"]); sb.Append(", FlowStepAttachExtList = ").AppendParameter("txtFlowStepAttachExtList", oDic["txtFlowStepAttachExtList"]); sb.Append(", Remark = ").AppendParameter("txtRemark", oDic["txtRemark"]); sb.Append(", UpdUser = "******"UpdUser", oUser.UserID); sb.Append(", UpdDateTime = ").AppendDbDateTime(); sb.Append(" Where FlowID = ").AppendParameter("txtFlowID", oDic["txtFlowID"]); sb.Append(" And FlowStepID = ").AppendParameter("txtFlowStepID", oDic["txtFlowStepID"]); try { if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { //[更新]資料異動Log LogHelper.WriteAppDataLog(FlowExpress._FlowSysDB, "FlowStep", string.Format("{0},{1}", oDic["txtFlowID"], oDic["txtFlowStepID"]), LogHelper.AppDataLogType.Update, oDic); Util.NotifyMsg(RS.Resources.Msg_EditSucceed, Util.NotifyKind.Success); } } catch (Exception ex) { Util.MsgBox(ex.Message); } DataTable dt = db.ExecuteDataSet(string.Format("Select * From FlowStep Where FlowID = '{0}' and FlowStepID = '{1}';", _FlowID, _FlowStepID)).Tables[0]; if (dt != null && dt.Rows.Count > 0) { fmMain.ChangeMode(FormViewMode.Edit); fmMain.DataSource = dt; fmMain.DataBind(); } RefreshGridView(); }
/// <summary> /// 「新增」按鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnInsert_Click(object sender, EventArgs e) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); //取得 FormView 編輯控制項的編輯結果 Dictionary <string, string> oEditResult = Util.getControlEditResult(fmMain); sb.Reset(); sb.AppendStatement("Insert ").Append(_TableName); sb.Append("( "); sb.Append(" MsgID,MsgKind,IsEnabled,MsgBody,MsgUrl,Remark"); sb.Append(" ,StartDateTime,EndDateTime"); sb.Append(" ,UpdUser,UpdDateTime"); sb.Append(" ) Values ("); sb.Append(" ").AppendParameter("MsgID", oEditResult["MsgID"]); sb.Append(" ,").AppendParameter("MsgKind", oEditResult["MsgKind"]); sb.Append(" ,").AppendParameter("IsEnabled", oEditResult["IsEnabled"]); sb.Append(" ,").AppendParameter("MsgBody", oEditResult["MsgBody"]); sb.Append(" ,").AppendParameter("MsgUrl", oEditResult["MsgUrl"]); sb.Append(" ,").AppendParameter("Remark", oEditResult["Remark"]); if (oEditResult["StartDate"].CompareTo(oEditResult["EndDate"]) > 0) { sb.Append(" ,").AppendParameter("StartDateTime", oEditResult["EndDate"] + " " + oEditResult["EndTime"]); sb.Append(" ,").AppendParameter("EndDateTime", oEditResult["StartDate"] + " " + oEditResult["StartTime"]); } else { sb.Append(" ,").AppendParameter("StartDateTime", oEditResult["StartDate"] + " " + oEditResult["StartTime"]); sb.Append(" ,").AppendParameter("EndDateTime", oEditResult["EndDate"] + " " + oEditResult["EndTime"]); } sb.Append(" ,").AppendParameter("UpdUser", UserInfo.getUserInfo().UserID); sb.Append(" ,").AppendDbDateTime(); sb.Append(" )"); try { if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { Util.NotifyMsg(RS.Resources.Msg_AddSucceed, Util.NotifyKind.Success); //新增成功 divMainFormView.Visible = false; divMainGridview.Visible = true; ucGridView1.Refresh(true); } else { Util.NotifyMsg(RS.Resources.Msg_AddFail, Util.NotifyKind.Error); //新增失敗 } } catch (Exception ex) { Util.MsgBox(ex.Message); } }
//Judy在Aattendant撈取StartDate會有問題改成EndDate 去掉CompID public DataTable QueryData(string strColumn, string strTable, string strWhere) //查詢datatable { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append("SELECT " + strColumn + " FROM " + strTable); sb.Append(" WHERE 1=1 "); sb.Append(strWhere); DataTable dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; return(dt); }
protected void btnVerify_Click(object sender, EventArgs e) { Button oBtn = (Button)sender; //檢查流程意見是否為必需輸入 if (string.IsNullOrEmpty(txtFlowOpinion.ucTextData)) { if (oBtn.CommandArgument.ToUpper() == "Y") { //必需輸入 Util.NotifyMsg(WorkRS.Resources.FlowVerifyMsg_OpinionRequired, Util.NotifyKind.Error); return; } else { //非必需輸入,填入預設意見 txtFlowOpinion.ucTextData = WorkRS.Resources.FlowDefOpinion; } } //將意見暫存,方便審核畫面引用 2017.04.28 FlowExpress oFlow = new FlowExpress(); DbHelper dblog = new DbHelper(oFlow.FlowLogDB); CommandHelper sb = dblog.CreateCommandHelper(); sb.Reset(); sb.AppendStatement(string.Format("Update {0}FlowOpenLog Set ", oFlow.FlowID)); sb.Append(" FlowStepOpinion = ").AppendParameter("FlowStepOpinion", txtFlowOpinion.ucTextData.Replace(",", "''")); sb.Append(" Where FlowLogID = ").AppendParameter("FlowLogID", oFlow.FlowLogID); if (dblog.ExecuteNonQuery(sb.BuildCommand()) <= 0) { Util.NotifyMsg(string.Format(RS.Resources.Msg_Error1, WorkRS.Resources.FlowVerifyTab_SaveFlowTempOpinion), Util.NotifyKind.Error); return; } Dictionary <string, string> dicPara = Util.getRequestQueryString(); if (dicPara.IsNullOrEmpty()) { //缺少流程參數 Util.NotifyMsg(WorkRS.Resources.FlowFullLogMsg_FlowParaError, Util.NotifyKind.Error); return; } else { ucModalPopup1.Reset(); ucModalPopup1.ucFrameURL = string.Format("{0}?FlowID={1}&FlowLogID={2}&FlowStepBtnID={3}", FlowExpress._FlowPageVerifyFrameURL, dicPara["FlowID"], dicPara["FlowLogID"], oBtn.CommandName); //FlowExpress._FlowPageVerifyFrameURL + "?Dummy=" + Util.getRandomCode(); ucModalPopup1.ucPopupWidth = 680; ucModalPopup1.ucPopupHeight = 580; ucModalPopup1.Show(); } }
/// <summary> /// 當收件人Mail是空的,通知預設的HR人員 /// </summary> /// <param name="Subject">主旨</param> /// <param name="Content">內容</param> /// <param name="CompID">收件人公司</param> /// <param name="EmpID">收件人員編</param> /// <returns>是否成功</returns> private bool MailisNull(string Subject, string Content, string CompID, string EmpID) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); DataTable dt; string Title = ""; string Mail = ""; Subject = "FW:" + Subject; sb.Append("select P.CompID,P.EmpID,P.Name,C.EMail "); sb.Append(" from " + _HRDB + ".[dbo].SC_UserGroup UG "); sb.Append("left join " + _eHRMSDB + ".[dbo].Personal P on P.EmpID=UG.UserID and P.CompID=UG.CompID "); sb.Append("left join " + _eHRMSDB + ".[dbo].Communication C on C.IDNo=P.IDNo "); sb.Append("where UG.CompID='SPHBK1' and UG.GroupID='ADM-OT'"); dt = db.ExecuteDataSet(sb.BuildCommand()).Tables[0]; if (dt.Rows.Count == 0) { return(true); } sb.Reset(); DataRow[] dr = dt.Select(); Title = EmpID + "-" + getMailInfo(CompID, EmpID).Rows[0]["Name"].ToString(); Content = "||BM@QuitMailContent99||" + Content; foreach (DataRow row in dt.Rows) { Mail = row["EMail"].ToString(); InsertMailLogCommand("人力資源處", row["CompID"].ToString(), row["EmpID"].ToString(), Mail, Subject, Content, false, ref sb); } try { db.ExecuteNonQuery(sb.BuildCommand()); } catch (Exception ex) { Util.MsgBox("人力資源處E-Mail寄送失敗-" + ex); return(false); } return(true); }
protected void btnMainInsert_Click(object sender, EventArgs e) { //取得表單輸入資料 Dictionary <string, string> oDic = Util.getControlEditResult(fmMain); DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement("Insert AclRule "); sb.Append("( "); sb.Append(" RuleID,RuleName,IsEnabled,Remark,UpdUser,UpdDateTime"); sb.Append(" ) Values ("); sb.Append(" ").AppendParameter("RuleID", oDic["RuleID"]); sb.Append(" ,").AppendParameter("RuleName", oDic["RuleName"]); sb.Append(" ,").AppendParameter("IsEnabled", oDic["IsEnabled"]); sb.Append(" ,").AppendParameter("Remark", oDic["Remark"]); sb.Append(" ,").AppendParameter("UpdUser", UserInfo.getUserInfo().UserID); sb.Append(" ,").AppendDbDateTime(); sb.Append(" )"); if (_IsADD && _RuleID != oDic["RuleID"]) { //Copy Detail sb.AppendStatement(Util.getDataCopySQL(AclExpress._AclDBName, _Main_KeyList, _RuleID.Split(','), oDic["RuleID"].Split(','), "AclRuleExp".Split(','))); } try { if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { _IsADD = false; _RuleID = oDic["RuleID"]; Dictionary <string, string> dicKey = new Dictionary <string, string>(); dicKey.Clear(); dicKey.Add("RuleID", _RuleID); AclExpress.IsAclTableLog("AclRule", dicKey, LogHelper.AppTableLogType.Create); AclExpress.IsAclTableLog("AclRuleExp", dicKey, LogHelper.AppTableLogType.Create); Util.NotifyMsg(string.Format("[{0}]新增成功,可進行後續編修。", oDic["RuleID"]), Util.NotifyKind.Success); Refresh(true, true); } else { Util.NotifyMsg("新增失敗", Util.NotifyKind.Error); } } catch { Util.NotifyMsg("新增錯誤,請檢查資料是否重複", Util.NotifyKind.Error); } }
/// <summary> /// 確認新增明細 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDetailInsert_Click(object sender, EventArgs e) { Dictionary <string, string> oDic = Util.getControlEditResult(fmDetail); if (!string.IsNullOrEmpty(_RuleID)) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); //新增明細 sb.AppendStatement("Insert AclRuleExp "); sb.Append("(RuleID,ChkGrpNo,ChkSeqNo,IsEnabled,ChkOrgUserObjectProperty,ChkOrgUserSW,ChkOrgUserExp,ChkOrgUserPropertyValue,ChkCodeMapSW,ChkCodeMapFldName,Remark,UpdUser,UpdDateTime) "); sb.Append(" Values (").AppendParameter("RuleID", _RuleID); sb.Append(" ,").AppendParameter("ChkGrpNo", oDic["ChkGrpNo"]); sb.Append(" ,").AppendParameter("ChkSeqNo", oDic["ChkSeqNo"]); sb.Append(" ,").AppendParameter("IsEnabled", oDic["IsEnabled"]); sb.Append(" ,").AppendParameter("ChkOrgUserObjectProperty", oDic["ChkOrgUserObjectProperty"]); sb.Append(" ,").AppendParameter("ChkOrgUserSW", oDic["ChkOrgUserSW"]); sb.Append(" ,").AppendParameter("ChkOrgUserExp", oDic["ChkOrgUserExp"]); sb.Append(" ,").AppendParameter("ChkOrgUserPropertyValue", oDic["ChkOrgUserPropertyValue"]); sb.Append(" ,").AppendParameter("ChkCodeMapSW", oDic["ChkCodeMapSW"]); sb.Append(" ,").AppendParameter("ChkCodeMapFldName", oDic["ChkCodeMapFldName"]); sb.Append(" ,").AppendParameter("Remark", oDic["Remark"]); sb.Append(" ,").AppendParameter("UpdUser", UserInfo.getUserInfo().UserID); sb.Append(" ,").AppendDbDateTime(); sb.Append(")"); try { db.ExecuteNonQuery(sb.BuildCommand()); _ChkGrpNo = int.Parse(oDic["ChkGrpNo"]); _ChkSeqNo = int.Parse(oDic["ChkSeqNo"]); Dictionary <string, string> dicKey = new Dictionary <string, string>(); dicKey.Clear(); dicKey.Add("RuleID", _RuleID); dicKey.Add("ChkGrpNo", _ChkGrpNo.ToString()); dicKey.Add("ChkSeqNo", _ChkSeqNo.ToString()); AclExpress.IsAclTableLog("AclRuleExp", dicKey, LogHelper.AppTableLogType.Create); Util.NotifyMsg("條件新增成功", Util.NotifyKind.Success); } catch { Util.NotifyMsg("條件新增失敗", Util.NotifyKind.Error); } Refresh(false, true); } }
/// <summary> /// 確定更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpdate_Click(object sender, EventArgs e) { string strDocNo = ((TextBox)Util.FindControlEx(fmMain, "txtDocNo")).Text; string strIsRelease = ((CheckBox)Util.FindControlEx(fmMain, "chkIsRelease")).Checked ? "Y" : "N"; string strSubject = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucSubject")).ucTextData; string strUsage = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucUsage")).ucTextData; string strKeyword = ((Util_ucCheckBoxList)Util.FindControlEx(fmMain, "ucKeyword")).ucSelectedIDList; string strRemark = ((Util_ucTextBox)Util.FindControlEx(fmMain, "ucRemark")).ucTextData; Util_ucCascadingDropDown oCascading = (Util_ucCascadingDropDown)Util.FindControlEx(fmMain, "ucCascadingKind"); DbHelper db = new DbHelper(LegalSample._LegalSysDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Reset(); sb.AppendStatement(string.Format("Update {0} Set ", LegalSample._LegalDocTableName)); sb.Append(" IsRelease = ").AppendParameter("IsRelease", strIsRelease); sb.Append(", Subject = ").AppendParameter("Subject", strSubject); sb.Append(", Kind1 = ").AppendParameter("Kind1", oCascading.ucSelectedValue01); sb.Append(", Kind2 = ").AppendParameter("Kind2", oCascading.ucSelectedValue02); sb.Append(", Kind3 = ").AppendParameter("Kind3", oCascading.ucSelectedValue03); sb.Append(", Usage = ").AppendParameter("Usage", strUsage); sb.Append(", Keyword = ").AppendParameter("Keyword", strKeyword); sb.Append(", Remark = ").AppendParameter("Remark", strRemark); UserInfo oUser = UserInfo.getUserInfo(); sb.Append(", UpdUser = "******"User", oUser.UserID); sb.Append(", UpdUserName = "******"UserName", oUser.UserName); sb.Append(", UpdDateTime = ").AppendDbDateTime(); sb.Append(" Where DocNo = ").AppendParameter("DocNo", strDocNo); try { if (db.ExecuteNonQuery(sb.BuildCommand()) >= 0) { Util.NotifyMsg(RS.Resources.Msg_EditSucceed, Util.NotifyKind.Success); //資料更新成功 fmMain.DataSource = null; fmMain.DataBind(); divMainFormView.Visible = false; divMainGridview.Visible = true; ucGridView1.Refresh(true); } } catch (Exception ex) { //將 Exception 丟給 Log 模組 LogHelper.WriteSysLog(ex); //資料更新失敗 Util.NotifyMsg(RS.Resources.Msg_EditFail, Util.NotifyKind.Error); } }
private void ClearBtn(string FlowCaseID) { DbHelper db = new DbHelper(Aattendant._AattendantDBName); CommandHelper sb = db.CreateCommandHelper(); sb.Append(" update " + FlowCustDB + "FlowOpenLog "); sb.Append(" set FlowStepBatchEnabled=null "); sb.Append(" ,FlowStepOpinion=null "); sb.Append(" ,FlowStepBtnInfoCultureCode=null "); sb.Append(" ,FlowStepBtnInfoJSON=null "); sb.Append(" where FlowCaseID='" + FlowCaseID + "' "); db.ExecuteNonQuery(sb.BuildCommand()); }
/// <summary> /// 刪除附件 /// </summary> /// <param name="AttachID"></param> /// <returns></returns> public bool DeleteAttach(string AttachID) { bool isSuccess = false; try { DbHelper db = new DbHelper(_overtimeDBName); CommandHelper strSQL = db.CreateCommandHelper(); DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); strSQL.Reset(); strSQL.AppendStatement(" UPDATE AttachInfo SET FileSize = -1, FileBody = null WHERE AttachID = '" + AttachID + "'"); using (DataTable dtSchedule = db.ExecuteDataSet(strSQL.BuildCommand()).Tables[0]) { db.ExecuteNonQuery(strSQL.BuildCommand(), tx); tx.Commit(); try { Util.IsAttachInfoLog("AattendantDB", AttachID, 1, "Delete"); isSuccess = true; } catch (Exception es) { Debug.Print(">>>IsAttachInfoLog: " + es.Message); LogHelper.WriteSysLog(es.Message); //將 Exception 丟給 Log 模組 } } } catch (Exception ex) { Debug.Print(">>>DeleteAttach: " + ex.Message); LogHelper.WriteSysLog(ex); //將 Exception 丟給 Log 模組 } return(isSuccess); }