Exemplo n.º 1
0
        /// <summary>
        /// 删除.表单打印模板
        /// </summary>
        /// <param name="templateId"></param>
        /// <returns></returns>
        public int DelFormPrintTemplate(int templateId)
        {
            int       affectRows = 0;
            SqlHelper svc        = null;

            try
            {
                svc = new SqlHelper(EnumBiz.onlineDB);
                EntityEmrPrintTemplate vo = new EntityEmrPrintTemplate();
                vo.templateId = templateId;
                DataTable dt = svc.SelectPk(vo);
                if (dt != null && dt.Rows.Count > 0)
                {
                    DacParm para = svc.GetDelParmByPk(vo);
                    affectRows = svc.Commit(para);
                }
                else
                {
                    return(1);
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
                affectRows = -1;
            }
            finally
            {
                svc = null;
            }
            return(affectRows);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 删除.电子申请单
        /// </summary>
        /// <param name="formId"></param>
        /// <returns></returns>
        public int DelForm(int formId, int version)
        {
            int       affectRows = 0;
            SqlHelper svc        = null;

            try
            {
                svc = new SqlHelper(EnumBiz.onlineDB);
                EntityFormDesign po = new EntityFormDesign();
                po.Formid  = formId;
                po.Version = version;
                DataTable dt = svc.Select(po, new List <string> {
                    EntityFormDesign.Columns.Formid, EntityFormDesign.Columns.Version
                });
                if (dt != null && dt.Rows.Count > 0)
                {
                    DacParm para = svc.GetDelParm(po, new List <string>()
                    {
                        EntityFormDesign.Columns.Formid, EntityFormDesign.Columns.Version
                    });
                    affectRows = svc.Commit(para);
                }
                else
                {
                    return(1);
                }
            }
            catch (Exception ex)
            {
                ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
                affectRows = -1;
            }
            finally
            {
                svc = null;
            }
            return(affectRows);
        }
Exemplo n.º 3
0
        /// <summary>
        /// 删除.电子申请单
        /// </summary>
        /// <param name="formId"></param>
        /// <returns></returns>
        public int DelForm(int formId, int version)
        {
            int       affectRows = 0;
            SqlHelper svc        = null;

            try
            {
                svc = new SqlHelper(EnumBiz.onlineDB);
                EntityFormDesign po = new EntityFormDesign();
                po.Formid  = formId;
                po.Version = version;
                DataTable dt = svc.Select(po, new List <string> {
                    EntityFormDesign.Columns.Formid, EntityFormDesign.Columns.Version
                });
                if (dt != null && dt.Rows.Count > 0)
                {
                    DacParm para = svc.GetDelParm(po, new List <string>()
                    {
                        EntityFormDesign.Columns.Formid, EntityFormDesign.Columns.Version
                    });
                    affectRows = svc.Commit(para);
                }
                else
                {
                    return(1);
                }
            }
            catch (Exception e)
            {
                ExceptionLog.OutPutException(e);
                affectRows = -1;
            }
            finally
            {
                svc = null;
            }
            return(affectRows);
        }