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); } }
void ucGridView_Fix_GridViewCommand(object sender, Util_ucGridView.GridViewEventArgs e) { if (e.CommandName == "cmdExportOpenXml" && !string.IsNullOrEmpty(ucGridView_Fix.ucExportOpenXmlPassword)) { Util.MsgBox(string.Format("Excel 密碼為 [<b>{0}</b>] ,請妥善保存!", ucGridView_Fix.ucExportOpenXmlPassword)); } else { Util.MsgBox(string.Format("<b>GridViewCommand</b><hr>Cmd=[{0}]", e.CommandName)); } }
void ucGridView1_GridViewCommand(object sender, Util_ucGridView.GridViewEventArgs e) { DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); DataTable dt = e.DataTable; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { sb.AppendStatement("Update ").Append(_TableName).Append(" set UpdDateTime = ").AppendDbDateTime(); sb.Append(" , UpdUser = "******"UpdUser", UserInfo.getUserInfo().UserID); 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(" Where 0=0 "); sb.Append(Util.getDataQueryKeySQL(_PKList, dt.Rows[i][0].ToString().Split(','))); } DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); try { db.ExecuteNonQuery(sb.BuildCommand(), tx); tx.Commit(); Util.NotifyMsg(RS.Resources.Msg_EditSucceed, Util.NotifyKind.Success); } catch { tx.Rollback(); Util.NotifyMsg(RS.Resources.Msg_EditFail, Util.NotifyKind.Error); } finally { cn.Close(); cn.Dispose(); tx.Dispose(); } } }
/// <summary> /// gvProxyTodoList 呼叫批次審核 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void gvProxyTodoList_GridViewCommand(object sender, Util_ucGridView.GridViewEventArgs e) { DataTable dtVerify = getBatchVerifyData(e.DataTable, gvProxyTodoList.ucDataQryTable); if (dtVerify != null && dtVerify.Rows.Count > 0) { if (e.DataTable.Rows.Count > dtVerify.Rows.Count) { //若[批次審核]筆數少於原始傳遞筆數 2016.08.17 Util.NotifyMsg(string.Format(WorkRS.Resources.FlowVerifyMsg_BatchVerifyCaseAutoIgnore1, e.DataTable.Rows.Count - dtVerify.Rows.Count)); } StartBatchVerify(dtVerify); } else { //2016.08.17 改用 NotifyMsg 方式 Util.NotifyMsg(WorkRS.Resources.FlowVerifyMsg_BatchVerifyCaseNotFound, Util.NotifyKind.Error); } }
void ucGridDetail_GridViewCommand(object sender, Util_ucGridView.GridViewEventArgs e) { if (e.CommandName.Contains("cmdExport")) { ucGridDetail2.Refresh(); return; } //承接明細檔 GridView 線上編輯模式結果 DbHelper db = new DbHelper(_DBName); CommandHelper sb = db.CreateCommandHelper(); DataTable dt = e.DataTable; if (dt == null || dt.Rows.Count <= 0) { Refresh(); } else { for (int i = 0; i < dt.Rows.Count; i++) { switch (e.CommandName) { case "cmdDeleteAll": sb.AppendStatement("Delete PODetail Where 0=0 "); sb.Append(" And POID =").AppendParameter("POID" + i, dt.Rows[i][0].ToString().Split(',')[0]); sb.Append(" And POSeq =").AppendParameter("POSeq" + i, dt.Rows[i][0].ToString().Split(',')[1]); break; case "cmdUpdateAll": sb.AppendStatement("Update PODetail Set POID = POID "); 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(" Where 0=0 "); sb.Append(" And POID =").AppendParameter("POID" + i, dt.Rows[i][0].ToString().Split(',')[0]); sb.Append(" And POSeq =").AppendParameter("POSeq" + i, dt.Rows[i][0].ToString().Split(',')[1]); break; default: break; } } //重新計算加總值 sb.AppendStatement(string.Format(_ReCal_BaseUpdSQL, _MainID)); DbConnection cn = db.OpenConnection(); DbTransaction tx = cn.BeginTransaction(); try { db.ExecuteNonQuery(sb.BuildCommand(), tx); tx.Commit(); Util.NotifyMsg("處理成功", Util.NotifyKind.Success); fmMainRefresh(); } catch { tx.Rollback(); Util.NotifyMsg("處理失敗", Util.NotifyKind.Error); } finally { cn.Close(); cn.Dispose(); tx.Dispose(); } } }