/// <summary>
/// 插入
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Insert(Neusoft.FrameWork.Models.NeuObject obj)
{
string sql = "";
if (this.Sql.GetSql("Manager.DataFileParam.Insert", ref sql) == -1)
{
return(-1);
}
Neusoft.HISFC.Models.File.DataFileParam o = obj as Neusoft.HISFC.Models.File.DataFileParam;
if (o == null)
{
return(-1);
}
try
{
sql = string.Format(sql, o.ID, o.Name, o.IsInDB.GetHashCode().ToString(),
o.Type, o.IP, o.Folders, o.ModualFolders, o.Http, this.Operator.ID);
}
catch (Exception ex) { this.Err = ex.Message; return(-1); }
if (this.ExecNoQuery(sql) <= 0)
{
return(-1);
}
return(0);
}
/// <summary>
/// 显示类型文件 0 数据文件 ,1 模板文件
/// </summary>
/// <param name="param"></param>
/// <param name="iType"></param>
/// <param name="isAll">是否全院 只对模板文件有效</param>
/// <returns></returns>
public System.Collections.ArrayList GetList(Neusoft.HISFC.Models.File.DataFileParam param, int iType, bool isAll)
{
string strSql = "";
if (iType == 0)//数据文件
{
if (this.Sql.GetSql("Manager.DataFileInfo.Select.Data.1", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, param.ID, param.Type);
}
catch
{
this.Err = "参数传入错误!";
return(null);
}
}
else//模板文件
{
if (isAll)//全院模板，都是有效的
{
if (this.Sql.GetSql("Manager.DataFileInfo.Select.Modual.1", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, param.ID, param.Type);
}
catch
{
this.Err = "参数传入错误!";
return(null);
}
}
else
{
if (this.Sql.GetSql("Manager.DataFileInfo.Select.Modual.2", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, param.ID, param.Type, ((Neusoft.HISFC.Models.Base.Employee) this.Operator).Dept.ID);
}
catch
{
this.Err = "参数传入错误!";
return(null);
}
}
}
return(this.myGetFiles(param, strSql));
}
public int Add()
{
// TODO: 添加 ucMoudulTypeList.Add 实现
try
{
ucModTypeSetting u = new ucModTypeSetting();
Neusoft.HISFC.Models.File.DataFileParam o = new Neusoft.HISFC.Models.File.DataFileParam();
u.DataFileParam = o;
Neusoft.FrameWork.WinForms.Classes.Function.PopShowControl(u);
this.Retrieve();
}
catch {}
return(0);
}
/// <summary>
/// 先设置显示类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int SetType(string type)
{
try
{
dtParam = this.ParamManager.Get(type) as Neusoft.HISFC.Models.File.DataFileParam;
if (dtParam == null)
{
return(-1);
}
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
return(0);
}
private void frmQuery_Load(object sender, System.EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
Neusoft.HISFC.Models.File.DataFileParam param = Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.GetDataFileParam("0");
ArrayList al = Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.GetNodePathList(param.Name);
this.panel1.Height = this.ucConditions1.ControlHeight;
this.fpSpread1_Sheet1.DataAutoSizeColumns = false;
this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect;
this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(fpSpread1_CellDoubleClick);
//添加EMRControl
loader.Dock = DockStyle.Fill;
this.tabPage2.Controls.Add(loader);
this.fpSpread1_Sheet1.SetColumnMerge(1, FarPoint.Win.Spread.Model.MergePolicy.Always);
this.fpSpread1_Sheet1.SetColumnMerge(2, FarPoint.Win.Spread.Model.MergePolicy.Always);
}
/// <summary>
/// 获得列表
/// </summary>
/// <returns></returns>
public System.Collections.ArrayList GetList()
{
// TODO: 添加 DataFileParam.GetList 实现
string sql = "";
if (this.Sql.GetSql("Manager.DataFileParam.GetList", ref sql) == -1)
{
return(null);
}
if (this.ExecQuery(sql) == -1)
{
return(null);
}
ArrayList al = new ArrayList();
//if(this.Reader.HasRows)
try
{
while (this.Reader.Read())
{
Neusoft.HISFC.Models.File.DataFileParam datafileparam = new Neusoft.HISFC.Models.File.DataFileParam();
datafileparam.ID = this.Reader[0].ToString();
datafileparam.Name = this.Reader[1].ToString();
datafileparam.IsInDB = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[2].ToString());
datafileparam.Type = this.Reader[3].ToString();
datafileparam.IP = this.Reader[4].ToString();
datafileparam.Folders = this.Reader[5].ToString();
datafileparam.ModualFolders = this.Reader[6].ToString();
datafileparam.Http = this.Reader[7].ToString();
datafileparam.User01 = this.Reader[8].ToString();
datafileparam.User02 = this.Reader[9].ToString();
al.Add(datafileparam);
}
}
catch
{
return(null);
}
this.Reader.Close();
return(al);
}
/// <summary>
/// 默认显示数据文件
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public System.Collections.ArrayList GetList(Neusoft.HISFC.Models.File.DataFileParam param)
{
return(this.GetList(param, 0, true));
}
private ArrayList myGetFiles(Neusoft.HISFC.Models.File.DataFileParam param, string strSql)
{
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.File.DataFileInfo DataFileInfo = null;
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
DataFileInfo = new Neusoft.HISFC.Models.File.DataFileInfo();
DataFileInfo.Param = (Neusoft.HISFC.Models.File.DataFileParam)param.Clone();
// TODO: 添加 DataFileInfo.GetList 实现
try
{
DataFileInfo.ID = this.Reader[0].ToString();//文件编号
}
catch
{ }
try
{
DataFileInfo.Param.ID = this.Reader[1].ToString();//参数名
}
catch
{ }
try
{
DataFileInfo.Param.Type = this.Reader[2].ToString();//系统类型 0 电子病历 1 手术申请单
}
catch
{ }
try
{
DataFileInfo.Type = this.Reader[3].ToString();//文件类型 数据文件 模板文件
}
catch
{ }
try
{
DataFileInfo.Name = this.Reader[4].ToString();//文件名 说明名称
}
catch
{ }
try
{
DataFileInfo.Param.Http = this.Reader[5].ToString();//http
}
catch
{ }
try
{
DataFileInfo.Param.IP = this.Reader[6].ToString();//主机名
}
catch
{ }
try
{
DataFileInfo.Param.Folders = this.Reader[7].ToString();//路径名
}
catch
{ }
try
{
DataFileInfo.Param.FileName = this.Reader[8].ToString();//文件名
}
catch
{ }
try
{
DataFileInfo.Index1 = this.Reader[9].ToString();//索引1
}
catch
{ }
try
{
DataFileInfo.Index2 = this.Reader[10].ToString();//索引2
}
catch
{ }
try
{
DataFileInfo.Memo = this.Reader[11].ToString();//备注
}
catch
{ }
try
{
DataFileInfo.DataType = this.Reader[12].ToString();//特定类型
}
catch
{ }
try
{
DataFileInfo.valid = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[13].ToString());//有效标志
}
catch
{ }
try
{
DataFileInfo.UseType = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[14].ToString()); //用户类型
DataFileInfo.Count = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[15].ToString()); //使用次数
}
catch
{ }
al.Add(DataFileInfo);
}
this.Reader.Close();
return(al);
}
public Neusoft.FrameWork.Models.NeuObject Get(object strType)
{
// TODO: 添加 DataFileParam.Get 实现
//接口名称 Manager.DataFileParam.Get.1
//<!--0 系统类别, 1 参数, 2 是否在数据库,3 数据表名,4 ip ,5 数据文件夹,6 摸板文件夹 ,7 http-->
string strSql = "";
if (this.Sql.GetSql("Manager.DataFileParam.Get.1", ref strSql) == -1)
{
return(null);
}
Neusoft.HISFC.Models.File.DataFileParam DataFileParam = new Neusoft.HISFC.Models.File.DataFileParam();
try
{
//DataFileParam=sender as Neusoft.HISFC.Models.Base.DataFileParam;
strSql = string.Format(strSql, strType);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
return(null);
}
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
try
{
this.Reader.Read();
}
catch { return(null); }
try
{
DataFileParam.Type = this.Reader[0].ToString(); //系统类别
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
DataFileParam.ID = this.Reader[1].ToString(); //参数
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
DataFileParam.IsInDB = System.Convert.ToBoolean(int.Parse(this.Reader[2].ToString())); //是否在数据库
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
DataFileParam.Name = this.Reader[3].ToString(); //数据表名
DataFileParam.IP = this.Reader[4].ToString(); //IP
DataFileParam.Folders = this.Reader[5].ToString(); //数据文件夹名
DataFileParam.ModualFolders = this.Reader[6].ToString(); //摸板文件夹名
DataFileParam.Http = this.Reader[7].ToString(); //摸板文件夹名
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
this.Reader.Close();
//接口名称 Manager.Ftp.Get.1
//<!--0 ip,1 username,2 pwd,3 root-->
if (this.Sql.GetSql("Manager.Ftp.Get.1", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, DataFileParam.IP);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
return(null);
}
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
try
{
if (DataFileParam.IsInDB) //数据库里面不用取ftp
{
}
else
{
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
if (this.Reader.Read())
{
DataFileParam.UserName = this.Reader[1].ToString();
DataFileParam.PassWord = this.Reader[2].ToString();
DataFileParam.Root = this.Reader[3].ToString();
}
else
{
this.Err = "没有设置ftp!";
return(null);
}
}
this.Reader.Close();
}
catch { return(null); }
return(DataFileParam);
}
public System.Collections.ArrayList GetFileList(Neusoft.HISFC.Models.File.DataFileParam param, bool isModual, bool isAll)
{
Neusoft.HISFC.BizLogic.EPR.DataFileInfo manager = new Neusoft.HISFC.BizLogic.EPR.DataFileInfo();
this.SetDB(manager);
return(manager.GetList(param, Neusoft.FrameWork.Function.NConvert.ToInt32(isModual), isAll));
}
public System.Collections.ArrayList GetModualList(Neusoft.HISFC.Models.File.DataFileParam param, bool isAll)
{
Neusoft.HISFC.BizLogic.EPR.DataFileInfo manager = new Neusoft.HISFC.BizLogic.EPR.DataFileInfo();
this.SetDB(manager);
return(manager.GetModualList(param, isAll));
}
public int UpdateParam(Neusoft.HISFC.Models.File.DataFileParam fileParam)
{
Neusoft.HISFC.BizLogic.EPR.DataFileParam manager = new Neusoft.HISFC.BizLogic.EPR.DataFileParam();
this.SetDB(manager);
return(manager.Update(fileParam));
}
