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;
}
