private void grd_selectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
CapitalDetail cp = (CapitalDetail)grid_tankhah.SelectedItem;
get_id_for_cap_det = cp.ID; // get ID
pic_tarikhe_hazine.Text = cp.CDDate;
txt_tozihat.Text = cp.CDDescription;
txtprice.Text = cp.CDPrice + "";
}
catch { }
}
private void Button_Click(object sender, RoutedEventArgs e)
{
capital_id = pass_data.id_capital;
ImportFromExcel.frm_excel frmEx = new ImportFromExcel.frm_excel(grid_tankhah);
frmEx.ShowDialog();
string[,] get_data_array = frmEx.get_data_array();
// gereftane dadeha va zakhire darone data base
CapitalDetail cd;
int save_change_count = 0;
if (get_data_array != null)
{
for (int i = 0, c = 1; i <= get_data_array.GetLength(0) - 2; i++, c++)
{
cd = new CapitalDetail();
cd.IDCapital = capital_id;
cd.ID = Guid.NewGuid(); // new ID
cd.CDDate = get_data_array[i + 1, 0]; /*frmEx.get_data_by_name_index("تاریخ", c);*/
if (/*frmEx.get_data_by_name_index("هزینه", c) */ (get_data_array[i, 1]) != null)
{
//string str = Regex.Replace(frmEx.get_data_by_name_index("هزینه", c), @"[^\d]", "");
string str = Regex.Replace(get_data_array[i + 1, 1], @"[^\d]", "");
cd.CDPrice = decimal.Parse(get_data_array[i + 1, 1]); /* decimal.Parse(str);*/
}
else
{
cd.CDPrice = /*decimal.Parse(get_data_array[i, 1]); */ 0;
}
cd.CDDescription = get_data_array[i + 1, 2]; /*frmEx.get_data_by_name_index("اضافات", c);*/
ak.CapitalDetails.Add(cd);
save_change_count += ak.SaveChanges();
}
if (save_change_count == get_data_array.GetLength(0) - 1) // all data saved
{
MessageBox.Show("ثبت شد");
grid_tankhah.ItemsSource = ak.CapitalDetails.Where(i => i.IDCapital == capital_id).ToList();
}
//
}
}
private void CapitalDetail_Click(object sender, RoutedEventArgs e)
{
JYDataServer.getServerInstance().AddToQryQueue(new CTPRequestContent("ReqCapital", new List <object>()));
if (CapitalDataCollection != null)
{
if (capitalDetailWindow == null)
{
CapitalDetail capitalQuery = new CapitalDetail();
capitalQuery.SetJYRealData(CapitalDataCollection);
capitalDetailWindow = CommonUtil.GetWindow("期货资金账户详情", capitalQuery, plc.API.GetMainWindow());
capitalDetailWindow.Closing += new System.ComponentModel.CancelEventHandler(capitalDetailWindow_Closing);
capitalDetailWindow.Show();
}
else
{
CapitalDetail capitalQuery = capitalDetailWindow.Content as CapitalDetail;
capitalQuery.SetJYRealData(CapitalDataCollection);
capitalDetailWindow.Visibility = Visibility.Visible;
}
}
}
private void btn_sabt_Click(object sender, RoutedEventArgs e)
{
if (pic_tarikhe_hazine.Text.CompareTo(pic_date.Text) >= 0)
{
capital_id = pass_data.id_capital;
if (txt_tozihat.Text != "" && txtprice.Text != "" && pic_date.Text != "")
{
CapitalDetail cpd = new CapitalDetail()
{
ID = Guid.NewGuid(),
CDDate = pic_tarikhe_hazine.Text,
CDDescription = txt_tozihat.Text,
CDPrice = decimal.Parse(txtprice.Text),
IDCapital = capital_id
};
ak.CapitalDetails.Add(cpd);
int bb = ak.SaveChanges();
if (bb == 1)
{
MessageBox.Show("ذخیره شد");
grid_tankhah.ItemsSource = ak.CapitalDetails.Where(i => i.IDCapital == capital_id).ToList();
txt_tozihat.Text = "";
txtprice.Text = "";
}
}
else
{
MessageBox.Show("تمامی مقادیر الزامی میباشد");
}
}
else
{
MessageBox.Show("لطفا تاریخ را به درستی تنظیم نمایید");
}
}
