"); 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]; 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("
![](\"../../../../img/btm/borderTop.jpg\") | ");
str.Append("||
![](\"images/borderLeft.jpg\") | ");
str.Append(" "); str.Append(" | "); str.Append(" |
| ");
str.Append("\n | ");
str.Append("\n||
");
str.Append(" ![](\"../../../../img/btm/borderRightBottom.jpg\") | ");
str.Append("
![](\"../../../../img/btm/preEndBtm-1.gif\") | ")
strBuf.Append("\n ![](\"../../../../img/btm/preBtm-1.gif\") ")
strBuf.Append("\n | ![](\"../../../../img/btm/nextBtm-1.gif\") ")
strBuf.Append("\n | ![](\"../../../../img/btm/nextEndBtm-1.gif\") ")
strBuf.Append("\n | "); 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% | "); 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.setValue = function (row, ColumnName, value) { try { this.dt.setValueByRow(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(19, "id"); var dt = new DataTable(); if (this.data_delete_before() == false) return (false); //if (this.dt.getValueByRow(row, "001hours") != "0" || this.dt.getValueByRow(row, "001hours")!="") //{ // alert("此加班轉補休已被使用，無法刪除修改。請洽系統人員!!"); // o_AddNewForm.active == 1; // // return (true); //} // if (row_id == "") { if (confirm("是否確定刪除這筆資料？")) this.delete_row(row); 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 { 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.data_edit = function (row) { //alert("此加班轉補休已被使用，無法刪除修改。請洽系統人員!!"); //return (false); window.status = "目前沒有設定功能！"; } this.initialize = function () { } this.create_textbox2 = function (dt_row, _name, _value) { var element_param = ""; var dt = this.schema_dt; var row = dt.Search("NAME", _name); var _display_content = ""; var str_NOT_NULL = dt.getValueByRow(row, "NOT_NULL"); var str_NUMERIC = dt.getValueByRow(row, "NUMERIC"); var str_TYPE = dt.getValueByRow(row, "TYPE"); var str_DECIMAL = dt.getValueByRow(row, "DECIMAL"); var element_name = dt.getValueByRow(row, "ELE_NAME"); var str_LEN = dt.getValueByRow(row, "LEN"); // var str_display_name = this.str_display_name; if (element_param == "") { switch (str_TYPE.toUpperCase()) { case "String".toUpperCase(): element_param = "size='%len%' maxlength='%len%'"; element_param = element_param.ReplaceAll("%len%", str_LEN); break; case "Numeric".toUpperCase(): var _length = parseInt(str_LEN, 10); if (str_DECIMAL != "" && str_DECIMAL != "0") _length += 1; element_param = "size='%len%' maxlength='%len%' STYLE='text-align:right'"; element_param = element_param.ReplaceAll("%len%", _length); break; case "Integer".toUpperCase(): element_param = "size='%len%' maxlength='%len%' STYLE='text-align:right'"; element_param = element_param.ReplaceAll("%len%", str_LEN); break; case "Date".toUpperCase(): element_param = "size='%len%' maxlength='%len%'"; element_param = element_param.ReplaceAll("%len%", "8"); break; case "Time".toUpperCase(): element_param = "size='%len%' maxlength='%len%'"; element_param = element_param.ReplaceAll("%len%", "5"); break; case "DateTime".toUpperCase(): element_param = "size='20' maxlength='20'"; break; default: element_param = "size='20' maxlength='20'"; break; } var element_disabled = dt.getValueByRow(row, "ELE_DISABLED"); if (str_NOT_NULL == "1" && element_disabled != "1") { element_param += " style=\"border-color:red\""; } } //str_display_name = str_display_name.ReplaceAll("%namespace%", this.str_namespace); //str_display_name = str_display_name.ReplaceAll("%FormName%", this.str_form_name); //str_display_name = str_display_name.ReplaceAll("%EleName%", element_name); _display_content = ""; // Detail 新增 _display_content += " "; if (str_TYPE.toUpperCase() == "Date".toUpperCase() && element_disabled != "1") { _display_content += "
![](\"/%company_code%/%company_code%/img/Calendar.png\")
";
var mouseover = "";
mouseover += "Calendar.setup(";
mouseover += " {";
mouseover += " inputField : \"%name%\",";
mouseover += " ifFormat : \"%Y%m%d\",";
mouseover += " button : \"%name%.img\" ";
mouseover += " }";
mouseover += ");"
//mouseover += "style=\"cursor:Hand;\"";
_display_content = _display_content.ReplaceAll("%onmouseover%", mouseover);
_display_content = _display_content.ReplaceAll("%company_code%", COMPANY_CODE);
}
element_param += " VALUE='" + _value + "'";
element_param += " onblur=\"JavaScript:%ControlName%.td_onblur(%row%, '%ColumnName%', this.value);\"";
element_param = element_param.ReplaceAll("%row%", dt_row-1);
element_param = element_param.ReplaceAll("%ColumnName%", _name);
element_param = element_param.ReplaceAll("%ControlName%", this.control_name);
_display_content = _display_content.ReplaceAll("%name%", element_name + "_" + dt_row.toString());
_display_content = _display_content.ReplaceAll("%param%", element_param);
return (_display_content);
}
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)
{
};
}
-->