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; } }