private void tvItemLevel1_AfterSelect(object sender, TreeViewEventArgs e)
{
if (this.tvItemLevel1.SelectedNode.Tag == null)
{
return;
}
this.neuSpread1_Sheet1.RowCount = 0;
ArrayList alItemLevel = new ArrayList();
Neusoft.HISFC.Models.Fee.Item.ItemLevel myItemLevel = this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if ((this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel).ID == "ROOT")
{
alItemLevel = this.itemLevelManager.GetAllItemByFolderAndItemClass(myItemLevel.ID, myItemLevel.LevelClass.ID);
}
else
{
alItemLevel = this.itemLevelManager.GetAllItemByFolderID(myItemLevel.ID);
}
if (alItemLevel != null)
{
foreach (Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel in alItemLevel)
{
this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
int lastRowIndex = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColCode].Text = itemLevel.ID;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColName].Text = itemLevel.Name;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColSortID].Text = itemLevel.SortID.ToString();
}
}
}
/// <summary>
/// 插入或更新组套文件夹
/// </summary>
/// <param name="itemLevelFolder"></param>
/// <returns></returns>
public int SetNewFolder(Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevelFolder)
{
//如果为空--获得
if (itemLevelFolder.ID == "")
{
itemLevelFolder.ID = this.GetNewFolderID();
if (itemLevelFolder.ID == "")
{
return(-1);
}
}
//先更新
int iRet = this.updateFolder(itemLevelFolder);
if (iRet < 0)//出错
{
return(-1);
}
else if (iRet == 0)//没有更新到
{
//插入
int iReturn = this.insertFolder(itemLevelFolder);
if (iReturn < 0)//出错
{
return(-1);
}
return(iReturn);
}
//返回
return(iRet);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void deleteItem_Click(object sender, EventArgs e)
{
try
{
Neusoft.HISFC.Models.Fee.Item.ItemLevel info = this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if (info.UserCode == "F")//文件夹
{
if (MessageBox.Show("是否删除文件夹" + info.Name, "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (this.itemLevelManager.deleteFolder(info) < 0)
{
MessageBox.Show(this.itemLevelManager.Err);
}
this.RefreshGroupByClass();
}
}
//else
//{
// if (MessageBox.Show("是否删除组套" + info.Name, "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
// {
// if (this.itemLevelManager.DeleteGroup(info) == -1)
// {
// MessageBox.Show(this.groupManager.Err);
// }
// this.RefreshGroupByClass();
// }
//}
}
catch { }
}
private ArrayList GetFolder(string strSql)
{
if (this.ExecQuery(strSql) < 0)
{
return(null);
}
ArrayList al = new ArrayList();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel = new Neusoft.HISFC.Models.Fee.Item.ItemLevel();
itemLevel.ID = this.Reader[0].ToString(); //编码
itemLevel.Name = this.Reader[1].ToString(); //名称
itemLevel.InOutType = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[2].ToString());
itemLevel.Dept.ID = this.Reader[3].ToString(); //科室代码
itemLevel.Owner.ID = this.Reader[4].ToString(); //所属人代码
itemLevel.SpellCode = this.Reader[5].ToString();
itemLevel.WBCode = this.Reader[6].ToString();
itemLevel.IsShared = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString());
itemLevel.Memo = this.Reader[8].ToString(); //备注
itemLevel.UserCode = "F"; //代表是文件夹
itemLevel.ParentID = this.Reader[9].ToString(); //上级文件夹编码
itemLevel.LevelClass.ID = this.Reader[10].ToString();
itemLevel.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[11]);
al.Add(itemLevel);
}
this.Reader.Close();
return(al);
}
/// <summary>
/// 删除文件夹，同时更新其所属组套为没有文件夹
/// </summary>
/// <param name="groupFolder"></param>
/// <returns></returns>
public int deleteFolder(Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevelFolder)
{
string strSql = "";
string strSql1 = "";
if (this.Sql.GetSql("Manager.ItemLevel.deleteFolder", ref strSql) == -1)
{
return(-1);
}
if (this.Sql.GetSql("Manager.ItemLevel.updateFolderIDNull", ref strSql1) == -1)
{
return(-1);
}
strSql = System.String.Format(strSql, itemLevelFolder.ID);
if (this.ExecNoQuery(strSql) < 0)
{
return(-1);
}
strSql1 = System.String.Format(strSql1, itemLevelFolder.ID);
//if (this.ExecNoQuery(strSql1) < 0)
//{
// return -1;
//}
return(1);
}
public void RefreshGroupByClass()
{
if (string.IsNullOrEmpty(levelClass.ID))
{
return;
}
this.Nodes.Clear();
TreeNode rootNode = new TreeNode(levelClass.Name);
rootNode.ImageIndex = 0;
rootNode.SelectedImageIndex = 1;
Neusoft.HISFC.Models.Fee.Item.ItemLevel rootLevel = new Neusoft.HISFC.Models.Fee.Item.ItemLevel();
rootLevel.ID = "ROOT";
rootLevel.LevelClass = this.levelClass;
rootLevel.UserCode = "F";
rootNode.Tag = rootLevel;
this.Nodes.Add(rootNode);
#region "获得组套 获取当前科室的科室组套 当前操作员的个人组套 全院组套"
ArrayList alFolder = this.itemLevelManager.GetAllFirstLVFolder(this.inOutType, levelClass.ID);
if (alFolder == null)
{
return;
}
#endregion
try
{
TreeNode node;
Neusoft.HISFC.Models.Fee.Item.ItemLevel info;
for (int i = 0; i < alFolder.Count; i++)
{
info = alFolder[i] as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if (info == null)
{
continue;
}
node = new TreeNode(info.Name);
node.ImageIndex = 2;
node.SelectedImageIndex = 3;
node.Tag = info;
this.Nodes[0].Nodes.Add(node);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
this.Nodes[0].ExpandAll();
this.Nodes[0].Expand();
}
protected override void OnAfterLabelEdit(NodeLabelEditEventArgs e)
{
if (!isEdit)
{
return;
}
if (e.Label == null)
{
this.LabelEdit = false;
return;
}
#region 更改组套名称权限控制 --2007-11-21 zhangqi
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel = this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
DialogResult r = MessageBox.Show("节点名称已经修改，是否保存？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (r == DialogResult.Cancel)
{
this.LabelEdit = false;
//{3E29ADED-FB2D-4243-B525-BBDD79D85C2B}
this.SelectedNode.Text = this.labelName;
this.RefreshGroupByClass();
return;
}
if ((this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel).UserCode == "F")
{
Neusoft.HISFC.Models.Fee.Item.ItemLevel tem = this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
tem.Name = e.Label;
tem.LevelClass = this.levelClass;
if (this.itemLevelManager.updateFolder(tem) <= 0)
{
MessageBox.Show("文件夹名称更新失败·", "提示");
}
else
{
MessageBox.Show("文件夹名称更新成功！", "提示");
}
}
//else
//{
// string GroupId = (this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel).ID;
// if (groupManager.UpdateGroupName(GroupId, e.Label) > 0)
// MessageBox.Show("组套名称更新成功", "提示");
// else
// {
// MessageBox.Show("更新失败", "提示");
// }
//}
#endregion
this.LabelEdit = false;
}
private void neuSpread1_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
if (e.Column == (int)Col.ColUpdate)
{
int sort = Neusoft.FrameWork.Function.NConvert.ToInt32(this.neuSpread1_Sheet1.Cells[e.Row, (int)Col.ColSortID].Text);
if (sort >= 0)
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
if (this.itemLevelManager.UpdateItemSortID(sort.ToString(), this.neuSpread1_Sheet1.Cells[e.Row, (int)Col.ColCode].Text, (this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel).ID) < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("更新排序号失败!" + this.itemLevelManager.Err);
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show("更新排序号成功");
}
}
if (e.Column == (int)Col.ColDel)
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
if (this.itemLevelManager.deleteItem(this.neuSpread1_Sheet1.Cells[e.Row, (int)Col.ColCode].Text, (this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel).ID) < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("删除失败!" + this.itemLevelManager.Err);
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show("删除成功！");
this.neuSpread1_Sheet1.RowCount = 0;
ArrayList alItemLevel = new ArrayList();
Neusoft.HISFC.Models.Fee.Item.ItemLevel myItemLevel = this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if (myItemLevel.ID == "ROOT")
{
alItemLevel = this.itemLevelManager.GetAllItemByFolderAndItemClass(myItemLevel.ID, myItemLevel.LevelClass.ID);
}
else
{
alItemLevel = this.itemLevelManager.GetAllItemByFolderID(myItemLevel.ID);
}
if (alItemLevel != null)
{
foreach (Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel in alItemLevel)
{
this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
int lastRowIndex = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColCode].Text = itemLevel.ID;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColName].Text = itemLevel.Name;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColSortID].Text = itemLevel.SortID.ToString();
}
}
}
}
public void Init(ArrayList list)
{
this.neuSpread1_Sheet1.Columns[0].Visible = false;
this.drugName.Text = DrugItem;
for (int i = 0; i < list.Count; i++)
{
this.neuSpread1_Sheet1.RowCount++;
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemObj = list[i] as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
this.neuSpread1_Sheet1.Cells[i, 0].Text = itemObj.ID;
this.neuSpread1_Sheet1.Cells[i, 1].Text = itemObj.Name;
}
}
/// <summary>
/// 插入一个项目
/// </summary>
/// <param name="itemLevel"></param>
/// <returns></returns>
public int insertItem(Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel)
{
string strSql = "";
if (this.Sql.GetSql("Manager.ItemLevel.InsertItem", ref strSql) == -1)
{
return(-1);
}
strSql = System.String.Format(strSql, itemLevel.ID, itemLevel.Name, itemLevel.SpellCode, itemLevel.WBCode,
itemLevel.InOutType,
itemLevel.Dept.ID, itemLevel.Owner.ID, Neusoft.FrameWork.Function.NConvert.ToInt32(itemLevel.IsShared),
itemLevel.Memo, this.Operator.ID,
itemLevel.ParentID, //上级目录ID {C2922531-DEE7-43a0-AB7A-CDD7C58691BD}
itemLevel.LevelClass.ID,
itemLevel.SortID
);
return(this.ExecNoQuery(strSql));
}
void AddItem_Click(object sender, EventArgs e)
{
TreeNode node = new TreeNode();
node.ImageIndex = 2;
node.SelectedImageIndex = 3;
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel = new Neusoft.HISFC.Models.Fee.Item.ItemLevel();
itemLevel.ID = this.itemLevelManager.GetNewFolderID();
itemLevel.Name = "新建文件夹";
itemLevel.InOutType = this.inOutType;
if (this.SelectedNode == this.Nodes[0])
{
itemLevel.Dept.ID = (this.itemLevelManager.Operator as Neusoft.HISFC.Models.Base.Employee).Dept.ID;
itemLevel.Owner = this.itemLevelManager.Operator;
itemLevel.ParentID = "ROOT"; //{C2922531-DEE7-43a0-AB7A-CDD7C58691BD} 多级组套 yangw 20100916
itemLevel.LevelClass = this.levelClass;
}
else
{//{C2922531-DEE7-43a0-AB7A-CDD7C58691BD} 多级组套 yangw 20100916
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevelSelected = this.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
itemLevel.Dept = itemLevelSelected.Dept;
itemLevel.Owner = this.itemLevelManager.Operator;
itemLevel.ParentID = itemLevelSelected.ID;
itemLevel.LevelClass = this.levelClass;
}
itemLevel.UserCode = "F";
if (this.itemLevelManager.SetNewFolder(itemLevel) < 0)
{
MessageBox.Show("增加文件夹失败！");
return;
}
node.Text = itemLevel.Name;
node.Tag = itemLevel;
this.SelectedNode.Nodes.Add(node);
}
private void ucInputItem1_SelectedItem(Neusoft.FrameWork.Models.NeuObject sender)
{
if (this.tvItemLevel1.SelectedNode == null)
{
return;
}
if (sender is Neusoft.HISFC.Models.Pharmacy.Item)
{
//Neusoft.HISFC.Models.Fee.Item.Undrug undrugTmp = sender as Neusoft.HISFC.Models.Fee.Item.Undrug;
Neusoft.HISFC.Models.Pharmacy.Item durgTmp = sender as Neusoft.HISFC.Models.Pharmacy.Item;
if (durgTmp.Type.ID.ToString() == "C")
{
MessageBox.Show("不能添加草药");
return;
}
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevel = new Neusoft.HISFC.Models.Fee.Item.ItemLevel();
itemLevel.ID = durgTmp.ID;
itemLevel.Name = durgTmp.Name;
itemLevel.InOutType = this.tvItemLevel1.InOutType;
if (this.tvItemLevel1.SelectedNode == this.tvItemLevel1.Nodes[0])
{
itemLevel.Dept.ID = (this.itemLevelManager.Operator as Neusoft.HISFC.Models.Base.Employee).Dept.ID;
itemLevel.Owner = this.itemLevelManager.Operator;
itemLevel.ParentID = "ROOT";
itemLevel.LevelClass = this.tvItemLevel1.LevelClass;
itemLevel.SpellCode = durgTmp.SpellCode;
itemLevel.WBCode = durgTmp.WBCode;
}
else
{
Neusoft.HISFC.Models.Fee.Item.ItemLevel itemLevelSelected = this.tvItemLevel1.SelectedNode.Tag as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
itemLevel.Dept = itemLevelSelected.Dept;
itemLevel.Owner = this.itemLevelManager.Operator;
itemLevel.ParentID = itemLevelSelected.ID;
itemLevel.LevelClass = this.tvItemLevel1.LevelClass;
itemLevel.SpellCode = durgTmp.SpellCode;
itemLevel.WBCode = durgTmp.WBCode;
}
itemLevel.UserCode = "Y";
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
if (this.itemLevelManager.insertItem(itemLevel) < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
if (this.itemLevelManager.DBErrCode == 1)
{
MessageBox.Show(itemLevel.Name + " 已存在，不能重复维护");
}
else
{
MessageBox.Show("增加项目失败！" + this.itemLevelManager.Err);
}
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
int lastRowIndex = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColCode].Text = durgTmp.ID;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColName].Text = durgTmp.Name;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColSpec].Text = durgTmp.Specs;
this.neuSpread1_Sheet1.Cells[lastRowIndex, (int)Col.ColPrice].Text = durgTmp.Price.ToString();
MessageBox.Show("增加项目成功！");
}
}
//{C2922531-DEE7-43a0-AB7A-CDD7C58691BD} 多级组套 yangw 20100916
protected override void OnAfterSelect(TreeViewEventArgs e)
{
object o = this.SelectedNode.Tag;
if (o != null)
{
if (o.GetType() == typeof(Neusoft.HISFC.Models.Fee.Item.ItemLevel))
{
this.SelectedNode.Nodes.Clear();
Neusoft.HISFC.Models.Fee.Item.ItemLevel info = o as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if (info.UserCode == "F")
{
#region 加载此文件夹下面的咚咚
ArrayList alFolder = new ArrayList();
if (info.ID == "ROOT")
{
alFolder = this.itemLevelManager.GetAllFolderByFolderAndLevelClass(info.ID, info.LevelClass.ID);
}
else
{
alFolder = this.itemLevelManager.GetAllFolderByFolderID(info.ID);
}
if (alFolder == null)
{
return;
}
try
{
TreeNode node;
Neusoft.HISFC.Models.Fee.Item.ItemLevel myGroup;
for (int i = 0; i < alFolder.Count; i++)
{
myGroup = alFolder[i] as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
if (info == null)
{
continue;
}
node = new TreeNode(myGroup.Name);
node.ImageIndex = 2;
node.SelectedImageIndex = 3;
node.Tag = myGroup;
this.SelectedNode.Nodes.Add(node);
}
//ArrayList alGroup = this.groupManager.GetGroupByFolderID(info.ID);
//if (alGroup != null && alGroup.Count > 0)
//{
// for (int j = 0; j < alGroup.Count; j++)
// {
// Neusoft.HISFC.Models.Fee.Item.ItemLevel group = alGroup[j] as Neusoft.HISFC.Models.Fee.Item.ItemLevel;
// if (group == null)
// {
// continue;
// }
// TreeNode temNode = new TreeNode(group.Name);
// temNode.ImageIndex = 10;
// temNode.SelectedImageIndex = 11;
// temNode.Tag = group;
// this.SelectedNode.Nodes.Add(temNode);
// }
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
this.SelectedNode.Expand();
#endregion
}
}
}
base.OnAfterSelect(e);
}