"); var sum_array = this.settings.sum_list.split("^"); for (var sum_cnt=0; sum_cnt < sum_array.length; sum_cnt++) { var field = sum_array[sum_cnt].split("|"); var digits = 3; if (field.length >= 3) digits = field[2]; if (field.length == 4) strBuf.Append(field[0] + " " + Format(FormatNumber(this.dt.sum(field[1]),digits),field[3]) + " "); else strBuf.Append(field[0] + " " + FormatNumber(this.dt.sum(field[1]),digits) + " "); } } return(strBuf); } this.CreateTemplate = function () { var str = new StringBuilder(); var str_row = new StringBuilder(); var str_head = new StringBuilder(); var str_show_fields = ""; var str_column_name = ""; var str_column_title = ""; var i_show_fields = new Array(); if (this.settings.column_mapping.column == "") { var _column_list = ""; for (var col = 0; col < this.dt.getFieldCount(); col++) { var FieldName = this.dt.getFieldName(col); if (_column_list == "") _column_list = FieldName; else _column_list += "," + FieldName; } this.settings.column_mapping.column = _column_list; } if (this.settings.column_mapping.title == "") this.settings.column_mapping.title = this.settings.column_mapping.column str_column_name = this.settings.column_mapping.column.split(","); str_column_title = this.settings.column_mapping.title.split(","); if (str_column_name.length != str_column_title.length) { alert("column_name.length = " + str_column_name.length + "\n column_title.length = " + str_column_name.length + "\n the number of length is not match ..!" ); return (false); } //Start Generate Head Template------------------------------------------------------ str_head.Append("\n"); str_head.Append("
| "); str.Append(" | ||
| "); str.Append(" | "); str.Append(" | "); str.Append(" |
| ");
str.Append("\n | ");
str.Append("\n||
| "); str.Append(" | "); str.Append("
| "); strBuf.Append("\n %this.str_page_list%"); strBuf.Append("\n"); strBuf.Append("\n "); strBuf.Append("\n | "); strBuf.Append("\n%this.str_page_size%" + "\n "); strBuf.Append("\n | "); strBuf.Append("\n%this.str_total_record% %TotalRecord% | "); if (this.selectColumn) { strBuf.Append("\n
scrollLeft = " + document.documentElement.scrollLeft + "\n
scrollTop = " + document.documentElement.scrollTop ); */ if (msg == "") { this.$obj(this.display_name + "_message").innerHTML = ""; hide_div(id_name_msg); } else { setOpacity(id_name_msg, 7) set_id_position(id_name_msg, mouse_point[0]+10, mouse_point[1]-50); show_div(id_name_msg); this.$obj(id_name_msg).innerHTML = msg_templtae; } } this.get_td_tip = function (col_name) { var column_list = this.settings.column_mapping.column.split(","); var tip_list = this.settings.column_mapping.td_tip.split(","); var i_name = column_list.indexOf(col_name); var str = "可對欄位
『%column_name%』
進行編輯"; if (this.settings.column_mapping.td_tip == "") { str = str.ReplaceAll("%column_name%", this.get_column_title(col_name)); if (this.get_allow_edit(col_name) == "0") str = str.ReplaceAll("可對欄位", "不可對欄位"); return (str); } if (i_name != -1) str = tip_list[i_name]; return (str); } this.get_th_tip = function (col_name) { var column_list = this.settings.column_mapping.column.split(","); var tip_list = this.settings.column_mapping.th_tip.split(","); var i_name = column_list.indexOf(col_name); var str = "可根據欄位
『%column_name%』
進行排序"; if (this.settings.column_mapping.th_tip == "") { str = str.ReplaceAll("%column_name%", this.get_column_title(col_name)); return (str); } if (i_name != -1) { str = tip_list[i_name]; //str = tip_list[i_name] + "
(" + this.dt.getFieldType(i_name) + ")"; } return (str); } this.get_column_title = function (col_name) { var column_list = this.settings.column_mapping.column.split(","); var title_list = this.settings.column_mapping.title.split(","); var i_name = column_list.indexOf(col_name); var str_title = ""; if (i_name != -1) str_title = title_list[i_name]; if (str_title == "") str_title = col_name; return (str_title); } this.get_allow_edit = function (col_name) { if (this.settings.column_mapping.allow_edit == "") return ("1"); var column_list = this.settings.column_mapping.column.split(","); var allow_edit_list = this.settings.column_mapping.allow_edit.split(","); var i_name = column_list.indexOf(col_name); var str_allow_edit = ""; if (i_name != -1) str_allow_edit = allow_edit_list[i_name]; if (str_allow_edit == "") str_allow_edit = "0"; return (str_allow_edit); } this.get_format = function (col_name) { if (this.settings.format_list == "") return (""); var column_list = this.settings.column_mapping.column.split(","); var format_list = this.settings.format_list.split("|"); var i_name = column_list.indexOf(col_name); var str_format = ""; if (i_name != -1) str_format = format_list[i_name]; return (str_format); } this.insert_new_row = function () { this.dt.InsertNewRow(0); this.refresh(); } this.add_new_row = function () { this.dt.AddNewRow(); this.refresh(); } this.delete_row = function (row) { try { this.dt.RemoveRowByNumber(row); this.refresh(); } catch (e) { alert(e.Message); } } this.delete_last_row = function () { this.dt.RemoveLastRow(); this.refresh(); } this.show_edit_column = function (row, ColumnName) { var display_edit_column = this.display_name + "_edit_column"; var str_edit_form = this.edit_column_template; var mouse_point = get_mouse_point(); var the_dg = this; var ColumnValue = this.dt.getValueByRow(row, ColumnName); var str_textbox_name = this.control_name + ".edit.column.textbox"; var str_target_name = display_edit_column; var str_trigger_name = "display.%ControlName%.EditColumn.trigger".ReplaceAll("%ControlName%", this.control_name); str_edit_form = str_edit_form.ReplaceAll("%ControlName%", this.control_name); set_id_position(display_edit_column, mouse_point[0]-100, mouse_point[1]); show_div(display_edit_column); //setOpacity(display_edit_column, 8.5); this.$obj(display_edit_column).innerHTML = str_edit_form; this.$obj(this.control_name + ".EditColumn.title").innerHTML = this.str_edit_column_title; this.$obj(this.control_name + ".EditColumn.column_name").innerHTML = this.get_column_title(ColumnName); this.$obj(this.control_name + ".edit.column.row_value").innerHTML = row; this.$obj(this.control_name + ".edit.column.data_type").innerHTML = this.dt.getFieldTypeByName(ColumnName); try { this.oGDD = new GrabDragDropClass(); this.oGDD.initialize(str_target_name, str_trigger_name, "", ""); } catch (e) { alert("this.oGDD = new GrabDragDropClass(); 發生錯誤"); } //設定 文字輸入框 的 『自動改變大小功能』 //function textarea_resize(obj_name, min_col, max_col, min_row, max_row) textarea_resize(str_textbox_name, 10, 80, 4, 40); set_element_value(str_textbox_name , ColumnValue ); set_element_value(this.control_name + ".edit.column.row" , row ); set_element_event(this.control_name + ".edit.column.cancel" , "onclick" , function () { hide_div(display_edit_column); } ); set_element_value(this.control_name + ".edit.column.confirm" , this.edit_column_btn_name_confirm ); set_element_value(this.control_name + ".edit.column.cancel" , this.edit_column_btn_name_cancel ); //設定 資料編輯確認 按鈕 事件 set_element_event(this.control_name + ".edit.column.confirm" , "onclick" , function () { try { var _value = get_element_value(str_textbox_name); if (the_dg.setValue_before(row, ColumnName, _value) == false) return (false); if (the_dg.flg_auto_update == 1) { //alert("the_dg.flg_auto_update = " + the_dg.flg_auto_update); if (the_dg.on_setValue(row, ColumnName, _value) == false) return (false); the_dg.setValue(row, ColumnName, _value); } else { the_dg.setValue(row, ColumnName, _value); the_dg.refresh(); } hide_div(display_edit_column); } catch (e) { alert(the_dg.control_name + " 『資料編輯 確認』錯誤！" + "\n錯誤訊息：" + e.Message ); return (false); } } ); set_element_focus(str_textbox_name); this.$ele(str_textbox_name)[0].onkeydown(); } this.on_dirty = function (row, ColumnName, value) { } this.setValue = function (row, ColumnName, value) { var dirty_flag = false; try { if (this.dt.getValueByRow(row, ColumnName) != value) { this.dt.setValueByRow(row, "_dirty", "Y"); this.dirty = dirty_flag = true; } this.dt.setValueByRow(row, ColumnName, value); if (dirty_flag) this.on_dirty(row, ColumnName, value); } catch (e) { alert("this.dt.setValueByRow(" + row + ", " + ColumnName + ", " + value + ") 發生錯誤 : " + "\n錯誤訊息：" + e.Message ); return (false); } } this.on_setValue = function (row, ColumnName, value) { var dt = new DataTable(); var str_csv_format = new StringBuilder(); var str_id = this.dt.getValueByRow(row, "id") var str_xml_data = ""; with(str_csv_format) { Append("\n" + "0,id,type,name,value,memo"); Append("\n" + "1,System.String,System.String,System.String,System.String,System.String"); Append("\n" + "2,1,KeyValue,id,,欄位Key值"); Append("\n" + "2,2,ColumnValue,,,要準備對資料庫更新的欄位以及欄位值"); Append("\n"); } //alert(str_csv_format.ToString()); with (dt) { ImportCSV(str_csv_format.ToString()); setValueByIndex("id", "1", "value", str_id); setValueByIndex("id", "2", "name", ColumnName); setValueByIndex("id", "2", "value", value); } str_xml_data = dt.ExportXML("UpdateData", "UpdateColumn", "", 0, -1); set_element_value("XML", str_xml_data); try { var str_url = this.str_page_name + "?AJAX=1&do_action=ajax_update_data"; var str_element_list = "XML"; var str_result = ""; str_result = dt.connect(str_url, str_element_list); if (dt.getValue("flg_error") == "1") { alert("資料更新失敗！\n" + dt.getValue("message")); return (false); } else { this.setValue_after(); return (true); } } catch (e) { window.status = "DataGrid.on_setValue() 發生錯誤！" + "\n錯誤訊息：" + e.Message + "\n終止程式執行"; return (false); } } this.setValue_before = function () { } this.setValue_after = function () { } this.data_delete = function (row) { var str_url = ""; var str_element_list = ""; var row_id = this.dt.getValueByRow(row, this.delete_key); var dt = new DataTable(); try { // event.cancelBubble = true; this.cancelBubble(); } catch (e) {}; if (this.data_delete_before() == false) return (false); if (row_id == "") { if (confirm("是否確定刪除這筆資料？")) this.delete_row(row); if (o_EditForm.active == 1) o_EditForm.after_delete_data(); else o_AddNewForm.after_delete_data(); this.data_delete_after(); return (false); } if (confirm("是否確定刪除這筆資料？") == false) return (false); try { str_url = this.str_page_name + "?AJAX=1&do_action=ajax_data_delete&id=" + row_id; dt.connect(str_url, str_element_list); if (dt.getValue("flg_error") == "1") { alert(dt.getValue("message")); return (false); } else { if (o_EditForm.active == 1) o_EditForm.after_delete_data(); else o_AddNewForm.after_delete_data(); this.data_delete_after(); return (false); } } catch (e) { window.status = "DataGrid.data_delete() 發生錯誤" + "\n id = " + row_id + "\n 錯誤訊息：" + e.Message; return (false); } } this.data_delete_before = function () { } this.data_delete_after = function () { } this.cancelBuble = function() { try { var agent = jQuery.browser; if(agent.msie) { event.cancelBubble = true; } else { event.stopPropagation(); } } catch (e) {}; }; this.data_edit = function (row) { window.status = "目前沒有設定功能！"; } this.initialize = function () { } this.td_onblur = function (row, _name, _value) { if (this.td_after_onblur(row, _name, _value)) this.setValue(row, _name, _value); }; this.td_after_onblur = function (row, _name, _value) { return true; }; this.before_display_value = function(dt,buf,FieldName,_value) { }; } -->