private void gvResults_CellValueChanged(object sender, CellValueChangedEventArgs e) { string val = Convert.ToString(e.Value); DataTable dt = this.gcResults.DataSource as DataTable; DataRow dr = this.gvResults.GetDataRow(e.RowHandle); if (dr == null) { return; } if (e.Column == this.gcolId) { if (dt != null && !string.IsNullOrEmpty(val)) { DataRow[] drs = dt.Select(string.Format("LABEL_ID='{0}'", val)); if (drs.Length > 0) { //MessageService.ShowMessage(string.Format("ID:{0} 已存在,请确认。", val), "提示"); MessageService.ShowMessage(string.Format(StringParser.Parse("${res:FanHai.Hemera.Addins.PrintLabelCtrl.msg.0005}"), val), StringParser.Parse("${res:Global.SystemInfo}")); dr[e.Column.FieldName] = string.Empty; this.gvResults.FocusedColumn = e.Column; } } } else if (e.Column == this.gcolIsValid) { if (val == "N") { string labelId = Convert.ToString(dr["LABEL_ID"]); PrintLabelEntity entity = new PrintLabelEntity(); if (!entity.IsAllowInvalid(labelId)) { MessageService.ShowMessage(entity.ErrorMsg, StringParser.Parse("${res:Global.SystemInfo}")); this.gvResults.FocusedColumn = e.Column; this.gvResults.FocusedRowHandle = e.RowHandle; dr[e.Column.FieldName] = "Y"; } } } if (dr.RowState == DataRowState.Modified) { bool rejectChanges = true; foreach (DataColumn col in dt.Columns) { string original = Convert.ToString(dr[col, DataRowVersion.Original]); string current = Convert.ToString(dr[col, DataRowVersion.Default]); if (current != original) { rejectChanges = false; break; } } if (rejectChanges) { dr.RejectChanges(); } } }
/// <summary> /// 绑定标签或铭牌数据。 /// </summary> private void BindLabelData() { PrintLabelEntity entity = new PrintLabelEntity(); DataSet dsLabelData = entity.GetPrintLabelData(); if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowError(entity.ErrorMsg); return; } this.gcResults.DataSource = dsLabelData.Tables[0]; }
private void gvResults_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e) { DataRow dr = this.gvResults.GetDataRow(e.RowHandle); string labelId = Convert.ToString(dr["LABEL_ID"]); PrintLabelEntity entity = new PrintLabelEntity(); DataSet dsLabelDetailData = entity.GetPrintLabelDetailData(labelId); if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowError(entity.ErrorMsg); return; } e.ChildList = dsLabelDetailData.Tables[0].DefaultView; }
private void BindCustCheckTypeData() { PrintLabelEntity entity = new PrintLabelEntity(); DataSet ds = entity.GetCustCheckTypeData(); if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowError(entity.ErrorMsg); return; } this.rilueCustCheckType.DataSource = ds.Tables[0]; this.rilueCustCheckType.ValueMember = "CODE"; this.rilueCustCheckType.DisplayMember = "NAME"; this.rilueCustCheckType.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("NAME")); }
private void BindPowersetTypeData() { PrintLabelEntity entity = new PrintLabelEntity(); DataSet ds = entity.GetPowersetTypeData(); if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowError(entity.ErrorMsg); return; } this.ricmbPowersetType.Items.Clear(); foreach (DataRow dr in ds.Tables[0].Rows) { this.ricmbPowersetType.Items.Add(dr[0]); } }
private void tsbSave_Click(object sender, EventArgs e) { if (this.gvResults.State == GridState.Editing && this.gvResults.IsEditorFocused && this.gvResults.EditingValueModified) { this.gvResults.SetFocusedRowCellValue(this.gvResults.FocusedColumn, this.gvResults.EditingValue); } this.gvResults.UpdateCurrentRow(); int rowIndex = this.gvResults.FocusedRowHandle; DataTable dt = this.gcResults.DataSource as DataTable; DataTable dtChanges = dt.GetChanges(); if (dtChanges == null || dtChanges.Rows.Count <= 0) { this.tsbSave.Enabled = false; return; } var items = dtChanges.AsEnumerable(); var ids = from item in items where string.IsNullOrEmpty(Convert.ToString(item["LABEL_ID"])) select item; foreach (var item in ids) { //MessageService.ShowMessage("ID 不能为空", "提示"); MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.PrintLabelCtrl.msg.0001}"), StringParser.Parse("${res:Global.SystemInfo}")); this.gvResults.FocusedColumn = this.gcolId; this.gvResults.FocusedRowHandle = this.gvResults.GetRowHandle(dt.Rows.IndexOf(item)); this.gvResults.ShowEditor(); return; } var names = from item in items where string.IsNullOrEmpty(Convert.ToString(item["LABEL_NAME"])) select item; foreach (var item in names) { //MessageService.ShowMessage("名称 不能为空" ,"提示"); MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.PrintLabelCtrl.msg.0002}"), StringParser.Parse("${res:Global.SystemInfo}")); this.gvResults.FocusedColumn = this.gcolName; this.gvResults.FocusedRowHandle = this.gvResults.GetRowHandle(dt.Rows.IndexOf(item)); this.gvResults.ShowEditor(); return; } var dataTypes = from item in items where string.IsNullOrEmpty(Convert.ToString(item["DATA_TYPE"])) select item; foreach (var item in dataTypes) { //MessageService.ShowMessage(string.Format("类型 不能为空"), "提示"); MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.PrintLabelCtrl.msg.0003}"), StringParser.Parse("${res:Global.SystemInfo}")); this.gvResults.FocusedColumn = this.gcolDataType; this.gvResults.FocusedRowHandle = this.gvResults.GetRowHandle(dt.Rows.IndexOf(item)); this.gvResults.ShowEditor(); return; } var printerTypes = from item in items where string.IsNullOrEmpty(Convert.ToString(item["PRINTER_TYPE"])) select item; foreach (var item in printerTypes) { //MessageService.ShowMessage(string.Format("打印机类型 不能为空"), "提示"); MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.PrintLabelCtrl.msg.0004}"), StringParser.Parse("${res:Global.SystemInfo}")); this.gvResults.FocusedColumn = this.gcolPrinterType; this.gvResults.FocusedRowHandle = this.gvResults.GetRowHandle(dt.Rows.IndexOf(item)); this.gvResults.ShowEditor(); return; } DataSet dsParams = new DataSet(); DataTable dtParams = dtChanges; foreach (DataRow dr in items) { dr["CREATOR"] = PropertyService.Get(PROPERTY_FIELDS.USER_NAME); dr["EDITOR"] = PropertyService.Get(PROPERTY_FIELDS.USER_NAME); } dsParams.Tables.Add(dtParams); PrintLabelEntity entity = new PrintLabelEntity(); entity.SavePrintLabelData(dsParams); if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowError(entity.ErrorMsg); return; } BindLabelData(); this.gvResults.FocusedRowHandle = rowIndex; }