private void gridView2_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == "Over" && e.IsGetData)
{
CARRATES val = (CARRATES)e.Row;
if (!string.IsNullOrWhiteSpace(val.CODE) && !string.IsNullOrWhiteSpace(val.AGENCY) && !string.IsNullOrWhiteSpace(val.CAT) && val.START_DATE != null && val.END_DATE != null && val.ID != 0)
{
var load = from c in context.CARRATES where c.CODE == val.CODE && c.AGENCY == val.AGENCY && c.CAT == val.CAT select new { c.START_DATE, c.END_DATE };
//
foreach (var rec in load)
{
DateTime start = (DateTime)val.START_DATE;
DateTime end = (DateTime)val.END_DATE;
DateTime existStart = (DateTime)rec.START_DATE;
DateTime existEnd = (DateTime)rec.END_DATE;
if (!checkOverlap(start, end, existStart, existEnd))
{
e.Value = true;
}
else
{
e.Value = false;
}
}
}
}
}
/// <summary>
/// 设置数量
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName.ToUpper() == "NUMS" && e.IsGetData)
{
e.Value = 1;
}
}
private void layoutView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column == UnboundKomentar)
{
var row = (Komentar)e.Row;
if (row != null)
{
byte[] zipovan = Convert.FromBase64String(row.sadrzaj);
string rtfraw = Unzip(zipovan);
rtfpostunzip = rtfraw;
repositoryItemRichTextEdit1.DocumentFormat = DevExpress.XtraRichEdit.DocumentFormat.Rtf;
e.Value = rtfraw;
}
}
if (e.Column == UnboundSlika)
{
var row = (Komentar)e.Row;
var db = new AbacusSUPEntities();
Komentar kom = db.Komentar.FirstOrDefault(qq => qq.id == row.id);
if (kom != null)
{
e.Value = AbacusSUPP.Helper.GetImageFromByteArray(kom.Login.avatar);
}
else
{
MessageBox.Show("Nesto ne valja.");
}
}
}
private void gridView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
ColumnView view = sender as ColumnView;
if (view.GetListSourceRowCellValue(e.ListSourceRowIndex, "product_id") != DBNull.Value)
{
int productId = (int)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "product_id");
DataRow dr = getProductRow(productId);
if (e.Column.FieldName == "brand" && e.IsGetData)
{
e.Value = dr["Brand"].ToString();
}
else if (e.Column.FieldName == "parfume_size" && e.IsGetData)
{
e.Value = dr["ParfumeSize"].ToString();
}
else if (e.Column.FieldName == "parfume_type" && e.IsGetData)
{
e.Value = dr["ParfumeType"].ToString();
}
else if (e.Column.FieldName == "base_price" && e.IsGetData)
{
e.Value = Convert.ToDouble(dr["BasePrice"].ToString());
}
else if (e.Column.FieldName == "size" && e.IsGetData)
{
e.Value = Convert.ToDouble(dr["Size"].ToString());
}
}
else
{
e.Value = "";
}
}
private void lvEmployeeMain_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
//if (e.Column == colFullName)
//{
// DataRow row = lvEmployeeMain.GetDataRow(e.RowHandle);
// e.Value = String.Format("{0} {1}", row["FirstName"], row["LastName"]);
//}
}
private void layoutViewResources_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == "ResourceImage" && e.IsGetData)
{
Image resourceImage = (e.Row as DevExpress.XtraScheduler.Resource).Image;
if (resourceImage == null)
{
resourceImage = noPhotoImage;
}
e.Value = resourceImage;
}
}
private void gridViewInventario_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
GridView view = (GridView)sender;
if (e.Column.FieldName == "Total" & e.IsGetData)
{
decimal total = 0m;
for (int i = 0; i <= e.ListSourceRowIndex; i++)
{
total += Convert.ToDecimal(view.GetListSourceRowCellValue(i, "Saldo"));
}
e.Value = total;
}
}
void OnCustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == unboundColumnFieldName)
{
if (e.IsGetData)
{
IList dataSource = colView.DataSource as IList;
object obj = dataSource[e.ListSourceRowIndex];
if (obj == null)
{
return;
}
PropertyDescriptor descriptor = TypeDescriptor.GetProperties(obj.GetType())[convertedProperty];
if (descriptor == null)
{
return;
}
object value = descriptor.GetValue(obj);
TypeConverter converter = descriptor.Converter;
if (converter != null && converter.CanConvertFrom(value.GetType()) && value is Enum)
{
e.Value = converter.ConvertFrom(value.ToString());
}
else if (converter != null && converter.CanConvertFrom(value.GetType()))
{
e.Value = converter.ConvertFrom(value);
}
}
else if (e.IsSetData)
{
IList dataSource = colView.DataSource as IList;
object obj = dataSource[e.ListSourceRowIndex];
if (obj == null)
{
return;
}
PropertyDescriptor descriptor = TypeDescriptor.GetProperties(obj.GetType())[convertedProperty];
if (descriptor == null)
{
return;
}
TypeConverter converter = descriptor.Converter;
object value = descriptor.GetValue(obj);
if (converter != null && converter.CanConvertTo(value.GetType()))
{
descriptor.SetValue(obj, converter.ConvertTo(e.Value, value.GetType()));
}
}
}
}
private void gridViewHalfHour_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
EmployeePlanningWeek empl = GetEntityByRowHandle(e.RowHandle);
EmployeeDayView dayView = null;
if (empl != null && m_dailyView != null)
{
dayView = m_dailyView.GetByEmployeeId(empl.EmployeeId);
}
if (e.Column == gc_AllreadyPlannedWorkingHours)
{
if (dayView != null && dayView.PlanningDay != null)
{
e.Value = DateTimeHelper.IntTimeToStr(dayView.PlanningDay.CountDailyPlannedWorkingHours);
}
}
}
private void gridView8_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
//if (e.Column.FieldName == "Images" && e.IsGetData)
//{
// int dataSourceIndex = e.ListSourceRowIndex;
// GridView view = sender as GridView;
// string colorName = (string)view.GetRowCellValue(dataSourceIndex, "Images");
// string fileName = GetFileName(colorName).ToLower();
// if (!Images.ContainsKey(fileName))
// {
// Image img = null;
// try
// {
// string filePath = DevExpress.Utils.FilesHelper.FindingFileName(Application.StartupPath, ImageDir + fileName, false);
// img = Image.FromFile(filePath);
// }
// catch
// {
// }
// Images.Add(fileName, img);
// }
// e.Value = Images[fileName];
//}
}
private void GridViewAdditionalContacts_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == "RptType" && e.IsGetData)
{
CONTACT conRec = (CONTACT)e.Row;
int id = conRec.ID;
string load = String.Empty;
if (id == int.MaxValue)
{
if (firstLoad == true)
{
var values = from rec in context.RPTTYPE where rec.RecipientType == "Operator" select new { rec.CODE };
foreach (var result in values)
{
if (!string.IsNullOrWhiteSpace(load))
{
load += "," + result.CODE;
}
else
{
load += result.CODE;
}
}
globalRptType = load;
firstLoad = false;
}
else
{
load = globalRptType;
}
}
else
{
var val = from rec in context.RptContact where rec.Contact_ID == id && rec.Code == TextEditCode.Text select new { rec.RptType };
foreach (var result in val)
{
if (!string.IsNullOrWhiteSpace(load))
{
load += "," + result.RptType;
}
else
{
load += result.RptType;
}
}
}
e.Value = load;
}
if (e.Column.FieldName == "RptType" && e.IsSetData)
{
CONTACT conRec = (CONTACT)e.Row;
int id = conRec.ID;
if (id == int.MaxValue)
{
globalRptType = e.Value.ToString();
modified = true;
}
else
{
string value = e.Value.ToString();
var results = from rptRec in context.RptContact where !value.Contains(rptRec.RptType) && rptRec.Code == TextEditCode.Text && rptRec.Contact_ID == id select rptRec;
foreach (var result in results)
{
context.RptContact.DeleteObject(result);
}
var val1 = (from rptRec in context.RPTTYPE
where value.Contains(rptRec.CODE)
select new { rptRec.CODE });
foreach (var result1 in val1)
{
if ((from rptCont in context.RptContact where rptCont.Contact_ID == id && rptCont.Code == TextEditCode.Text && rptCont.RptType == result1.CODE select new { rptCont.Code }).Count() == 0)
{
RptContact lol = new RptContact();
lol.Code = TextEditCode.Text;
lol.RptType = result1.CODE;
lol.Contact_ID = id;
context.RptContact.AddObject(lol);
}
}
context.SaveChanges();
}
}
}
