NasimBamdad
دوشنبه 18 دی 1391, 15:45 عصر
سلام و خسته نباشید
یکسری کد دارم که در یک Button نوشته شده اند به صورت زیر
private void buttonX2_Click(object sender, EventArgs e)
{
listBox1.Items.Clear();
navar();
lenz();
daroo_taj_bime();
SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cnn.Open();
cmd.CommandText =
"SELECT Count(*) AS tbl1 FROM dbo.patients WHERE dbo.patients.bime_status = 2 AND dbo.patients.reg_tarikh_shamsi BETWEEN '" +
Date1.VDate + "' AND '" + Date2.VDate + "' AND dbo.patients.canceled = N'کنسل نیست'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cnn.Close();
string countz = Convert.ToString(ds.Tables[0].Rows[0]["tbl1"]);
int conz = Convert.ToInt32(countz);
////////////
SqlConnection cnn2 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = cnn2;
cnn2.Open();
cmd2.CommandText = @"SELECT dbo.patients.id, dbo.patients.fname, dbo.patients.lname, dbo.patients.serialz_daftarche, dbo.patients.tamin_type, dbo.patients.meli_code, dbo.patients.sex,
dbo.patients.nesbat_code, dbo.patients.code_tashkhis_aval, dbo.patients.code_tashkhis_dovom, dbo.patients.code_jarahi, dbo.patients.tarikh_etebar_daf,
dbo.surgeons.serialz AS surgeons_serialz, dbo.nazer_names.serialz AS nazer_serial, dbo.surgeons.specialty_code, dbo.patients.birthday,
dbo.patients.reg_tarikh_shamsi, dbo.patients.marriage, dbo.patients.saat_p, dbo.patients.saat_t, dbo.invoice_daroo_daramad_bime_total.cost_bime AS daroo,
dbo.invoice_tajhiz_daramad_bime_total.cost_bime AS tajhiz, dbo.k_usage2.k_jarahi * dbo.k_jarahi_cost_bime.cost_bime AS Jarah,
dbo.k_usage2.k_bihooshi * dbo.k_bihooshi_cost.cost_bime AS Bihooshi, dbo.k_usage2.k_otaghAmal * dbo.k_otaghAmal_costz.cost_bime AS OtaghAmal,
dbo.invoice_navar_daramad.cost_bime AS navar, dbo.invoice_lenz.cost_bime AS lenz, dbo.patients.tarkhis_date
FROM dbo.patients INNER JOIN
dbo.surgeons ON dbo.patients.surgeon_name = dbo.surgeons.id INNER JOIN
dbo.nazer_names ON dbo.patients.nazer_code = dbo.nazer_names.id LEFT OUTER JOIN
dbo.invoice_lenz ON dbo.patients.id = dbo.invoice_lenz.patientid LEFT OUTER JOIN
dbo.invoice_navar_daramad ON dbo.patients.id = dbo.invoice_navar_daramad.patientid LEFT OUTER JOIN
dbo.k_usage2 ON dbo.patients.id = dbo.k_usage2.patientid LEFT OUTER JOIN
dbo.invoice_daroo_daramad_bime_total ON dbo.patients.id = dbo.invoice_daroo_daramad_bime_total.patientid LEFT OUTER JOIN
dbo.invoice_tajhiz_daramad_bime_total ON dbo.patients.id = dbo.invoice_tajhiz_daramad_bime_total.patientid CROSS JOIN
dbo.k_otaghAmal_costz CROSS JOIN
dbo.k_bihooshi_cost CROSS JOIN
dbo.k_jarahi_cost_bime
WHERE (dbo.patients.bime_status = 2) AND (dbo.patients.reg_tarikh_shamsi BETWEEN '" + Date1.VDate + "' AND '" +
Date2.VDate + "') AND dbo.patients.canceled = N'کنسل نیست'";
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
cnn2.Close();
string fnamez,
lnamez,
idz,
meli_code,
serial_daf,
tamin_type0,
tamin_type = "0",
tarikh_etebar_daf,
sex,
nesbat_code,
marriage,
reg_tarikh_shamsi,
saat_p,
saat_t,
tarkhis_date,
nazer_serial,
code_tashkhis_aval,
code_tashkhis_dovom,
nezam_no,
birthday,
code_jarahi,
daroo90,
tajhiz90,
lenz90,
Navar90,
xmlz = "1.0",
encode = "UTF-8",
invoice_all = string.Empty,
invoice_all_90 = string.Empty;
Int64 cost_total,
jarah_bihooshi_amal0,
Cost_Jarah0,
Cost_Bihooshi0,
Cost_OtaghAmal0,
Daroo0,
Tajhiz0,
Lenz0,
Navar0,
Cost_Jarah,
Cost_Bihooshi,
Cost_OtaghAmal,
Daroo,
Tajhiz,
Lenz,
Navar,
s_invoice_all,
s_invoice_all_90;
bool FLAG = true;
for (int i = 0; i < conz; i++)
{
string empty = string.Empty;
try
{
fnamez = Convert.ToString(ds2.Tables[0].Rows[i]["fname"]);
}
catch
{
fnamez = "";
}
try
{
lnamez = Convert.ToString(ds2.Tables[0].Rows[i]["lname"]);
}
catch
{
lnamez = "";
}
try
{
idz = Convert.ToString(ds2.Tables[0].Rows[i]["id"]);
}
catch
{
idz = "";
}
try
{
meli_code = Convert.ToString(ds2.Tables[0].Rows[i]["meli_code"]);
}
catch
{
meli_code = "";
}
try
{
serial_daf = Convert.ToString(ds2.Tables[0].Rows[i]["serialz_daftarche"]);
}
catch
{
serial_daf = "";
}
try
{
tamin_type0 = Convert.ToString(ds2.Tables[0].Rows[i]["tamin_type"]);
}
catch
{
tamin_type0 = "";
}
if (tamin_type0 == "اجباری")
{
tamin_type = "1";
}
else if (tamin_type0 == "اختیاری")
{
tamin_type = "2";
}
else if (tamin_type0 == "مشاغل آزاد")
{
tamin_type = "3";
}
else if (tamin_type0 == "")
{
tamin_type = "";
}
try
{
tarikh_etebar_daf = Convert.ToString(ds2.Tables[0].Rows[i]["tarikh_etebar_daf"]);
}
catch
{
tarikh_etebar_daf = "";
}
try
{
sex = Convert.ToString(ds2.Tables[0].Rows[i]["sex"]);
}
catch
{
sex = "";
}
try
{
nesbat_code = Convert.ToString(ds2.Tables[0].Rows[i]["nesbat_code"]);
}
catch
{
nesbat_code = "";
}
try
{
marriage = Convert.ToString(ds2.Tables[0].Rows[i]["marriage"]);
}
catch
{
marriage = "";
}
try
{
reg_tarikh_shamsi = Convert.ToString(ds2.Tables[0].Rows[i]["reg_tarikh_shamsi"]);
}
catch
{
reg_tarikh_shamsi = "";
}
try
{
saat_p = Convert.ToString(ds2.Tables[0].Rows[i]["saat_p"]);
}
catch
{
saat_p = "";
}
try
{
saat_t = Convert.ToString(ds2.Tables[0].Rows[i]["saat_t"]);
}
catch
{
saat_t = "";
}
try
{
tarkhis_date = Convert.ToString(ds2.Tables[0].Rows[i]["tarkhis_date"]);
}
catch
{
tarkhis_date = "";
}
try
{
nazer_serial = Convert.ToString(ds2.Tables[0].Rows[i]["nazer_serial"]);
}
catch
{
nazer_serial = "";
}
try
{
code_tashkhis_aval = Convert.ToString(ds2.Tables[0].Rows[i]["code_tashkhis_aval"]);
}
catch
{
code_tashkhis_aval = "";
}
try
{
code_tashkhis_dovom = Convert.ToString(ds2.Tables[0].Rows[i]["code_tashkhis_dovom"]);
}
catch
{
code_tashkhis_dovom = "";
}
try
{
nezam_no = Convert.ToString(ds2.Tables[0].Rows[i]["surgeons_serialz"]);
}
catch
{
nezam_no = "";
}
try
{
birthday = Convert.ToString(ds2.Tables[0].Rows[i]["birthday"]);
}
catch
{
birthday = "";
}
try
{
code_jarahi = Convert.ToString(ds2.Tables[0].Rows[i]["code_jarahi"]);
}
catch
{
code_jarahi = "";
}
try
{
Cost_Jarah0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["Jarah"]);
Cost_Jarah = (int) Cost_Jarah0;
}
catch
{
Cost_Jarah = 0;
}
try
{
Cost_Bihooshi0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["Bihooshi"]);
Cost_Bihooshi = (int) Cost_Bihooshi0;
}
catch
{
Cost_Bihooshi = 0;
}
try
{
Cost_OtaghAmal0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["OtaghAmal"]);
Cost_OtaghAmal = (int) Cost_OtaghAmal0;
}
catch
{
Cost_OtaghAmal = 0;
}
try
{
Daroo0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["daroo"]);
Daroo = (int) Daroo0;
}
catch
{
Daroo = 0;
}
try
{
Tajhiz0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["tajhiz"]);
Tajhiz = (int) Tajhiz0;
}
catch
{
Tajhiz = 0;
}
try
{
Lenz0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["lenz"]);
Lenz = (int) Lenz0;
}
catch
{
Lenz = 0;
}
try
{
Navar0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["navar"]);
Navar = (int) Navar0;
}
catch
{
Navar = 0;
}
double dro9 = Daroo;
double dro90 = Math.Round((dro9*90)/100);
daroo90 = Convert.ToString(dro90);
////////////
double tjh9 = Tajhiz;
double tjh90 = Math.Round((tjh9*90)/100);
tajhiz90 = Convert.ToString(tjh90);
////////////
double lnz9 = Lenz;
double lnz90 = Math.Round((lnz9*90)/100);
lenz90 = Convert.ToString(lnz90);
////////////
double nvr9 = Navar;
double nvr90 = Math.Round((nvr9*90)/100);
Navar90 = Convert.ToString(nvr90);
cost_total = Cost_Jarah + Cost_Bihooshi + Cost_OtaghAmal + Daroo + Tajhiz + Lenz + Navar;
double shm_bmr = cost_total;
double shm_bmr90 = Math.Round((shm_bmr*90)/100);
double shm_bmr10 = Math.Round((shm_bmr*10)/100);
jarah_bihooshi_amal0 = Cost_Jarah + Cost_Bihooshi + Cost_OtaghAmal;
double jba = jarah_bihooshi_amal0;
double jba90 = Math.Round((jba*90)/100);
if (sex == "مرد")
{
sex = "1";
}
else if (sex == "زن")
{
sex = "2";
}
string daf_date_Total = tarikh_etebar_daf.Replace("/", "");
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string date_paz = reg_tarikh_shamsi.Replace("/", "");
string saat_paz = saat_p.Replace(":", "");
string date_p_total = date_paz + saat_paz;
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string tarkhis_saat = saat_t.Replace(":", "");
string tarkhis_date0 = tarkhis_date.Replace("/", "");
string date_t_total = tarkhis_date0 + tarkhis_saat;
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string birthday_total = birthday.Replace("/", "");
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
jarah_all += Cost_Jarah;
bihooshi_all += Cost_Bihooshi;
otagh_all += Cost_OtaghAmal;
daroo_all += Daroo;
tajhiz_all += Tajhiz;
lenz_all += Lenz;
navar_all += Navar;
s_invoice_all = jarah_all + bihooshi_all + otagh_all + daroo_all + tajhiz_all + lenz_all + navar_all;
double inv_all = s_invoice_all;
double inv_all_90 = Math.Round((inv_all * 90) / 100);
textBox1.Text = Convert.ToString(s_invoice_all);
textBox2.Text = Convert.ToString(inv_all_90);
if (FLAG)
{
listBox1.Items.Add("<?XML version=\"" + xmlz + "\" encoding=\"" + encode + "\" ?>");
listBox1.Items.Add("<BILL_SPEC AA=\"" + 160 + "\" AB=\"" + txtProNet1.Text + "\" AC=\"" + conz +
"\" AD =\"" + textBox1.Text + "\" AE=\"" + textBox2.Text + "\" AF=\"" +
string.Empty + "\">");
FLAG = false;
}
counter = i + 1;
listBox1.Items.Add("<FORM_ADS BA=\"" + counter + "\" BB=\"" + 103 + "\" BC=\"" + serial_daf +
"\" BD=\"" + empty + "\" BE=\"" + tamin_type + "\" BF=\"" + daf_date_Total +
"\" BG=\"" + meli_code + "\" BH=\"" + idz + "\" BI=\"" + lnamez + "\" BJ=\"" +
fnamez + "\" BK=\"" + empty + "\" BL=\"" + sex + "\" BM=\"" + nesbat_code +
"\" BN=\"" + marriage + "\" BO=\"" + birthday_total + "\" BP=\"" + date_p_total +
"\" BQ=\"" + date_t_total + "\" BR=\"" + nezam_no + "\" BS=\"" + empty +
"\" BT=\"" + 1 + "\" BU=\"" + empty + "\" BV=\"" + 1 + "\" BW=\"" + 1 +
"\" BX=\"" + code_tashkhis_aval + "\" BYY=\"" + nazer_serial + "\" BZ=\"" +
cost_total + "\" CB=\"" + code_tashkhis_dovom + "\" EB=\"" + code_jarahi +
"\" BAA=\"" + shm_bmr90 + "\" BAB=\"" + 0 + "\" BAC=\"" + 0 + "\" BAD=\"" + 0 +
"\" BAD=\"" + 0 + "\" BAE=\"" + 0 + "\" BAF=\"" + shm_bmr10 + "\">");
//listBox1.Items.Add(" <GLOBAL GA=\"" + empty + "\" GB=\"" + empty + "\" GC=\"" + empty + "\" GD=\"" + empty + "\" GE=\"" + empty + "\" />");
//listBox1.Items.Add(" <HOTELING HA=\"" + empty + "\" HB=\"" + empty + "\" HC=\"" + empty + "\" HD=\"" + empty + "\" HE=\"" + empty + "\" HF=\"" + empty + "\" HG=\"" + empty + "\" />");
//listBox1.Items.Add("");
//listBox1.Items.Add(" <PAR_HEAD PA=\"" + empty + "\" PB=\"" + empty + "\" PC=\"" + empty + "\" PD=\"" + empty + "\" PE=\"" + empty + "\" PF=\"" + empty + "\" />");
//listBox1.Items.Add("");
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 1 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Daroo + "\" JF=\"" + daroo90 + "\" />");
if (Convert.ToInt32(Lenz) != 0)
{
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 2 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Lenz + "\" JF=\"" + lenz90 + "\" />");
}
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 3 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Tajhiz + "\" JF=\"" + tajhiz90 + "\" />");
if (Convert.ToInt32(Navar) != 0)
{
listBox1.Items.Add("<SAR_HEAD KA=\"" + 1 + "\" KB=\"" + 3 + "\" KC=\"" + 0 + "\" KD=\"" + 0 +
"\" KE=\"" + 70039 + "\" KF=\"" + 0 + "\" KG=\"" + 1 + "\" KH=\"" + Navar +
"\" KI=\"" + Navar90 + "\" />");
}
listBox1.Items.Add("<OR DA=\"" + Cost_Jarah + "\" DB=\"" + 0 + "\" DC=\"" + Cost_Bihooshi +
"\" DD=\"" + 0 + "\" DE=\"" + 0 + "\" DF=\"" + 0 + "\" DG=\"" + 0 + "\" DG=\"" +
0 + "\" DH=\"" + 0 + "\" DI=\"" + 0 + "\" DJ=\"" + 0 + "\" DK=\"" + 0 +
"\" DL=\"" + 0 + "\" DM=\"" + Cost_OtaghAmal + "\" DN=\"" + jba +
"\" DO=\"" + jba90 + "\"");
listBox1.Items.Add("</FORM_ADS>");
}
listBox1.Items.Add("<BILL_SPEC>");
}
و کد های زیر هم در قسمت تابع سازنده یا public partial class تعریف شدند
SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd = new SqlCommand();
public Int64 jarah_all;
public Int64 bihooshi_all;
public Int64 otagh_all;
public Int64 daroo_all;
public Int64 tajhiz_all;
public Int64 lenz_all;
public Int64 navar_all;
int counter = 1;
در بین کد هام خط زیر رو دارم که در بالا بعد از if(flag) اومده خط 421
"\" AD =\"" + textBox1.Text + "\" AE=\"" + textBox2.Text + "\" AF=\"" +
به جای textBox1.text و textBox2.text باید 2 تا عدد که در بین همین کد ها بدست میاد رو قراربدم
2 متغییر inv_all و inv_all_90 که در کد بالا موجود هست . خط 411 و 412
double inv_all = s_invoice_all;
double inv_all_90 = Math.Round((inv_all * 90) / 100);
چه طوری می تونم بعد از اینکه حلقه انجام شد و از جلقه خارج شدیم و در نهایت به قسمت آخر کد رسیدیم مقادیر این 2 متغییر رو بالای لیست باکسم جا بدم . یعنی مقدار 2 تگ AD و AE که در بالا توضیح دادم
خیلی پیچیده و گنگ هست ، اگه نیاز هست بفرمایید بیشتر بگم .
در واقع باید بگم بعد از کار بگیم که مثلا خط چهارم موجود در ListBox پاک بشه در ListBox و یک خط دیگه جای اون رو بگیره
این طور کاری عملی هست ؟
یکسری کد دارم که در یک Button نوشته شده اند به صورت زیر
private void buttonX2_Click(object sender, EventArgs e)
{
listBox1.Items.Clear();
navar();
lenz();
daroo_taj_bime();
SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cnn.Open();
cmd.CommandText =
"SELECT Count(*) AS tbl1 FROM dbo.patients WHERE dbo.patients.bime_status = 2 AND dbo.patients.reg_tarikh_shamsi BETWEEN '" +
Date1.VDate + "' AND '" + Date2.VDate + "' AND dbo.patients.canceled = N'کنسل نیست'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cnn.Close();
string countz = Convert.ToString(ds.Tables[0].Rows[0]["tbl1"]);
int conz = Convert.ToInt32(countz);
////////////
SqlConnection cnn2 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = cnn2;
cnn2.Open();
cmd2.CommandText = @"SELECT dbo.patients.id, dbo.patients.fname, dbo.patients.lname, dbo.patients.serialz_daftarche, dbo.patients.tamin_type, dbo.patients.meli_code, dbo.patients.sex,
dbo.patients.nesbat_code, dbo.patients.code_tashkhis_aval, dbo.patients.code_tashkhis_dovom, dbo.patients.code_jarahi, dbo.patients.tarikh_etebar_daf,
dbo.surgeons.serialz AS surgeons_serialz, dbo.nazer_names.serialz AS nazer_serial, dbo.surgeons.specialty_code, dbo.patients.birthday,
dbo.patients.reg_tarikh_shamsi, dbo.patients.marriage, dbo.patients.saat_p, dbo.patients.saat_t, dbo.invoice_daroo_daramad_bime_total.cost_bime AS daroo,
dbo.invoice_tajhiz_daramad_bime_total.cost_bime AS tajhiz, dbo.k_usage2.k_jarahi * dbo.k_jarahi_cost_bime.cost_bime AS Jarah,
dbo.k_usage2.k_bihooshi * dbo.k_bihooshi_cost.cost_bime AS Bihooshi, dbo.k_usage2.k_otaghAmal * dbo.k_otaghAmal_costz.cost_bime AS OtaghAmal,
dbo.invoice_navar_daramad.cost_bime AS navar, dbo.invoice_lenz.cost_bime AS lenz, dbo.patients.tarkhis_date
FROM dbo.patients INNER JOIN
dbo.surgeons ON dbo.patients.surgeon_name = dbo.surgeons.id INNER JOIN
dbo.nazer_names ON dbo.patients.nazer_code = dbo.nazer_names.id LEFT OUTER JOIN
dbo.invoice_lenz ON dbo.patients.id = dbo.invoice_lenz.patientid LEFT OUTER JOIN
dbo.invoice_navar_daramad ON dbo.patients.id = dbo.invoice_navar_daramad.patientid LEFT OUTER JOIN
dbo.k_usage2 ON dbo.patients.id = dbo.k_usage2.patientid LEFT OUTER JOIN
dbo.invoice_daroo_daramad_bime_total ON dbo.patients.id = dbo.invoice_daroo_daramad_bime_total.patientid LEFT OUTER JOIN
dbo.invoice_tajhiz_daramad_bime_total ON dbo.patients.id = dbo.invoice_tajhiz_daramad_bime_total.patientid CROSS JOIN
dbo.k_otaghAmal_costz CROSS JOIN
dbo.k_bihooshi_cost CROSS JOIN
dbo.k_jarahi_cost_bime
WHERE (dbo.patients.bime_status = 2) AND (dbo.patients.reg_tarikh_shamsi BETWEEN '" + Date1.VDate + "' AND '" +
Date2.VDate + "') AND dbo.patients.canceled = N'کنسل نیست'";
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
cnn2.Close();
string fnamez,
lnamez,
idz,
meli_code,
serial_daf,
tamin_type0,
tamin_type = "0",
tarikh_etebar_daf,
sex,
nesbat_code,
marriage,
reg_tarikh_shamsi,
saat_p,
saat_t,
tarkhis_date,
nazer_serial,
code_tashkhis_aval,
code_tashkhis_dovom,
nezam_no,
birthday,
code_jarahi,
daroo90,
tajhiz90,
lenz90,
Navar90,
xmlz = "1.0",
encode = "UTF-8",
invoice_all = string.Empty,
invoice_all_90 = string.Empty;
Int64 cost_total,
jarah_bihooshi_amal0,
Cost_Jarah0,
Cost_Bihooshi0,
Cost_OtaghAmal0,
Daroo0,
Tajhiz0,
Lenz0,
Navar0,
Cost_Jarah,
Cost_Bihooshi,
Cost_OtaghAmal,
Daroo,
Tajhiz,
Lenz,
Navar,
s_invoice_all,
s_invoice_all_90;
bool FLAG = true;
for (int i = 0; i < conz; i++)
{
string empty = string.Empty;
try
{
fnamez = Convert.ToString(ds2.Tables[0].Rows[i]["fname"]);
}
catch
{
fnamez = "";
}
try
{
lnamez = Convert.ToString(ds2.Tables[0].Rows[i]["lname"]);
}
catch
{
lnamez = "";
}
try
{
idz = Convert.ToString(ds2.Tables[0].Rows[i]["id"]);
}
catch
{
idz = "";
}
try
{
meli_code = Convert.ToString(ds2.Tables[0].Rows[i]["meli_code"]);
}
catch
{
meli_code = "";
}
try
{
serial_daf = Convert.ToString(ds2.Tables[0].Rows[i]["serialz_daftarche"]);
}
catch
{
serial_daf = "";
}
try
{
tamin_type0 = Convert.ToString(ds2.Tables[0].Rows[i]["tamin_type"]);
}
catch
{
tamin_type0 = "";
}
if (tamin_type0 == "اجباری")
{
tamin_type = "1";
}
else if (tamin_type0 == "اختیاری")
{
tamin_type = "2";
}
else if (tamin_type0 == "مشاغل آزاد")
{
tamin_type = "3";
}
else if (tamin_type0 == "")
{
tamin_type = "";
}
try
{
tarikh_etebar_daf = Convert.ToString(ds2.Tables[0].Rows[i]["tarikh_etebar_daf"]);
}
catch
{
tarikh_etebar_daf = "";
}
try
{
sex = Convert.ToString(ds2.Tables[0].Rows[i]["sex"]);
}
catch
{
sex = "";
}
try
{
nesbat_code = Convert.ToString(ds2.Tables[0].Rows[i]["nesbat_code"]);
}
catch
{
nesbat_code = "";
}
try
{
marriage = Convert.ToString(ds2.Tables[0].Rows[i]["marriage"]);
}
catch
{
marriage = "";
}
try
{
reg_tarikh_shamsi = Convert.ToString(ds2.Tables[0].Rows[i]["reg_tarikh_shamsi"]);
}
catch
{
reg_tarikh_shamsi = "";
}
try
{
saat_p = Convert.ToString(ds2.Tables[0].Rows[i]["saat_p"]);
}
catch
{
saat_p = "";
}
try
{
saat_t = Convert.ToString(ds2.Tables[0].Rows[i]["saat_t"]);
}
catch
{
saat_t = "";
}
try
{
tarkhis_date = Convert.ToString(ds2.Tables[0].Rows[i]["tarkhis_date"]);
}
catch
{
tarkhis_date = "";
}
try
{
nazer_serial = Convert.ToString(ds2.Tables[0].Rows[i]["nazer_serial"]);
}
catch
{
nazer_serial = "";
}
try
{
code_tashkhis_aval = Convert.ToString(ds2.Tables[0].Rows[i]["code_tashkhis_aval"]);
}
catch
{
code_tashkhis_aval = "";
}
try
{
code_tashkhis_dovom = Convert.ToString(ds2.Tables[0].Rows[i]["code_tashkhis_dovom"]);
}
catch
{
code_tashkhis_dovom = "";
}
try
{
nezam_no = Convert.ToString(ds2.Tables[0].Rows[i]["surgeons_serialz"]);
}
catch
{
nezam_no = "";
}
try
{
birthday = Convert.ToString(ds2.Tables[0].Rows[i]["birthday"]);
}
catch
{
birthday = "";
}
try
{
code_jarahi = Convert.ToString(ds2.Tables[0].Rows[i]["code_jarahi"]);
}
catch
{
code_jarahi = "";
}
try
{
Cost_Jarah0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["Jarah"]);
Cost_Jarah = (int) Cost_Jarah0;
}
catch
{
Cost_Jarah = 0;
}
try
{
Cost_Bihooshi0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["Bihooshi"]);
Cost_Bihooshi = (int) Cost_Bihooshi0;
}
catch
{
Cost_Bihooshi = 0;
}
try
{
Cost_OtaghAmal0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["OtaghAmal"]);
Cost_OtaghAmal = (int) Cost_OtaghAmal0;
}
catch
{
Cost_OtaghAmal = 0;
}
try
{
Daroo0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["daroo"]);
Daroo = (int) Daroo0;
}
catch
{
Daroo = 0;
}
try
{
Tajhiz0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["tajhiz"]);
Tajhiz = (int) Tajhiz0;
}
catch
{
Tajhiz = 0;
}
try
{
Lenz0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["lenz"]);
Lenz = (int) Lenz0;
}
catch
{
Lenz = 0;
}
try
{
Navar0 = Convert.ToInt64(ds2.Tables[0].Rows[i]["navar"]);
Navar = (int) Navar0;
}
catch
{
Navar = 0;
}
double dro9 = Daroo;
double dro90 = Math.Round((dro9*90)/100);
daroo90 = Convert.ToString(dro90);
////////////
double tjh9 = Tajhiz;
double tjh90 = Math.Round((tjh9*90)/100);
tajhiz90 = Convert.ToString(tjh90);
////////////
double lnz9 = Lenz;
double lnz90 = Math.Round((lnz9*90)/100);
lenz90 = Convert.ToString(lnz90);
////////////
double nvr9 = Navar;
double nvr90 = Math.Round((nvr9*90)/100);
Navar90 = Convert.ToString(nvr90);
cost_total = Cost_Jarah + Cost_Bihooshi + Cost_OtaghAmal + Daroo + Tajhiz + Lenz + Navar;
double shm_bmr = cost_total;
double shm_bmr90 = Math.Round((shm_bmr*90)/100);
double shm_bmr10 = Math.Round((shm_bmr*10)/100);
jarah_bihooshi_amal0 = Cost_Jarah + Cost_Bihooshi + Cost_OtaghAmal;
double jba = jarah_bihooshi_amal0;
double jba90 = Math.Round((jba*90)/100);
if (sex == "مرد")
{
sex = "1";
}
else if (sex == "زن")
{
sex = "2";
}
string daf_date_Total = tarikh_etebar_daf.Replace("/", "");
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string date_paz = reg_tarikh_shamsi.Replace("/", "");
string saat_paz = saat_p.Replace(":", "");
string date_p_total = date_paz + saat_paz;
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string tarkhis_saat = saat_t.Replace(":", "");
string tarkhis_date0 = tarkhis_date.Replace("/", "");
string date_t_total = tarkhis_date0 + tarkhis_saat;
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
string birthday_total = birthday.Replace("/", "");
//\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
jarah_all += Cost_Jarah;
bihooshi_all += Cost_Bihooshi;
otagh_all += Cost_OtaghAmal;
daroo_all += Daroo;
tajhiz_all += Tajhiz;
lenz_all += Lenz;
navar_all += Navar;
s_invoice_all = jarah_all + bihooshi_all + otagh_all + daroo_all + tajhiz_all + lenz_all + navar_all;
double inv_all = s_invoice_all;
double inv_all_90 = Math.Round((inv_all * 90) / 100);
textBox1.Text = Convert.ToString(s_invoice_all);
textBox2.Text = Convert.ToString(inv_all_90);
if (FLAG)
{
listBox1.Items.Add("<?XML version=\"" + xmlz + "\" encoding=\"" + encode + "\" ?>");
listBox1.Items.Add("<BILL_SPEC AA=\"" + 160 + "\" AB=\"" + txtProNet1.Text + "\" AC=\"" + conz +
"\" AD =\"" + textBox1.Text + "\" AE=\"" + textBox2.Text + "\" AF=\"" +
string.Empty + "\">");
FLAG = false;
}
counter = i + 1;
listBox1.Items.Add("<FORM_ADS BA=\"" + counter + "\" BB=\"" + 103 + "\" BC=\"" + serial_daf +
"\" BD=\"" + empty + "\" BE=\"" + tamin_type + "\" BF=\"" + daf_date_Total +
"\" BG=\"" + meli_code + "\" BH=\"" + idz + "\" BI=\"" + lnamez + "\" BJ=\"" +
fnamez + "\" BK=\"" + empty + "\" BL=\"" + sex + "\" BM=\"" + nesbat_code +
"\" BN=\"" + marriage + "\" BO=\"" + birthday_total + "\" BP=\"" + date_p_total +
"\" BQ=\"" + date_t_total + "\" BR=\"" + nezam_no + "\" BS=\"" + empty +
"\" BT=\"" + 1 + "\" BU=\"" + empty + "\" BV=\"" + 1 + "\" BW=\"" + 1 +
"\" BX=\"" + code_tashkhis_aval + "\" BYY=\"" + nazer_serial + "\" BZ=\"" +
cost_total + "\" CB=\"" + code_tashkhis_dovom + "\" EB=\"" + code_jarahi +
"\" BAA=\"" + shm_bmr90 + "\" BAB=\"" + 0 + "\" BAC=\"" + 0 + "\" BAD=\"" + 0 +
"\" BAD=\"" + 0 + "\" BAE=\"" + 0 + "\" BAF=\"" + shm_bmr10 + "\">");
//listBox1.Items.Add(" <GLOBAL GA=\"" + empty + "\" GB=\"" + empty + "\" GC=\"" + empty + "\" GD=\"" + empty + "\" GE=\"" + empty + "\" />");
//listBox1.Items.Add(" <HOTELING HA=\"" + empty + "\" HB=\"" + empty + "\" HC=\"" + empty + "\" HD=\"" + empty + "\" HE=\"" + empty + "\" HF=\"" + empty + "\" HG=\"" + empty + "\" />");
//listBox1.Items.Add("");
//listBox1.Items.Add(" <PAR_HEAD PA=\"" + empty + "\" PB=\"" + empty + "\" PC=\"" + empty + "\" PD=\"" + empty + "\" PE=\"" + empty + "\" PF=\"" + empty + "\" />");
//listBox1.Items.Add("");
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 1 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Daroo + "\" JF=\"" + daroo90 + "\" />");
if (Convert.ToInt32(Lenz) != 0)
{
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 2 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Lenz + "\" JF=\"" + lenz90 + "\" />");
}
listBox1.Items.Add("<PHA_HEAD JA=\"" + 1 + "\" JB=\"" + 3 + "\" JC=\"" + 2 + "\" JD=\"" + 1 +
"\" JE=\"" + Tajhiz + "\" JF=\"" + tajhiz90 + "\" />");
if (Convert.ToInt32(Navar) != 0)
{
listBox1.Items.Add("<SAR_HEAD KA=\"" + 1 + "\" KB=\"" + 3 + "\" KC=\"" + 0 + "\" KD=\"" + 0 +
"\" KE=\"" + 70039 + "\" KF=\"" + 0 + "\" KG=\"" + 1 + "\" KH=\"" + Navar +
"\" KI=\"" + Navar90 + "\" />");
}
listBox1.Items.Add("<OR DA=\"" + Cost_Jarah + "\" DB=\"" + 0 + "\" DC=\"" + Cost_Bihooshi +
"\" DD=\"" + 0 + "\" DE=\"" + 0 + "\" DF=\"" + 0 + "\" DG=\"" + 0 + "\" DG=\"" +
0 + "\" DH=\"" + 0 + "\" DI=\"" + 0 + "\" DJ=\"" + 0 + "\" DK=\"" + 0 +
"\" DL=\"" + 0 + "\" DM=\"" + Cost_OtaghAmal + "\" DN=\"" + jba +
"\" DO=\"" + jba90 + "\"");
listBox1.Items.Add("</FORM_ADS>");
}
listBox1.Items.Add("<BILL_SPEC>");
}
و کد های زیر هم در قسمت تابع سازنده یا public partial class تعریف شدند
SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand cmd = new SqlCommand();
public Int64 jarah_all;
public Int64 bihooshi_all;
public Int64 otagh_all;
public Int64 daroo_all;
public Int64 tajhiz_all;
public Int64 lenz_all;
public Int64 navar_all;
int counter = 1;
در بین کد هام خط زیر رو دارم که در بالا بعد از if(flag) اومده خط 421
"\" AD =\"" + textBox1.Text + "\" AE=\"" + textBox2.Text + "\" AF=\"" +
به جای textBox1.text و textBox2.text باید 2 تا عدد که در بین همین کد ها بدست میاد رو قراربدم
2 متغییر inv_all و inv_all_90 که در کد بالا موجود هست . خط 411 و 412
double inv_all = s_invoice_all;
double inv_all_90 = Math.Round((inv_all * 90) / 100);
چه طوری می تونم بعد از اینکه حلقه انجام شد و از جلقه خارج شدیم و در نهایت به قسمت آخر کد رسیدیم مقادیر این 2 متغییر رو بالای لیست باکسم جا بدم . یعنی مقدار 2 تگ AD و AE که در بالا توضیح دادم
خیلی پیچیده و گنگ هست ، اگه نیاز هست بفرمایید بیشتر بگم .
در واقع باید بگم بعد از کار بگیم که مثلا خط چهارم موجود در ListBox پاک بشه در ListBox و یک خط دیگه جای اون رو بگیره
این طور کاری عملی هست ؟