private void gridView_ValidateCell(object sender, DevExpress.Xpf.Grid.GridCellValidationEventArgs e)
{
if (e.Column.FieldName.Equals("FVoucherTplID"))
{
ICSaleDisplay sale = (ICSaleDisplay)e.Row;
VoucherTplSimple vchTpl = cboVoucherTpl.GetItemFromValue(e.Value) as VoucherTplSimple;
if (vchTpl.TransType != sale.FTransType)
{
e.ErrorType = ErrorType.Warning;
e.ErrorContent = "模板类型错误,请选择对应单据类型的模板!";
e.IsValid = false;
}
}
}
public List <VoucherTplSimple> getAll()
{
String sql = "select * from fsICVoucherTpl";
DataSet ds = db.Query(sql);
List <VoucherTplSimple> lst = new List <VoucherTplSimple>();
if (!DbHelper.getInstance().IsEmpty(ds))
{
foreach (DataRow row in ds.Tables[0].Rows)
{
VoucherTplSimple tpl = new VoucherTplSimple();
//取表头
tpl.InterID = Convert.ToInt32(row["FInterID"]);
tpl.Name = Convert.ToString(row["FName"]);
tpl.TransType = Convert.ToInt32(row["FTplType"]);
lst.Add(tpl);
}
}
return(lst);
}
