void cmdFinishTask_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e) { TreeNode selectedNode = this.tvTask.SelectedNode; if (selectedNode == null) { XMessageBox.ShowError("请选择要结束的任务!"); return; } XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo; if (taskInfo == null) { XMessageBox.ShowError("请选择要结束的任务!"); return; } if (XMessageBox.ShowQuestion("确定要结束选中的任务吗?") == System.Windows.Forms.DialogResult.No) { return; } if (this.m_TaskBusiness.UpdateTaskStatus("结束", taskInfo.ID)) { XMessageBox.ShowRemindMessage("结束任务成功!"); } else { XMessageBox.ShowError("结束任务失败!"); } }
void cmdDownload_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e) { if (this.tvTask.SelectedNode != null) { XTaskFilesInfo model = this.tvTask.SelectedNode.Tag as XTaskFilesInfo; string mainId = model.RID; bool isExist = this.m_FileAttachBusiness.IsFileExist(mainId); if (!isExist) { XMessageBox.ShowError("未找到附件!"); return; } FolderBrowserDialog fbd = new FolderBrowserDialog(); if (fbd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string fileName = this.m_FileAttachBusiness.DownloadFile(mainId, fbd.SelectedPath); if (fileName != string.Empty) { XMessageBox.ShowRemindMessage("下载完成!"); } else { XMessageBox.ShowError("下载失败!"); } } } else { XMessageBox.ShowError("请选择要下载附件的记录!"); } }
public static int SaveOptions(this options options_to_save, SccompDbf selected_comp) { try { using (LocalDbEntities db = DBX.DataSet(selected_comp)) { options option = db.options.Where(o => o.key == options_to_save.key).FirstOrDefault(); if (option != null) // update { option.value_datetime = options_to_save.value_datetime; option.value_num = options_to_save.value_num; option.value_str = options_to_save.value_str; return(db.SaveChanges()); } else // add new { db.options.Add(options_to_save); return(db.SaveChanges()); } } } catch (Exception ex) { XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return(0); } }
/// <summary> /// 2016-11-30,mxj,add /// </summary> /// <returns></returns> protected override bool ValidateDeleteCustom() { if (this.grdData.CurrentRow.IsChecked) { XTemplateBillInfo curr = this.grdData.CurrentRow.DataRow as XTemplateBillInfo; DataTable dt = new DataTable(); string sql = "select Rno, Bno from TemplateBill where Rno='" + curr.Rno + "' and Bno='" + curr.Bno + "'"; dt = SQLHelper.GetDataSet(sql); if (dt != null) { //XMessageBox.ShowRemindMessage("数据提取异常!"); if (dt.Rows.Count <= 1) { if (XMessageBox.ShowQuestion("不存在重复项,是否继续删除!", "提示") == System.Windows.Forms.DialogResult.Yes) { return(true); } else { return(false); } } } } else { return(false); } return(true); }
/// <summary> /// 菜单单击事件 /// </summary> /// <param name="menuInfo"></param> /// <param name="e"></param> protected virtual void menuFolderTool_MenuClickEvent(XMenuInfo menuInfo, EventArgs e) { try { frmBase frm = Assembly.Load(menuInfo.NameSpace).CreateInstance(menuInfo.FullAssembleName) as frmBase; if (frm == null) { XMessageBox.ShowError("该功能未实现或者实现的接口不正确!"); return; } if (menuInfo.IsDialogModel) { frm.StartPosition = FormStartPosition.CenterParent; frm.ShowDialog(); } else { this.ShowTabbedMdi(frm); } } catch (Exception ex) { XMessageBox.ShowError(ex.Message); XErrorLogTool.WriteLog(ex.ToString()); } }
private void SetDropdownItem() { this.cShType._Items.Add(new XDropdownListItem { Text = "บุคคลธรรมดา", Value = SHARE_HOLDER_TYPE.P.ToString() }); this.cShType._Items.Add(new XDropdownListItem { Text = "นิติบุคคล", Value = SHARE_HOLDER_TYPE.C.ToString() }); string nationality_file_path = AppDomain.CurrentDomain.BaseDirectory + @"Template\nationality.json"; if (File.Exists(nationality_file_path)) { JsonConvert.DeserializeObject <List <nationality_VM> >(File.ReadAllText(nationality_file_path)).OrderBy(n => n.nationality_code).ToList().ForEach(n => { this.cNationality._Items.Add(new XDropdownListItem { Text = n.nationality_code + " : " + n.nationality_name_th, Value = n }); }); } else { XMessageBox.Show("ค้นหาแฟ้ม nationality.json ไม่พบ", "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return; } }
private void btnExport_Click(object sender, EventArgs e) { try { SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "Excel文件(*.xls)|*.xls"; if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { this.grdExporter.SheetName = this.Text; //this.grdData.RootTable.Columns["select"].Visible = false; System.IO.Stream stream = new System.IO.FileStream(sfd.FileName, System.IO.FileMode.CreateNew); this.grdExporter.Export(stream); stream.Close(); //this.grdData.RootTable.Columns["select"].Visible = true; XMessageBox.ShowRemindMessage("导出完成!"); } } catch (Exception ex) { XErrorLogTool.WriteLog(ex.ToString()); XMessageBox.ShowError("导出失败!"); } finally { //this.grdData.RootTable.Columns["select"].Visible = true; } }
/// <summary> /// 检查是否有复选框选中的记录 /// </summary> /// <returns></returns> protected virtual bool IsDetailSelectedRowByCheckBox() { int selectedRowsCount = 0; m_SelectedDeleteDetailIds = ""; m_SelectedDetailModels = new List <XModelBase>(); foreach (Janus.Windows.GridEX.GridEXRow gridRow in this.grdDetail.GetRows()) { if (gridRow.IsChecked) { selectedRowsCount += 1; XModelBase currentModel = gridRow.DataRow as XModelBase; m_SelectedDetailModels.Add(currentModel); string id = currentModel.ID; m_SelectedDeleteDetailIds += "'" + id + "',"; } } m_SelectedDeleteDetailIds = m_SelectedDeleteDetailIds.TrimEnd(','); if (selectedRowsCount > 0) { return(true); } else { string showMessage = "请选择要删除的明细记录!"; XMessageBox.ShowRemindMessage(showMessage); return(false); } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnModify_Click(object sender, EventArgs e) { string selectrid = GetSelectRow(); if (!(IsCheck(selectrid))) { XMessageBox.ShowRemindMessage("请选择记录信息!"); return; } DataTable dt = new DataTable(); string sql = "select * from V_EquipmentReceive where rid in(" + selectrid + ")"; dt = SQLHelper.GetDataSet(sql); if (dt == null) { XMessageBox.ShowRemindMessage("数据提取异常!"); return; } if (dt.Rows.Count <= 0) { XMessageBox.ShowRemindMessage("数据提取异常!"); return; } string cust = ""; string invoiceno = ""; if (dt.Rows.Count > 0) { cust = dt.Rows[0]["CustName"] + ""; invoiceno = dt.Rows[0]["InvoiceNo"] + ""; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["InvoiceNo"] + "" == "") { XMessageBox.ShowRemindMessage("所选数据中存在接收单代码为空的!"); return; } if (cust != dt.Rows[i]["CustName"] + "") { XMessageBox.ShowRemindMessage("所选数据中单位不一致!"); return; } if (invoiceno != dt.Rows[i]["InvoiceNo"] + "") { XMessageBox.ShowRemindMessage("所选数据中接收单代码不一致!"); return; } } } frmBillPrint frm = new frmBillPrint("M", selectrid, dt); frm.ShowDialog(); this.Query(); }
/// <summary> /// 单号手动录入功能 /// </summary> /// <param name="sender">事件对象</param> /// <param name="e">事件参数</param> private void t_tsb_Change_Click(object sender, RoutedEventArgs e) { try { TextBlock myBlock = t_tsb_Change.Header as TextBlock; if (myBlock.Text == "单号手动录入") { //手动生成单号处理 myBlock.Text = "单号自动生成"; m_IsHand = true; t_txt_QuotationNo.IsReadOnly = false; } else { myBlock.Text = "单号手动录入"; m_IsHand = false; t_txt_QuotationNo.IsReadOnly = true; t_txt_QuotationNo.Text = PTBQuotation.Quotation_No; } } catch (Exception ex) { XMessageBox.Exception(ex); } }
public static options GetOptions(this OPTIONS options_key, SccompDbf selected_comp) { try { using (LocalDbEntities db = DBX.DataSet(selected_comp)) { options opt = db.options.Where(o => o.key == options_key.ToString()).FirstOrDefault(); if (opt != null) { return(opt); } else { options o = new options { key = options_key.ToString() }; db.options.Add(o); db.SaveChanges(); return(o); } } } catch (Exception ex) { XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return(null); } }
private void EditFiles() { if (this.grdFiles.CurrentRow == null || this.grdFiles.CurrentRow.RowType != Janus.Windows.GridEX.RowType.Record) { XMessageBox.ShowError("请选择要编辑的记录!"); return; } XModelBase currentModel = this.grdFiles.CurrentRow.DataRow as XModelBase; XTaskFilesInfo taskFileInfo = currentModel as XTaskFilesInfo; if (taskFileInfo.InputUserId != XCommon.LoginUsersInfo.RID) { XMessageBox.ShowError("不能修改非本人提交的任务文档!"); return; } frmTaskFilesEdit frm = new frmTaskFilesEdit(currentModel); if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK) { this.grdFiles.Refresh(); } }
/// <summary> /// 新建按钮事件 /// </summary> /// <param name="sender">事件对象</param> /// <param name="e">事件参数</param> private void t_tsb_New_Click(object sender, RoutedEventArgs e) { try { if (m_IsModify) { MessageResult myResult = XMessageBox.Ask("当前单据尚未保存,是否继续?", this); if (myResult == MessageResult.Yes) { //设置新报检单对象 CreateNewQuotationModel(); //对窗体进行赋值 LoadControlsValue(); } } else { //设置新报检单对象 CreateNewQuotationModel(); //对窗体进行赋值 LoadControlsValue(); } } catch (Exception ex) { XMessageBox.Exception(ex); } }
private void AddFiles() { TreeNode selectedNode = this.tvTask.SelectedNode; if (!this.IsChildTaskNode(selectedNode)) { XMessageBox.ShowError("请选择要提交文档的子任务!"); return; } IList <XModelBase> gridList = this.grdFiles.DataSource as IList <XModelBase>; XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo; if (taskInfo.AssignPeople != XCommon.LoginUsersInfo.RID) { XMessageBox.ShowError("当前登录人不是任务负责人,不能提交文档!"); return; } frmTaskFilesEdit frm = new frmTaskFilesEdit(gridList, selectedNode); if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK) { this.grdFiles.DataSource = null; this.grdFiles.DataSource = frm.ModelList; this.grdFiles.Refresh(); } }
private void btnPreview_Click(object sender, EventArgs e) { try { this.query_model = JsonConvert.DeserializeObject <QueryModel>(this.TextArea.Text); if (this.query_model != null) { DialogReportScope scope = new DialogReportScope(this, this.query_model, this.default_data_path); if (scope.ShowDialog() == DialogResult.OK) { DialogDisplayDataTable dt = new DialogDisplayDataTable(scope.data_table); dt.ShowDialog(); } } else { XMessageBox.Show("Syntax error", "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return; } } catch (Exception ex) { XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return; } }
protected virtual void Import() { if (!this.ValidateImport()) { return; } DataTable excelTable = this.grdData.DataSource as DataTable; int rowCount = excelTable.Rows.Count; m_TimePk = DateTime.Now.ToString("yyyyMMddHHmmss"); XImportResultInfo resultInfo = this.ImportOperate(excelTable); resultInfo.Count = rowCount; if (resultInfo.FailureCount > 0) { int failueCount = resultInfo.FailureCount; int successCount = resultInfo.SuccessCount; int notExecCount = resultInfo.Count - successCount - failueCount; XMessageBox.ShowRemindMessage("成功导入" + successCount + "条,失败" + failueCount + "条,未执行" + notExecCount + "条!"); frmOperateResult frm = new frmOperateResult(resultInfo.Results); frm.ShowDialog(); } else { XMessageBox.ShowRemindMessage("成功导入" + rowCount + "条!"); } }
//public SQLiteDbPrepare(SccompDbf sccomp) : // base(new SQLiteConnection() // { // ConnectionString = new SQLiteConnectionStringBuilder() { DataSource = sccomp.GetAbsolutePath() + taxonomy_matching_file_name, ForeignKeys = true }.ConnectionString // }, true) //{ //} //protected override void OnModelCreating(DbModelBuilder modelBuilder) //{ // modelBuilder.Conventions.Remove<PluralizingTableNameConvention>(); // base.OnModelCreating(modelBuilder); //} //public DbSet<boj5_header> boj5_header { get; set; } //public DbSet<boj5_person> boj5_person { get; set; } //public DbSet<boj5_detail> boj5_detail { get; set; } //public DbSet<glacc_match> glacc_match { get; set; } public static void EnsureDbCreated(SccompDbf sccomp) { try { if (!Directory.Exists(sccomp.GetAbsolutePath())) { XMessageBox.Show("ค้นหาไดเร็คทอรี่ " + sccomp.GetAbsolutePath() + " ไม่พบ", "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return; } if (!File.Exists(sccomp.GetAbsolutePath() + SQLiteDbPrepare.taxonomy_matching_file_name)) { SQLiteConnection.CreateFile(sccomp.GetAbsolutePath() + SQLiteDbPrepare.taxonomy_matching_file_name); using (SQLiteConnection connection = new SQLiteConnection(@"Data Source=" + sccomp.GetAbsolutePath() + SQLiteDbPrepare.taxonomy_matching_file_name + @";Version=3;")) { using (SQLiteCommand cmd = connection.CreateCommand()) { cmd.CommandText = "CREATE TABLE IF NOT EXISTS glacc_match(id INTEGER PRIMARY KEY, accnum TEXT, depcod TEXT, taxodesc TEXT, taxodesc2 TEXT)"; connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } } } UpgradeDB(sccomp); } catch (Exception ex) { XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); } }
/// <summary> /// 注销 /// </summary> protected virtual void SignOut() { if (XMessageBox.ShowQuestion("您确定要注销吗?") == System.Windows.Forms.DialogResult.No) { return; } Application.Restart(); }
protected virtual bool ValidateDeleteDetailCommon(object sender) { if (XMessageBox.ShowQuestion("确定要删除选中的记录吗?") == System.Windows.Forms.DialogResult.No) { return(false); } return(true); }
/// <summary> /// 修改前校验 /// </summary> /// <returns></returns> protected virtual bool ValidateBeforeEdit() { if (this.treeView.SelectedNode == null) { XMessageBox.ShowError("请选择要修改的节点!"); return(false); } return(true); }
public static void ExtractZipFile(string archiveFilenameIn, string password, string outFolder) { ZipFile zf = null; try { FileStream fs = File.OpenRead(archiveFilenameIn); zf = new ZipFile(fs); if (!String.IsNullOrEmpty(password)) { zf.Password = password; // AES encrypted entries are handled automatically } foreach (ZipEntry zipEntry in zf) { if (!zipEntry.IsFile) { continue; // Ignore directories } String entryFileName = zipEntry.Name; // to remove the folder from the entry:- entryFileName = Path.GetFileName(entryFileName); // Optionally match entrynames against a selection list here to skip as desired. // The unpacked length is available in the zipEntry.Size property. byte[] buffer = new byte[4096]; // 4K is optimum Stream zipStream = zf.GetInputStream(zipEntry); // Manipulate the output filename here as desired. String fullZipToPath = Path.Combine(outFolder, entryFileName); string directoryName = Path.GetDirectoryName(fullZipToPath); if (directoryName.Length > 0) { Directory.CreateDirectory(directoryName); } // Unzip file in buffered chunks. This is just as fast as unpacking to a buffer the full size // of the file, but does not waste memory. // The "using" will close the stream even if an exception occurs. using (FileStream streamWriter = File.Create(fullZipToPath)) { StreamUtils.Copy(zipStream, streamWriter, buffer); } } } catch (Exception ex) { XMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, XMessageBoxIcon.Error); return; } finally { if (zf != null) { zf.IsStreamOwner = true; // Makes close also shut the underlying stream zf.Close(); // Ensure we release resources } } }
protected virtual bool ValidateAddCommon() { if (this.grdData.CurrentRow == null || this.grdData.CurrentRow.RowType != Janus.Windows.GridEX.RowType.Record) { XMessageBox.ShowError("请选择要添加明细的主表记录!"); return(false); } return(true); }
protected override bool ValidataForm() { if (this.txtPassword.Text.Trim() != this.txtRepass.Text.Trim()) { XMessageBox.ShowError("两次输入的密码不一致!"); return(false); } return(true); }
/// <summary> /// 自定义UI校验 /// </summary> /// <returns></returns> protected override bool ValidateCustom() { if (this.m_EditStatus == XEditStatus.AddNew) { if (this.txtPassWord.Text.Trim() != this.txtRepass.Text.Trim()) { XMessageBox.ShowError("两次密码输入的不一致!"); return(false); } } bool isValidateExist = false; if (this.m_EditStatus == XEditStatus.AddNew) { isValidateExist = true; } else if (this.m_EditStatus == XEditStatus.Edit) { if (this.m_OldUserName != this.txtUserName.Text.Trim()) { isValidateExist = true; } } if (isValidateExist) { if (this.m_Business.IsExist(this.txtUserName.Text.Trim())) { XMessageBox.ShowError("用户名已存在!"); return(false); } } bool isValidateRealNameExist = false; if (this.m_EditStatus == XEditStatus.AddNew) { isValidateRealNameExist = true; } else if (this.m_EditStatus == XEditStatus.Edit) { if (this.m_OldRealName != this.txtRealName.Text.Trim()) { isValidateRealNameExist = true; } } if (isValidateRealNameExist && this.m_UsersBusiness.IsRealNameExist(this.txtRealName.Text.Trim())) { XMessageBox.ShowError("真实姓名已存在!"); return(false); } return(true); }
public bool InsertCustom(XModelBase model) { DbConnection sqlConn = this.m_DataAccess.Connection; DbTransaction trans = null; try { if (sqlConn.State == ConnectionState.Closed) { sqlConn.Open(); } trans = sqlConn.BeginTransaction(); string sql = this.GetInsertSql(model) + ";"; XVTaskFilesInfo taskFilesInfo = model as XVTaskFilesInfo; //更新任务状态为结束 sql += "UPDATE Task SET TaskStatus='结束' WHERE RID='" + taskFilesInfo.MainId + "';"; if (taskFilesInfo.FileFullName != string.Empty) { //上传附件 DbCommand fileCommand = this.GetFileCommand(taskFilesInfo); fileCommand.Connection = sqlConn; fileCommand.Transaction = trans; DbDataReader reader = fileCommand.ExecuteReader(); reader.Close(); } DbCommand cmd = this.m_DataAccess.GetDbCommand(); cmd.Connection = sqlConn; cmd.CommandText = sql; cmd.Transaction = trans; bool isSuccess = cmd.ExecuteNonQuery() > 0; trans.Commit(); return(isSuccess); } catch (Exception ex) { XMessageBox.ShowError(ex.Message); XErrorLogTool.WriteLog(ex.ToString()); trans.Rollback(); } finally { if (sqlConn.State == ConnectionState.Open) { sqlConn.Close(); } } return(false); }
protected override bool ValidateEditCustom() { if (this.m_Business.IsCheck(this.m_CurrentModel)) { XMessageBox.ShowError("要修改的记录已审核,不能修改!"); return(false); } return(true); }
private void btnStop_Click(object sender, EventArgs e) { if (XMessageBox.Show("ยกเลิกการแก้ไขข้อมูล, ทำต่อหรือไม่?", "", MessageBoxButtons.OKCancel, XMessageBoxIcon.Question) == DialogResult.OK) { this.tmp_boj5_header = null; this.GetBojData(); this.FillForm(this.boj5_header, this.boj5_detail); this.ResetFormState(FORM_MODE.READ); } }
protected virtual bool ValidateImportCommon() { if (this.grdData.RowCount == 0) { XMessageBox.ShowError("没有要导入的记录!"); return(false); } return(true); }
public static bool Preview(string fileId) { string where = " and FileId='" + fileId + "'"; IList <XModelBase> fileAttachInfos = m_FileAttachBusiness.QueryByWhere(where); if (fileAttachInfos.Count == 0) { XMessageBox.ShowError("未找到附件,无法预览!"); return(false); } XFileAttachmentInfo fileInfo = fileAttachInfos[0] as XFileAttachmentInfo; string[] imageTypes = new string[] { ".png", ".jpg", ".jpeg" }; string[] officeTypes = new string[] { ".doc", ".docx", ".xls", ".xlsx" }; if (!imageTypes.Contains(fileInfo.AtchType) && !officeTypes.Contains(fileInfo.AtchType)) { XMessageBox.ShowError("不支持预览格式为[" + fileInfo.AtchType + "]的文件!"); return(false); } string path = XCommon.TempPath; string fileName = Guid.NewGuid().ToString(); fileName = m_FileAttachBusiness.DownLoadFile(fileId, path, fileName); if (imageTypes.Contains(fileInfo.AtchType)) { //如果是图片 frmImagePreview frm = new frmImagePreview(fileName); frm.ShowDialog(); } else { frmOfficeFilePreview frm = new frmOfficeFilePreview(fileName); frm.ShowDialog(); } if (File.Exists(fileName)) { try { File.Delete(fileName); } catch (Exception ex) { XErrorLogTool.WriteLog(ex.ToString()); } } return(true); }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDel_Click(object sender, EventArgs e) { string selectrid = GetSelectRow(); if (!(IsCheck(selectrid))) { XMessageBox.ShowRemindMessage("请选择记录信息!"); return; } DataTable dt = new DataTable(); string sql = "select * from V_EquipmentReceive where rid in(" + selectrid + ")"; dt = SQLHelper.GetDataSet(sql); if (dt == null) { XMessageBox.ShowRemindMessage("数据提取异常!"); return; } if (dt.Rows.Count <= 0) { XMessageBox.ShowRemindMessage("数据提取异常!"); return; } if (dt.Rows.Count > 1) { XMessageBox.ShowRemindMessage("请选择一条数据!"); return; } string invoiceno = dt.Rows[0]["InvoiceNo"] + ""; if (invoiceno == "") { XMessageBox.ShowRemindMessage("所选数据未打印接收单!"); return; } if (MessageBox.Show("是否删除接收单号为:" + invoiceno + "的接收单信息?", "提醒!", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.Yes) { string sqldel = "delete from TemplateBill where Rno='" + invoiceno + "'"; string sqlupdate = "update EquipmentReceive set InvoiceNo='' where InvoiceNo='" + invoiceno + "'"; if (SQLHelper.ExecuteCommand(sqldel) > 0) { if (SQLHelper.ExecuteCommand(sqlupdate) > 0) { XMessageBox.ShowRemindMessage("执行成功!"); } } } this.Query(); }