private void btnPrint_Click(object sender, EventArgs e)
{
List <SZAservice> dt1 = dt;
if (ListSelected.Count > 0)
{
dt1 = dt1.Where(d => ListSelected.Contains(d.ZID)).ToList();
}
//else
//{
// if (MessageBox.Show("در صورت انتخاب نكردن موردي همه موارد در گزارش ذكر ميشود.\nآيا مايل به ادامه هستيد؟",
// "سوال", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
// {
// goto END1;
// }
//}
var DateNow = DateTime.Now;
string today = pc.GetYear(DateNow).ToString("0000") + "/" + pc.GetMonth(DateNow).ToString("00") + "/" + pc.GetDayOfMonth(DateNow).ToString("00");
StiReport report = new StiReport();
report.Load(@"C:\Users\North-PC\Desktop\Report Sarfasl (Stimulsoft)\Atiran\ReportZirSarfasl1.mrt");
//report.Dictionary.Databases.Add(new StiSqlDatabase("Connection", "Integrated Security=True;Data Source=.;Initial Catalog=ZAnsari;Password=;User ID="));//Connections.ConnectionInfo.BuildStimulConnectionString()));
//report.Compile();
report.Dictionary.Variables["User"].Value = "alirezasadegghi";
report.Dictionary.Variables["today"].Value = today;
report.Dictionary.Variables["NameSarfasl"].Value = _nameSarfasl;
report.Dictionary.Variables["FromDate"].Value = textDate1.FromDate;
report.Dictionary.Variables["ToDate"].Value = textDate1.ToDate;
report.RegBusinessObject("SZA", dt1);
report.Render();
report.Show();
//END1:;
}
private void chbAll_CheckedChanged(object sender, EventArgs e)
{
List <int> list1 = ((List <SZAservice>)dgvZirSarfal.DataSource).Select(a => a.ZID).ToList();
ListSelected.RemoveAll(x => list1.Contains(x));
if (chbAll.Checked)
{
ListSelected.AddRange(list1);
foreach (DataGridViewRow row in dgvZirSarfal.Rows)
{
row.Cells["select"].Value = true;
row.DefaultCellStyle.BackColor = Color.PaleTurquoise;
}
}
else
{
foreach (DataGridViewRow row in dgvZirSarfal.Rows)
{
row.Cells["select"].Value = false;
row.DefaultCellStyle.BackColor = Color.White;
}
}
SetTextLabelFooter();
//lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}";
}
private void GetData()
{
lblLoding.Visible = true;
ListSelected.Clear();
var listsarfasl = new List <int>();
listsarfasl.Add(_sarfaslID);
Thread tGetdata = new Thread(() =>
{
dt = conection.GetSZAServices(textDate1.FromDate, textDate1.ToDate, _listZirSar, listsarfasl, new List <int>());
});
tGetdata.Start();
tGetdata.Join();
//dt = conection.GetZirSarfaslServices1(listsarfasl, _listZirSar, textDate1.FromDate, textDate1.ToDate);
int row = 1;
dgvZirSarfal.DataSource = dt0 = dt.GroupBy(g => new
{
g.ZID,
g.ZSarfaslID,
g.ZName,
g.Zbed,
g.Zbes,
g.ZMan,
g.Zbed_bes,
g.ZMan_Befor,
g.Zbed_bes_Befor,
g.ZMan_All,
g.Zbed_bes_All,
g.Zhas_dar,
g.ZActive
}).Select(g => new SZAservice()
{
Zrow = row++,
ZID = g.Key.ZID,
ZSarfaslID = g.Key.ZSarfaslID,
ZName = g.Key.ZName,
Zbed = g.Key.Zbed,
Zbes = g.Key.Zbes,
ZMan = g.Key.ZMan,
Zbed_bes = g.Key.Zbed_bes,
ZMan_Befor = g.Key.ZMan_Befor,
Zbed_bes_Befor = g.Key.Zbed_bes_Befor,
ZMan_All = g.Key.ZMan_All,
Zbed_bes_All = g.Key.Zbed_bes_All,
Zhas_dar = g.Key.Zhas_dar,
ZActive = g.Key.ZActive
}).ToList();
chbAll.Checked = false;
SetTextLabelFooter(dt.Count, dt.Sum(d => d.Zbed), dt.Sum(d => d.Zbes), dt.Sum(d => d.ZMan), dt.Sum(d => d.ZMan_All));
SetGrid();
txtFilter.Focus();
lblLoding.Visible = false;
}
private void AddOrRemoveInListAndTextSelected(int rowData, bool isAdded)
{
ListSelected.RemoveAll(i => i == (int)dgvZirSarfal.Rows[rowData].Cells["ZID"].Value);
if (isAdded)
{
ListSelected.Add((int)dgvZirSarfal.Rows[rowData].Cells["ZID"].Value);
}
SetTextLabelFooter();
//lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}";
}
private void SetTextLabelFooter()
{
decimal bedSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbed);
decimal besSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbes);
decimal sumSelect = bedSelect - besSelect;
string status0 = sumSelect > 0 ? "بد" : sumSelect == 0 ? "--" : "بس";
lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}";
lblBedSelect.Text = (bedSelect).ToMan();
lblBesSelect.Text = (besSelect).ToMan();
lblManSelect.Text = $"{Math.Abs(sumSelect).ToMan()} ({status0})";
}
public TTTreeSplitDlg(IBaseWindow baseWin)
{
InitializeComponent();
btnClose.Image = UIHelper.LoadResourceImage("Resources.btn_cancel.gif");
ListSelected.AddColumn("-", 300);
ListSkipped.AddColumn("-", 300);
fController = new TreeSplitController(this);
fController.Init(baseWin);
SetLocale();
}
public void SetLocale()
{
Title = LangMan.LS(LSID.LSID_ToolOp_3);
pageTreeSplit.Text = LangMan.LS(LSID.LSID_ToolOp_3);
btnClose.Text = LangMan.LS(LSID.LSID_DlgClose);
btnSelectAll.Text = LangMan.LS(LSID.LSID_SelAll);
btnSelectFamily.Text = LangMan.LS(LSID.LSID_SelFamily);
btnSelectAncestors.Text = LangMan.LS(LSID.LSID_SelAncestors);
btnSelectDescendants.Text = LangMan.LS(LSID.LSID_SelDescendants);
btnDelete.Text = LangMan.LS(LSID.LSID_DoDelete);
btnSave.Text = LangMan.LS(LSID.LSID_MIFileSaveAs);
ListSelected.SetColumnCaption(0, LangMan.LS(LSID.LSID_Person));
ListSkipped.SetColumnCaption(0, LangMan.LS(LSID.LSID_Person));
}
private void dgvZirSarfal_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow row in dgvZirSarfal.Rows)
{
row.Cells["ZMan"].Value = Math.Abs((decimal)row.Cells["ZMan"].Value).ToString();
row.Cells["ZMan_Befor"].Value = Math.Abs((decimal)row.Cells["ZMan_Befor"].Value).ToString();
row.Cells["ZMan_All"].Value = Math.Abs((decimal)row.Cells["ZMan_All"].Value).ToString();
if (ListSelected.Any(i => i == (int)row.Cells["ZID"].Value))
{
row.Cells["select"].Value = true;
row.DefaultCellStyle.BackColor = Color.PaleTurquoise;
}
else
{
row.Cells["select"].Value = false;
row.DefaultCellStyle.BackColor = Color.White;
}
}
}
private void SetTextLabelFooter(int number, decimal bed, decimal bes, decimal sum, decimal sumAll)
{
decimal bedSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbed);
decimal besSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbes);
decimal sumSelect = bedSelect - besSelect;
string status0 = sumSelect > 0 ? "بد" : sumSelect == 0 ? "--" : "بس";
string status1 = sum > 0 ? "بد" : sum == 0 ? "--" : "بس";
string status2 = sumAll > 0 ? "بد" : sumAll == 0 ? "--" : "بس";
lblFooterNumber.Text = $"تعداد: {number}\nتعداد انتخابي: {ListSelected.Count}";
lblBedSelect.Text = (bedSelect).ToMan();
lblBesSelect.Text = (besSelect).ToMan();
lblManSelect.Text = $"{Math.Abs(sumSelect).ToMan()} ({status0})";
lblBedDate.Text = (bed).ToMan();
lblBesDate.Text = (bes).ToMan();
lblManDate.Text = $"{Math.Abs(sum).ToMan()} ({status1})";
lblMan.Text = $"{ Math.Abs(sumAll).ToMan()} ({status2})";
}
public void UpdateUI()
{
if (EndTime < 0 || StartTime < 0)
{
return;
}
ListSelected.ToList().ForEach(o => o.IsSelect = false);
if (StartTime < EndTime)
{
for (var i = StartTime; i <= EndTime; i++)
{
var el = List.FirstOrDefault(o => o.ID == i);
if (el != null)
{
el.IsSelect = true;
}
}
}
if (StartTime <= EndTime)
{
return;
}
for (var i = 0; i <= StartTime; i++)
{
var el = List.FirstOrDefault(o => o.ID == i);
if (el != null)
{
el.IsSelect = true;
}
}
for (var i = EndTime; i <= 23; i++)
{
var el = List.FirstOrDefault(o => o.ID == i);
if (el != null)
{
el.IsSelect = true;
}
}
}
private void UpdateSplitLists()
{
ListSelected.BeginUpdate();
ListSelected.Items.Clear();
ListSkipped.BeginUpdate();
ListSkipped.Items.Clear();
try
{
int cnt = 0;
int num = fTree.RecordsCount;
for (int i = 0; i < num; i++)
{
GEDCOMRecord rec = fTree[i];
if (rec is GEDCOMIndividualRecord)
{
cnt++;
GEDCOMIndividualRecord iRec = rec as GEDCOMIndividualRecord;
string st = iRec.XRef + " / " + GKUtils.GetNameString(iRec, true, false);
if (fSplitList.IndexOf(iRec) < 0)
{
ListSkipped.Items.Add(st);
}
else
{
ListSelected.Items.Add(st);
}
}
}
Text = fSplitList.Count.ToString() + @" / " + cnt.ToString();
}
finally
{
ListSelected.EndUpdate();
ListSkipped.EndUpdate();
}
}
private void Update()
{
StartTime = ListSelected.Any() ? ListSelected.Min(m => m.ID) : -1;
EndTime = ListSelected.Any() ? ListSelected.Max(m => m.ID) : -1;
}
public void SetSelected(int start, int end)
{
ListSelected.ToList().ForEach(o => o.IsSelect = false);
List.Where(o => o.ID >= start && o.ID <= end).ToList().ForEach(e => e.IsSelect = true);
Update();
}
