void dataGridView1_DoubleClick(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count > 0 && this.dataGridView1.CurrentRow != null)
{
DataRow row = ((DataRowView)this.dataGridView1.CurrentRow.DataBoundItem).Row;
selectionExecDept = new TrasenFrame.Classes.Department(Convert.ToInt32(row["dept_id"]), InstanceForm.BDatabase);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == '\r' && this.dataGridView1.Rows.Count > 0)
{
DataRow row = ((DataRowView)this.dataGridView1.CurrentRow.DataBoundItem).Row;
selectionExecDept = new TrasenFrame.Classes.Department(Convert.ToInt32(row["dept_id"]), InstanceForm.BDatabase);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
/// <summary>
/// 根据指定编号实例化项目
/// </summary>
/// <param name="ItemId"></param>
public OrderItem(int OrderID)
{
try
{
// sql 语句增加 关于收费项目是否已删除
string sql = @"select a.*,b.name,c.hditem_id,c.tc_flag,c.num ,e.yzid,e.jclxid,f.bbid,f.hylxid
,(select top 1 DELETE_BIT from
(
(select DELETE_BIT from jc_hsitem where ITEM_ID =c.hditem_id and c.TC_FLAG=0)
union
(select DELETE_BIT from jc_tc_t where ITEM_ID =c.HDITEM_ID and c.TC_FLAG=1)
) as aa) as DELETE_BIT_sfxm
from jc_hoitemdiction a left join jc_ordertype b on a.order_type=b.code left join jc_hoi_hdi c on a.order_id=c.hoitem_id
left join jc_jc_item e on a.order_id=e.yzid left join jc_assay f on a.order_id=f.yzid where a.order_id = " + OrderID;
DataRow dr = InstanceForm.BDatabase.GetDataRow(sql);
if (dr != null)
{
_order_id = OrderID;
_order_name = Convert.IsDBNull(dr["order_name"]) ? "":dr["order_name"].ToString().Trim();
_py_code = Convert.IsDBNull(dr["py_code"]) ? "":dr["py_code"].ToString().Trim();
_wb_code = Convert.IsDBNull(dr["wb_code"]) ? "" : dr["wb_code"].ToString().Trim();
_order_unit = Convert.IsDBNull(dr["order_unit"]) ? "" : dr["order_unit"].ToString();
_order_type_id = Convert.IsDBNull(dr["order_type"]) ? 0 : Convert.ToInt32(Convertor.IsNull(dr["order_type"], "0"));
_order_type_name = Convert.IsDBNull(dr["name"]) ? "" : Convertor.IsNull(dr["name"], "");
_delete_bit = Convert.IsDBNull(dr["delete_bit"]) ? 0 : Convert.ToInt32(Convertor.IsNull(dr["delete_bit"], "0"));
_default_exec_dept = Convert.ToInt32(Convertor.IsNull(dr["default_dept"], "0"));
_usage = Convert.IsDBNull(dr["default_usage"]) ? "" : dr["default_usage"].ToString().Trim();
_item_exec_num = Convert.IsDBNull(dr["num"]) ? 1 : Convert.ToInt32(dr["num"]);
bz = Convert.IsDBNull(dr["bz"]) ? "" : dr["bz"].ToString().Trim();
_d_code = Convert.IsDBNull(dr["d_code"]) ? "" : dr["d_code"].ToString().Trim();
//2012-11-21 增加 附加说明必填
if (Convert.IsDBNull(dr["FJSMBT"]) == false && dr["FJSMBT"].ToString() == "1")
{
_fjsmbt = byte.Parse("1");
}
else
{
_fjsmbt = byte.Parse("0");
}
_sfxm_delete_bit = int.Parse(Convert.IsDBNull(dr["DELETE_BIT_sfxm"]) ? "0" : dr["DELETE_BIT_sfxm"].ToString().Trim());
if (dr["hditem_id"] != null && !Convert.IsDBNull(dr["hditem_id"]))
{
_charge_item_id = Convert.IsDBNull(dr["hditem_id"]) ? 0 : Convert.ToInt32(dr["hditem_id"]);
_match_type = Convert.IsDBNull(dr["tc_flag"]) ? 0 : Convert.ToInt32(dr["tc_flag"]);
if (_match_type == 0)
{
sql = "select item_name from jc_hsitem where item_id=" + _charge_item_id;
}
else
{
sql = "select item_name from jc_tc_t where item_id=" + _charge_item_id;
}
DataRow drItem = InstanceForm.BDatabase.GetDataRow(sql);
if (drItem != null)
{
_charge_item_name = Convert.IsDBNull(drItem[0]) ? "" : drItem[0].ToString().Trim();
}
else
{
_charge_item_name = "";
}
}
else
{
_charge_item_id = 0;
}
_execdeptList = new ArrayList();
DataTable tableDept = this.GetExecDeptDataTable();
for (int i = 0; i < tableDept.Rows.Count; i++)
{
TrasenFrame.Classes.Department dept = new TrasenFrame.Classes.Department();
dept.DeptId = Convert.IsDBNull(tableDept.Rows[i]["dept_id"]) ? 0 : Convert.ToInt32(tableDept.Rows[i]["dept_id"]);
dept.DeptName = Convert.IsDBNull(tableDept.Rows[i]["name"]) ? "" : tableDept.Rows[i]["name"].ToString().Trim();
if (dept.DeptId == _default_exec_dept)
{
dept.Default = 1;
}
_execdeptList.Add(dept);
}
//判断是检查还是化验项目
this.isJCorHy = 0;
//////////////////////
sql = "select * from jc_jc_item where yzid=" + OrderID;
DataRow drTmp = InstanceForm.BDatabase.GetDataRow(sql);
if (drTmp != null)
{
isJCorHy = 1;
}
sql = "select * from jc_assay where yzid=" + OrderID;
drTmp = InstanceForm.BDatabase.GetDataRow(sql);
if (drTmp != null)
{
isJCorHy = 2;
}
this.jclx = Convert.IsDBNull(dr["jclxid"]) ? 0 : Convert.ToInt32(dr["jclxid"]);
// this.sample = Convert.IsDBNull(dr["bbid"]) ? "" : dr["bbid"].ToString().Trim();
this.sample = Convert.IsDBNull(dr["bbid"]) ? 0 : Convert.ToInt32(dr["bbid"]);
this.hylx = Convert.IsDBNull(dr["hylxid"]) ? 0 : Convert.ToInt32(dr["hylxid"]);
}
else
{
throw new Exception("没有对应的医嘱项目");
}
}
catch (Exception err)
{
throw new Exception("OrderItem()/r/n" + err.Message);
}
}
