/// <summary>
/// 添加实体给数据表
/// </summary>
/// <param name="changes"></param>
/// <returns></returns>
private ArrayList GetEntityFromTable(DataTable changes)
{
if (changes == null || changes.Rows.Count <= 0)
{
return(null);
}
ArrayList entities = new ArrayList();
foreach (DataRow row in changes.Rows)
{
Neusoft.HISFC.Models.Admin.SysModelFunction fun = new Neusoft.HISFC.Models.Admin.SysModelFunction();
fun.SysCode = row[0].ToString();
fun.FunName = row[1].ToString();
fun.WinName = row[2].ToString();
fun.DllName = row[3].ToString();
fun.FormShowType = row[4].ToString();
fun.FormType = row[5].ToString();
fun.Memo = row[6].ToString();
fun.Param = row[7].ToString();
fun.TreeControl.DllName = row[8].ToString();
fun.TreeControl.WinName = row[9].ToString();
fun.TreeControl.Param = row[10].ToString();
fun.ID = row[11].ToString();
fun.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(row[12].ToString());
entities.Add(fun);
}
return(entities);
}
public int UpdateConst(string GroupID, Neusoft.HISFC.Models.Admin.SysModelFunction obj)
{
string strSql = "";
if (this.Sql.GetSql("Manager.Group.Const.Update", ref strSql) == -1)
{
return(-1);
}
try
{
string[] s = this.mySetConstInfo(GroupID, obj);
strSql = string.Format(strSql, s);
}
catch (Exception ex)
{
this.Err = "赋值时候出错！" + ex.Message;
this.WriteErr();
return(-1);
}
if (this.ExecNoQuery(strSql) <= 0)
{
return(-1);
}
return(0);
}
private string[] mySetConstInfo(string GroupID, object obj)
{
string[] s = new string[9];
Neusoft.HISFC.Models.Admin.SysModelFunction o = obj as Neusoft.HISFC.Models.Admin.SysModelFunction;
try
{
s[0] = GroupID; //id
}
catch {}
try
{
s[1] = o.ID; //id
}
catch {}
try
{
s[2] = o.Name; //name
}
catch {}
try
{
s[3] = o.WinName; //
}
catch {}
try
{
s[4] = o.Memo;
}
catch {}
try
{
s[5] = this.Operator.ID; //
}
catch {}
try
{
s[6] = this.Operator.Name; //operator naem
}
catch {}
try
{
s[7] = o.Param; //operator naem
}
catch {}
try{
s[8] = o.SortID.ToString(); //顺序号
}
catch {}
return(s);
}
/// <summary>
/// 显示列表
/// </summary>
public void ShowList()
{
//清空列表
this.tvList.Nodes.Clear();
this.tvList.ImageList = this.tvList.groupImageList;
//显示根节点
Neusoft.HISFC.Models.Admin.SysModelFunction obj = new Neusoft.HISFC.Models.Admin.SysModelFunction();
obj.ID = ""; //显示所有数据
TreeNode node = new TreeNode();
node.Text = "常数维护";
node.ImageIndex = 0;
node.SelectedImageIndex = node.ImageIndex;
//node.Tag = obj;
this.tvList.Nodes.Add(node);
//取当前用户组中可以维护的常数
Neusoft.HISFC.BizLogic.Manager.SysGroup group = new Neusoft.HISFC.BizLogic.Manager.SysGroup();
//
// I don't think this is a good idea to save the info in this class
// Robin 2006-11-14
Neusoft.HISFC.Models.Base.Employee user = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
ArrayList al = group.GetConstByGroup(user.CurrentGroup.ID);
if (al == null)
{
MessageBox.Show("没有可以维护的常数，请在系统管理中设置常数维护项");
return;
}
//显示常数维护数据
foreach (Neusoft.HISFC.Models.Admin.SysModelFunction info in al)
{
node = new TreeNode();
node.Text = info.Name;
node.ImageIndex = 3;
node.SelectedImageIndex = 4;
node.Tag = info;
this.tvList.Nodes[0].Nodes.Add(node);
}
this.tvList.Nodes[0].ExpandAll();
}
public int SetConst(string GroupID, Neusoft.HISFC.Models.Admin.SysModelFunction obj)
{
#region "接口"
//接口名称 Manager.SysGroup.Update.1
#endregion
string strSql = "", strSql1 = "";
if (this.Sql.GetSql("Manager.Group.Const.Insert", ref strSql) == -1)
{
return(-1);
}
if (this.Sql.GetSql("Manager.Group.Const.Update", ref strSql1) == -1)
{
return(-1);
}
try
{
string[] s = this.mySetConstInfo(GroupID, obj);
strSql = string.Format(strSql, s);
strSql1 = string.Format(strSql1, s);
}
catch (Exception ex)
{
this.Err = "赋值时候出错！" + ex.Message;
this.WriteErr();
return(-1);
}
if (this.ExecNoQuery(strSql) <= 0) //insert
{
if (this.ExecNoQuery(strSql1) <= 0) //update
{
return(-1);
}
else
{
return(0);
}
}
return(0);
}
/// <summary>
/// 根据组获得常数-Neusoft.HISFC.Models.Power.SysModelFunction
/// </summary>
/// <param name="GroupID">组ID</param>
/// <returns>模块列表Neusoft.HISFC.Models.Power.SysModelFunction </returns>
public ArrayList GetConstByGroup(string GroupID)
{
ArrayList al = new ArrayList();
string sql = "";
if (this.Sql.GetSql("Manager.Group.Const.Select", ref sql) == -1)
{
return(null);
}
try
{
sql = string.Format(sql, GroupID);
}
catch { this.Err = "传参Manager.Group.Const.Select出错！"; this.WriteErr(); }
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Admin.SysModelFunction obj = new Neusoft.HISFC.Models.Admin.SysModelFunction();
obj.ID = this.Reader[0].ToString();
obj.Name = this.Reader[1].ToString();
obj.FunName = this.Reader[1].ToString();
obj.WinName = this.Reader[2].ToString();
obj.DllName = this.Reader[3].ToString();
obj.FormType = this.Reader[4].ToString();
obj.FormShowType = this.Reader[5].ToString();
obj.Memo = this.Reader[6].ToString();
obj.User01 = this.Reader[7].ToString();
obj.User02 = this.Reader[8].ToString();
obj.Param = this.Reader[9].ToString();
al.Add(obj);
}
this.Reader.Close();
return(al);
}
private bool SaveData()
{
if (IsDirty == false || ValidateValue() == false)
{
return(false);
}
this.fpSpread1.StopCellEditing();
for (int i = 0; i < this.view.Count; i++)
{
this.view[i].EndEdit();
}
DataTable added = table.GetChanges(DataRowState.Added);
DataTable modified = table.GetChanges(DataRowState.Modified);
DataTable deleted = table.GetChanges(DataRowState.Deleted);
if (added == null && deleted == null && modified == null)
{
IsDirty = false;
MessageBox.Show("无变化！");
return(true);
}
Neusoft.HISFC.BizLogic.Manager.SysModelFunctionManager funMgr = new Neusoft.HISFC.BizLogic.Manager.SysModelFunctionManager();
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction trans = new Neusoft.FrameWork.Management.Transaction(funMgr.Connection);
bool saved = true;
Neusoft.HISFC.Models.Admin.SysModelFunction errorFun = null;
try
{
//trans.BeginTransaction();
funMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (deleted != null)
{
deleted.RejectChanges();
ArrayList entities = GetEntityFromTable(deleted);
if (entities != null)
{
foreach (Neusoft.HISFC.Models.Admin.SysModelFunction fun in entities)
{
if (funMgr.DeleteSysModelFunction(fun) < 0)
{
saved = false;
break;
}
}
}
}
if (added != null && saved)
{
//added.AcceptChanges();
ArrayList entities = GetEntityFromTable(added);
if (entities != null)
{
foreach (Neusoft.HISFC.Models.Admin.SysModelFunction fun in entities)
{
if (funMgr.InsertSysModelFunction(fun) < 0)
{
errorFun = fun;
saved = false;
break;
}
}
}
}
if (modified != null && saved)
{
ArrayList entities = GetEntityFromTable(modified);
if (entities != null)
{
foreach (Neusoft.HISFC.Models.Admin.SysModelFunction fun in entities)
{
if (funMgr.UpdateSysModelFunction(fun) < 0)
{
errorFun = fun;
saved = false;
break;
}
}
}
}
if (saved)
{
Neusoft.FrameWork.Management.PublicTrans.Commit();
}
}
catch
{
saved = false;
}
finally
{
if (!saved)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
string error = string.Empty;
if (funMgr.DBErrCode == 1 && errorFun != null)
{
error = "系统模块\"" + modelCache[errorFun.SysCode].ToString() + "\"中窗口名称 \"" + errorFun.WinName + "\" 有重复！";
}
else
{
error = funMgr.Err;
}
SetCellType();
MessageBox.Show("数据保存失败!" + error, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
table.AcceptChanges(); //因为用的是DataView ,所以先得置标志位，去除掉已经删除的行
foreach (DataRow row in table.Rows)
{
row["状态"] = "old";
}
table.AcceptChanges();
IsDirty = false;
SetCellType();
}
}
if (saved)
{
MessageBox.Show("数据保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
IsDirty = false;
return(true);
}
else
{
IsDirty = true;
return(false);
}
}
