/// <summary>
/// 查询
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
protected int Query()
{
if (!this.IsValid())
{
return(-1);
}
string strSqlIndex = this.GetSqlIndex();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DataSet ds = new DataSet();
if (dataManager.ExecQuery(strSqlIndex, ref ds, this.cmbDrug.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("执行查询发生错误") + dataManager.Err);
return(-1);
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.neuSpread1_Sheet1.DataSource = ds;
}
else
{
this.neuSpread1_Sheet1.DataSource = null;
this.neuSpread1_Sheet1.Rows.Count = 0;
}
return(1);
}
public ActionResult GetAllPeople()
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
var people = db.GetAllPeople();
return(Json(people));
}
public ActionResult Index()
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
IEnumerable <person> people = db.GetAllPeople();
return(View(people));
}
public ActionResult GetPerson(int id)
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
person person = db.GetPerson(id);
return(Json(person));
}
/// <summary>
/// 数据初始化
/// </summary>
/// <returns></returns>
protected virtual int Init()
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在加载基础数据.请稍候..."));
Application.DoEvents();
if (this.tv != null)
{
this.tvCompound = this.tv as Neusoft.HISFC.Components.DrugStore.Compound.tvCompoundList;
this.tvCompound.Init();
this.tvCompound.State = "2";
}
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
this.approveDept = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept;
this.InitOrderGroup();
this.tvCompound.SelectDataEvent += new tvCompoundList.SelectDataHandler(tvCompound_SelectDataEvent);
//this.ShowList();
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(1);
}
/// <summary>
/// 退费保存
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
protected int SaveBack()
{
ArrayList alCheckData = this.GetCheckData();
if (alCheckData.Count == 0)
{
return(0);
}
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
Neusoft.FrameWork.Models.NeuObject approveDept = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept;
Neusoft.HISFC.BizProcess.Integrate.Pharmacy pharmacyIntegrate = new Neusoft.HISFC.BizProcess.Integrate.Pharmacy();
if (pharmacyIntegrate.CompoundBackFee(alCheckData, approveDept) != 1)
{
MessageBox.Show(Language.Msg(pharmacyIntegrate.Err) + " 该标签可能已完成退费！");
return(-1);
}
MessageBox.Show(Language.Msg("保存成功"));
this.Clear();
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药房"));
return(-1);
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.DayStore.DayReport", ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("查询发生错误") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpHead.DataSource = ds;
return(1);
}
/// <summary>
/// 读取Sql配置信息
/// </summary>
/// <returns></returns>
private int GetSetting()
{
#region 获取配置文件路径
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.Load(Application.StartupPath + "\\url.xml");
System.Xml.XmlNode node = doc.SelectSingleNode("//dir");
if (node == null)
{
MessageBox.Show("url中找dir结点出错！");
return(-1);
}
this.serverPath = node.InnerText;
this.configPath = "//Report_Setting.xml"; //远程配置文件名
#endregion
try
{
//doc.Load(serverPath + configPath);
doc.Load(Application.StartupPath + "\\server" + configPath);
}
catch (Exception ex)
{
MessageBox.Show("装载HisProfile.xml失败！\n" + ex.Message);
return(-1);
}
System.Xml.XmlNode nodeCollection = doc.SelectSingleNode("/Setting/Fun[@ID='Mat']");
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
foreach (System.Xml.XmlNode reportConfigNode in nodeCollection.ChildNodes)
{
System.Xml.XmlNode sqlNode = reportConfigNode.ChildNodes[0];
if (reportConfigNode.Attributes["sqlLocation"].Value == "1") //Sql位于Xml内
{
this.hsSqlConfig.Add(reportConfigNode.Attributes["ID"].Value, sqlNode.InnerText);
}
else
{
string sql = "";
if (dataManager.Sql.GetSql(sqlNode.Attributes["index"].Value, ref sql) == -1)
{
MessageBox.Show("根据索引未获取Sql语句!" + sqlNode.Attributes["index"].Value);
}
this.hsSqlConfig.Add(reportConfigNode.Attributes["ID"].Value, sql);
}
System.Xml.XmlNode fpPathNode = reportConfigNode.ChildNodes[1];
if (fpPathNode.Attributes["fileName"].Value.ToString() != "")
{
this.hsSqlFpPath.Add(reportConfigNode.Attributes["ID"].Value, fpPathNode.Attributes["fileName"].Value);
}
}
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
protected int Query()
{
if (!this.IsValid())
{
return(-1);
}
this.neuSpread1_Sheet1.Reset();
string strSqlIndex = this.GetSqlIndex();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DataSet ds = new DataSet();
if (dataManager.ExecQuery(strSqlIndex, ref ds, this.cmbDrug.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("执行查询发生错误") + dataManager.Err);
return(-1);
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.neuSpread1_Sheet1.DataSource = ds;
//{F371AF75-B75B-43a1-82BD-849A1FECB300}取消第一行的空行
//this.neuSpread1_Sheet1.Rows.Add(0, 1);
//this.neuSpread1_Sheet1.Cells[0, 0].ColumnSpan = this.neuSpread1_Sheet1.Columns.Count;
}
else
{
this.neuSpread1_Sheet1.DataSource = null;
this.neuSpread1_Sheet1.Rows.Count = 0;
}
return(1);
}
/// <summary>
/// 汇总页数据赋值
/// </summary>
/// <param name="applyOut">发药申请数组</param>
public void SetPatiTotData()
{
//this.Clear();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
this.lblDrugDate.Text = this.patientInfo.User01;
}
/// <summary>
/// 有效性判断
/// </summary>
/// <returns>填写有效 返回True 否则返回 False</returns>
public virtual bool Valid()
{
if (this.phaInManager.TargetDept.ID == "")
{
MessageBox.Show(Language.Msg("请选择供货公司"));
return(false);
}
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DateTime sysTime = dataManager.GetDateTimeFromSysDateTime();
foreach (DataRow dr in this.dt.Rows)
{
if (NConvert.ToDecimal(dr["入库数量"]) <= 0)
{
MessageBox.Show(Language.Msg(dr["商品名称"].ToString() + " 请输入入库数量 入库数量不能小于等于0"));
return(false);
}
if (dr["批号"].ToString() == "")
{
MessageBox.Show(Language.Msg("请输入批号"));
return(false);
}
if (NConvert.ToDateTime(dr["有效期"]) < sysTime)
{
MessageBox.Show(Language.Msg(dr["商品名称"].ToString() + " 有效期应大于当前日期"));
return(false);
}
}
return(true);
}
/// <summary>
/// 初始化
/// </summary>
public void Init()
{
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
Neusoft.FrameWork.Models.NeuObject class2Priv = new Neusoft.FrameWork.Models.NeuObject();
class2Priv.ID = "0510";
class2Priv.Name = "入库";
this.Class2Priv = class2Priv; //入库
//由权限科室获取
//this.DeptInfo = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept;
this.OperInfo = dataManager.Operator;
this.OperInfo.Memo = "in";
Neusoft.HISFC.BizLogic.Manager.Department managerIntegrate = new Neusoft.HISFC.BizLogic.Manager.Department();
Neusoft.HISFC.Models.Base.Department dept = managerIntegrate.GetDeptmentById(this.DeptInfo.ID);
if (dept != null)
{
this.DeptInfo.Memo = dept.DeptType.ID.ToString();
}
if (this.FilePath == "")
{
this.FilePath = @"\Setting\PhaInSetting.xml";
}
if (this.SetPrivType(true) == -1)
{
return;
}
this.SetCancelVisible(false);
this.GetInterface();
}
/// <summary>
/// 数据初始化
/// </summary>
/// <returns></returns>
protected virtual int Init()
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在加载基础数据.请稍候..."));
Application.DoEvents();
this.tvCompound = this.tv as Neusoft.HISFC.Components.DrugStore.Compound.tvCompoundList;
this.tvCompound.Init();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
this.approveOper = dataManager.Operator;
this.approveDept = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept;
this.InitOrderGroup();
this.dtMaxDate.Value = dataManager.GetDateTimeFromSysDateTime().Date.AddDays(1);
this.tvCompound.SelectDataEvent += new tvCompoundList.SelectDataHandler(tvCompound_SelectDataEvent);
//取医嘱类型，用于将编码转换成名称
Neusoft.HISFC.BizLogic.Manager.OrderType orderManager = new Neusoft.HISFC.BizLogic.Manager.OrderType();
ArrayList alOrderType = orderManager.GetList();
foreach (Neusoft.FrameWork.Models.NeuObject infoOrderType in alOrderType)
{
this.hsOrderType.Add(infoOrderType.ID, infoOrderType.Name);
}
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(1);
}
public virtual String execute()
{
try
{
//读取配置
DataBaseConfig config = Config.getConfig.dataBaseConfig[getDataBaseName()];
Identity identity = config[getDataBaseIdentity()];
//获取数据库控制器
DataBaseClient db = DataBaseManger.getDataClient(identity);
//语句
String sql = getSql();
//数据表
DataTable table = db.QueryForTable(sql);
//装配
return(getWebServiceDataXML(table));
}
catch (Exception e)
{
return(getErrorWebServiceDataXML(e.Message));
}
}
/// <summary>
/// 清除在线状态
/// </summary>
/// <param name="info"></param>
public static void RemoveOnlineUser(ISessionKey info)
{
Database db = DataBaseManger.GetDB("");
//info.Token
var clearSql = new Sql("delete from FBOnlineUser where UserID=@0 and DeviceType='PC'", info.UserID);
db.Execute(clearSql);
}
private static void CheckPCState(ISessionKey user)
{
Database db = DataBaseManger.GetDB("");
var sql = new Sql("select count(1) from FBOnlineUser where UserToken=@0 and UserID=@1 and DeviceType='PC'", user.Token, user.UserID);
if (db.ExecuteScalar <long>(sql) <= 0)
{
throw new Exception("您的登录身份已过期，请重新登录,");
}
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药库"));
return(-1);
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.Report.InputSum", ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpSpread1_Sheet1.DataSource = ds;
int iTotIndex = this.fpSpread1_Sheet1.RowCount;
decimal sumNum4 = 0;
decimal sumNum3 = 0;
decimal sumNum2 = 0;
decimal sumNum1 = 0;
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex, 1].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
return(1);
}
public static string CreateServerStateToken(ISessionKey info)
{
Database db = DataBaseManger.GetDB("");
var token = Guid.NewGuid().ToString();
// 这里要预留出pc端登陆的接口
var clearSql = new Sql("delete from FBOnlineUser where UserID=@0 and DeviceType='PC'", info.UserID);
db.Execute(clearSql);
var sql = new Sql("insert into FBOnlineUser(ID,UserID,LoginIP,LoginMachine,UserState,CreateTime,UserToken,DeviceType) values(@0,@1,@2,@3,@4,@5,@0,@6)",
token, info.UserID, info.IPAddress, WebHelper.GetMachineName(), "1", DateTime.Now.ToString(), "PC");
db.Execute(sql);
return(token);
}
/// <summary>
/// 摆药管理
/// </summary>
private void ShowDrugManager(Neusoft.HISFC.Models.Pharmacy.DrugControl drugControl)
{
frmDrugManager = new frmInpatientDrug();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (drugControl.Dept == null || drugControl.Dept.ID == "")
{
drugControl.Dept = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept.Clone();
}
frmDrugManager.SetDrugControl(drugControl);
frmDrugManager.Show();
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
//if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
//{
// MessageBox.Show(Language.Msg("请选择查询药库"));
// return -1;
//}
ds.Clear();
this.GetQueryTime();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery("Pharmacy.Report.ExpenseQuery", ref ds, this.cmbNurseCellCode.Tag.ToString(), this.cmbDrugCode.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString(), DateNum) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
//this.filterField = new string[2] { "病区", "药品名称" };
this.dv = new DataView(this.ds.Tables[0]);
this.fpSpread1_Sheet1.DataSource = this.dv;
//int iTotIndex = this.fpSpread1_Sheet1.RowCount;
//decimal sumNum4 = 0;
//decimal sumNum3 = 0;
//decimal sumNum2 = 0;
//decimal sumNum1 = 0;
//for (int i = 0; i < iTotIndex; i++)
//{
// sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
// sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
// sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
// sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
//}
////this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
//this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
//this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
//this.fpSpread1_Sheet1.Cells[iTotIndex, 1].Text = sumNum1.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
//this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
return(1);
}
/// <summary>
/// 汇总页数据赋值
/// </summary>
/// <param name="applyOut">发药申请数组</param>
public void SetPatiTotData()
{
this.Clear();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo, 0].Text = this.patientInfo.Name;
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo, 1].Text = "性别:" + this.patientInfo.Sex.Name + " 年龄:" + dataManager.GetAge(this.patientInfo.Birthday);
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo, 2].Text = "共 " + this.patientInfo.User02 + "张";
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo + 1, 0].Text = "病历号: " + this.patientInfo.PID.CardNO;
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo + 2, 0].Text = "医生姓名: " + this.patientInfo.DoctorInfo.Templet.Doct.Name;
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo + 3, 0].ColumnSpan = 3;
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowPatiInfo + 3, 0].Text = "收费日期： " + this.patientInfo.User01;
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowDrugBegin + 3, 0].Text = "";
this.neuSpread1_Sheet1.Cells[(int)RowSet.RowDrugBegin + 4, 0].Text = "";
//设置条码
this.lbBarCode.Text = "*" + this.patientInfo.User03 + "*";
}
public string remoteCheck(CheckExits model, string frmID, string dataModelID)
{
Sql sql = new NPoco.Sql(string.Format("select count(1) from {0} where {1}='{2}'", model.TableName, model.ValidField, model.ValidValue));
if (!string.IsNullOrEmpty(model.DataID))
{
sql.Append(string.Format(" and {0}<>'{1}' ", model.KeyField, model.DataID));
}
if (model.Filter != null)
{
sql.Append(ConditionParser.Serialize(model.Filter));
}
var ds = DataModelCom.getDataSource(dataModelID, this.Db);
Database ywdb = DataBaseManger.GetDB(ds);
if (ywdb.Single <long>(sql) > 0)
{
return(string.Format("{0}的值已存在", model.Label));
}
return("");
}
/// <summary>
/// 初始化
/// </summary>
public void Init()
{
Neusoft.NFC.Management.DataBaseManger dataManager = new DataBaseManger();
Neusoft.NFC.Object.NeuObject class2Priv = new Neusoft.NFC.Object.NeuObject();
if (this.IOType == "1")
{
class2Priv.ID = "0510";
class2Priv.Name = "入库申请";
}
else
{
class2Priv.ID = "0520";
class2Priv.Name = "出库申请";
}
this.Class2Priv = class2Priv;
this.OperInfo = dataManager.Operator;
this.OperInfo.Memo = "apply";
Neusoft.HISFC.Management.Manager.Department managerIntegrate = new Neusoft.HISFC.Management.Manager.Department();
Neusoft.HISFC.Object.Base.Department dept = managerIntegrate.GetDeptmentById(this.DeptInfo.ID);
if (dept != null)
{
this.DeptInfo.Memo = dept.DeptType.ID.ToString();
}
if (this.FilePath == "")
{
this.FilePath = @"\Setting\MatApplySetting.xml";
}
if (this.SetPrivType(true) == -1)
{
return;
}
this.GetInterface();
}
public DataTable executeForDataTable()
{
try
{
//读取配置
DataBaseConfig config = Config.getConfig.dataBaseConfig[getDataBaseName()];
Identity identity = config[getDataBaseIdentity()];
//获取数据库控制器
DataBaseClient db = DataBaseManger.getDataClient(identity);
//语句
String sql = getSql();
//返回数据表
return(db.QueryForTable(sql));
}
catch (Exception)
{
//异常返回null
return(null);
}
}
/// <summary>
/// 初始化操作
/// </summary>
/// <returns></returns>
private int Init()
{
#region 帮助类信息初始化
Neusoft.HISFC.BizProcess.Integrate.Manager managerIntegrate = new Neusoft.HISFC.BizProcess.Integrate.Manager();
ArrayList alDept = managerIntegrate.GetDepartment();
if (alDept == null)
{
MessageBox.Show(Language.Msg("获取全院科室列表失败") + managerIntegrate.Err);
return(-1);
}
this.deptHelper = new Neusoft.FrameWork.Public.ObjectHelper(alDept);
ArrayList alPerson = managerIntegrate.QueryEmployeeAll();
if (alPerson == null)
{
MessageBox.Show(Language.Msg("获取全院人员列表失败") + managerIntegrate.Err);
return(-1);
}
this.personHelper = new Neusoft.FrameWork.Public.ObjectHelper(alPerson);
#endregion
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
DateTime sysTime = dataManager.GetDateTimeFromSysDateTime();
this.dtBegin.Value = sysTime.Date.AddDays(-1);
this.operDept = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept;
this.InitDataTable();
return(1);
}
private static Database getModelDataSource(string DataSource)
{
return(DataBaseManger.GetDB(DataSource));
}
public void EditPerson(person person)
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
db.EditPerson(person);
}
public void DeletePerson(int id)
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
db.DeletePerson(id);
}
public void AddPerson(person p)
{
DataBaseManger db = new DataBaseManger(Properties.Settings.Default.constr);
db.AddPerson(p);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
if (this.cmbStockDept.Tag == null || this.cmbStockDept.Tag.ToString() == "")
{
MessageBox.Show(Language.Msg("请选择查询药库"));
return(-1);
}
if (this.dtpBeginTime.Value > this.dtpEndTime.Value)
{
MessageBox.Show("开始时间不能大于结束时间！");
return(-1);
}
string sqlID = string.Empty;
if (neuCheckBox1.Checked)
{
//显示药品类别
sqlID = "WinForms.Report.Logistics.Pharmacy.InputSumBYDrugType";
}
else
{
//只按供货单位分组
sqlID = "Report.Logistics.Pharmacy.InputSum";
}
System.Data.DataSet ds = new DataSet();
Neusoft.FrameWork.Management.DataBaseManger dataManager = new DataBaseManger();
if (dataManager.ExecQuery(sqlID, ref ds, this.cmbStockDept.Tag.ToString(), this.BeginTime.ToString(), this.EndTime.ToString()) == -1)
{
MessageBox.Show(Language.Msg("没有相关信息！") + dataManager.Err);
return(-1);
}
if (ds == null || ds.Tables.Count <= 0)
{
return(0);
}
this.fpSpread1_Sheet1.DataSource = ds;
int iTotIndex = this.fpSpread1_Sheet1.RowCount;
decimal sumNum4 = 0;
decimal sumNum3 = 0;
decimal sumNum2 = 0;
decimal sumNum1 = 0;
if (neuCheckBox1.Checked)
{
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 5].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex, 5].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex, 4].Text = sumNum4.ToString();
}
else
{
for (int i = 0; i < iTotIndex; i++)
{
sumNum1 = sumNum1 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 1].Text);
sumNum2 = sumNum2 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 2].Text);
sumNum3 = sumNum3 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 3].Text);
sumNum4 = sumNum4 + NConvert.ToDecimal(this.fpSpread1_Sheet1.Cells[i, 4].Text);
}
//this.fpSpread1_Sheet1.RowCount = iTotIndex + 1;
this.fpSpread1_Sheet1.Rows.Add(iTotIndex, 1);
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 0].Text = "合计";
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 1].Text = sumNum1.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 2].Text = sumNum2.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 3].Text = sumNum3.ToString();
this.fpSpread1_Sheet1.Cells[iTotIndex + 1, 4].Text = sumNum4.ToString();
}
return(1);
}
