public void BinData(string strWhere)
{
try
{
DATA0011 info = new DATA0011();
DATA0011BLL bll = new DATA0011BLL(Frm.DBConnection);
info = bll.getDATA0011ByRKEY(Frm.id_rkey);
if (info.RKEY > 0)
{
Frm.textBox.Text = info.NOTE_PAD_LINE_1.Trim() + info.NOTE_PAD_LINE_2.Trim() + info.NOTE_PAD_LINE_3.Trim() + info.NOTE_PAD_LINE_4.Trim();
}
else
{
Frm.textBox.Text = "";
}
if (Frm.is_memo.Trim().Length > 0)
{
Frm.textBox.Text = Frm.is_memo.Trim();
}
if (!Frm.ib_Edit)
{
Frm.textBox.ReadOnly = true;
Frm.buttonFind.Visible = false;
}
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
public void BinData(string strWhere)
{
try
{
IList <DATA0583> info = new List <DATA0583>();
DATA0011 infoD11 = new DATA0011();
DATA0583BLL bll = new DATA0583BLL(Frm.DBConnection);
DATA0011BLL bllD11 = new DATA0011BLL(Frm.DBConnection);
string s_temp;
info = bll.FindBySql("SOURCE_PTR = " + Frm.id_rkey.ToString() + " and SOURCE_TYPE = " + Frm.id_TYPE.ToString());
for (int i = 0; i < info.Count; i++)
{
s_temp = "";
if (info[i].ACTION == 1)
{
s_temp = "原值暂缓";
}
if (info[i].ACTION == 2)
{
s_temp = "原值激活";
}
infoD11 = bllD11.getDATA0011ByRKEY(info[i].NOTEPAD_PTR);
Frm.textBox.Text = "日期：" + info[i].TDATE.ToShortDateString() + " " + s_temp + "\r\n" +
infoD11.NOTE_PAD_LINE_1.Trim() + infoD11.NOTE_PAD_LINE_2.Trim() + infoD11.NOTE_PAD_LINE_3.Trim() + infoD11.NOTE_PAD_LINE_4.Trim() + "\r\n\r\n";
}
if (info.Count <= 0)
{
Frm.textBox.Text = "没有暂缓历史记录！";
}
if (!Frm.ib_Edit)
{
Frm.textBox.ReadOnly = true;
Frm.textBoxRecord.ReadOnly = true;
}
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
public void BinData(string strWhere)
{
try
{
DATA0011 info = new DATA0011();
DATA0011BLL bll = new DATA0011BLL(Frm.DBConnection);
DataTable tb;
string s_SQL = "";
info = bll.getDATA0011ByRKEY(Frm.id_rkey);
if (info.RKEY > 0)
{
Frm.textBox.Text = info.NOTE_PAD_LINE_1.Trim() + info.NOTE_PAD_LINE_2.Trim() + info.NOTE_PAD_LINE_3.Trim() + info.NOTE_PAD_LINE_4.Trim();
}
else
{
Frm.textBox.Text = "";
}
if (Frm.ii_Sort == 500)
{//拒绝
s_SQL = @"
select *
from data0011 with (nolock),data0500 with (nolock)
where data0011.FILE_POINTER = data0500.rkey
and data0011.SOURCE_TYPE = 500
and data0500.CUSTOMER_PART_PTR = " + Frm.id_Sort_RKEY.ToString() + @"
order by data0011.rkey
";
}
if (Frm.ii_Sort == 501)
{//拒绝
s_SQL = @"
select *
from data0011 with (nolock),data0500 with (nolock)
where data0011.FILE_POINTER = data0500.rkey
and data0011.SOURCE_TYPE = 501
and data0500.CUSTOMER_PART_PTR = " + Frm.id_Sort_RKEY.ToString() + @"
order by data0011.rkey
";
}
tb = bll.getDataSet(s_SQL);
Frm.textBoxOLD.Text = "";
if (tb.Rows.Count > 0)
{
Frm.textBoxOLD.Text += tb.Rows[0]["NOTE_PAD_LINE_1"].ToString().Trim();
Frm.textBoxOLD.Text += tb.Rows[0]["NOTE_PAD_LINE_2"].ToString().Trim();
Frm.textBoxOLD.Text += tb.Rows[0]["NOTE_PAD_LINE_3"].ToString().Trim();
Frm.textBoxOLD.Text += tb.Rows[0]["NOTE_PAD_LINE_4"].ToString().Trim();
Frm.textBoxOLD.Text += "\r\n\r\n";
}
if (!Frm.ib_Edit)
{
Frm.textBox.ReadOnly = true;
Frm.buttonFind.Visible = false;
}
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}