• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# HisClient类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中HisClient的典型用法代码示例。如果您正苦于以下问题:C# HisClient类的具体用法?C# HisClient怎么用?C# HisClient使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



HisClient类属于命名空间,在下文中一共展示了HisClient类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_pm_export model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_pm_export(");
            strSql.Append("ID,EXPORT_CODE,RECEIVE_DEPT_CODE,CREATE_BY,CREATE_DATE,SEND_DEPT_CODE,HOSPITAL_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@EXPORT_CODE,@RECEIVE_DEPT_CODE,@CREATE_BY,@CREATE_DATE,@SEND_DEPT_CODE,@HOSPITAL_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@EXPORT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@RECEIVE_DEPT_CODE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@SEND_DEPT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.EXPORT_CODE;
            parameters[2].Value = model.RECEIVE_DEPT_CODE;
            parameters[3].Value = model.CREATE_BY;
            parameters[4].Value = model.CREATE_DATE;
            parameters[5].Value = model.SEND_DEPT_CODE;
            parameters[6].Value = model.HOSPITAL_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:36,代码来源:his_pm_export.cs


示例2: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_system model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_system(");
            strSql.Append("ID,SYSTEM_CODE,SYSTEM_NAME,IS_USER,HOSPITAL_CODE,CREATE_DATE,CREATE_BY)");
            strSql.Append(" values (");
            strSql.Append("@ID,@SYSTEM_CODE,@SYSTEM_NAME,@IS_USER,@HOSPITAL_CODE,@CREATE_DATE,@CREATE_BY)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@SYSTEM_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@SYSTEM_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@IS_USER", MySqlDbType.VarChar,2),
                    new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.SYSTEM_CODE;
            parameters[2].Value = model.SYSTEM_NAME;
            parameters[3].Value = model.IS_USER;
            parameters[4].Value = model.HOSPITAL_CODE;
            parameters[5].Value = model.CREATE_DATE;
            parameters[6].Value = model.CREATE_BY;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:36,代码来源:his_comm_system.cs


示例3: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_ds_changeprice model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_ds_changeprice(");
            strSql.Append("ID,CREATE_DATE,CREATE_BY,MEMO,CHANGE_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@CREATE_DATE,@CREATE_BY,@MEMO,@CHANGE_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MEMO", MySqlDbType.VarChar,128),
                    new MySqlParameter("@CHANGE_CODE", MySqlDbType.VarChar,18)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.CREATE_DATE;
            parameters[2].Value = model.CREATE_BY;
            parameters[3].Value = model.MEMO;
            parameters[4].Value = model.CHANGE_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:32,代码来源:his_ds_changeprice.cs


示例4: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_hos_monthly_statement_item model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_hos_monthly_statement_item(");
            strSql.Append("ITEM_TYPE,ITEM_SUM_PAY,ITEM_CASH_PAY,ITEM_CARD_PAY,ITEM_INSURANCE_PAY,STATUS,ID,MONTHLY_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ITEM_TYPE,@ITEM_SUM_PAY,@ITEM_CASH_PAY,@ITEM_CARD_PAY,@ITEM_INSURANCE_PAY,@STATUS,@ID,@MONTHLY_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ITEM_TYPE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@ITEM_SUM_PAY", MySqlDbType.Int32,11),
                    new MySqlParameter("@ITEM_CASH_PAY", MySqlDbType.Int32,11),
                    new MySqlParameter("@ITEM_CARD_PAY", MySqlDbType.Int32,11),
                    new MySqlParameter("@ITEM_INSURANCE_PAY", MySqlDbType.Int32,11),
                    new MySqlParameter("@STATUS", MySqlDbType.VarChar,20),
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MONTHLY_CODE", MySqlDbType.VarChar,18)};
            parameters[0].Value = model.ITEM_TYPE;
            parameters[1].Value = model.ITEM_SUM_PAY;
            parameters[2].Value = model.ITEM_CASH_PAY;
            parameters[3].Value = model.ITEM_CARD_PAY;
            parameters[4].Value = model.ITEM_INSURANCE_PAY;
            parameters[5].Value = model.STATUS;
            parameters[6].Value = model.ID;
            parameters[7].Value = model.MONTHLY_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:38,代码来源:his_hos_monthly_statement_item.cs


示例5: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_dict_type model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_dict_type(");
            strSql.Append("ID,TYPE_CODE,TYPE_NAME,HELP_CODE,CREATE_DATE,CREATE_BY)");
            strSql.Append(" values (");
            strSql.Append("@ID,@TYPE_CODE,@TYPE_NAME,@HELP_CODE,@CREATE_DATE,@CREATE_BY)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@TYPE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@TYPE_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.TYPE_CODE;
            parameters[2].Value = model.TYPE_NAME;
            parameters[3].Value = model.HELP_CODE;
            parameters[4].Value = model.CREATE_DATE;
            parameters[5].Value = model.CREATE_BY;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:34,代码来源:his_comm_dict_type.cs


示例6: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_efficacy model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_efficacy(");
            strSql.Append("ID,EFFICACY_CODE,EFFICACY_NAME,HELP_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@EFFICACY_CODE,@EFFICACY_NAME,@HELP_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@EFFICACY_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@EFFICACY_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.EFFICACY_CODE;
            parameters[2].Value = model.EFFICACY_NAME;
            parameters[3].Value = model.HELP_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:30,代码来源:his_comm_efficacy.cs


示例7: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.comm_icd10 model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into comm_icd10(");
            strSql.Append("ID,ICD_CODE,ICD_NAME,HELP_CODE,TYPE_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@ICD_CODE,@ICD_NAME,@HELP_CODE,@TYPE_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@ICD_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@ICD_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@TYPE_CODE", MySqlDbType.VarChar,18)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.ICD_CODE;
            parameters[2].Value = model.ICD_NAME;
            parameters[3].Value = model.HELP_CODE;
            parameters[4].Value = model.TYPE_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:32,代码来源:comm_icd10.cs


示例8: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_bil_cl_receipt model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_bil_cl_receipt(");
            strSql.Append("CL_RECEIPT_CODE,CL_CODE,CASHIER,RECEICPT_CODE,RECIVER_TIME,CASH_AMT,CARD_AMT,INSURANCE_AMT,SUM_AMT,REFUND_RECP_CODE,REFUND_DATE,REFUND_OPT,REDUCE_AMT,REDUCE_DATE,REDUCE_OPT,REDUCE_REASON,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
            strSql.Append(" values (");
            strSql.Append("@CL_RECEIPT_CODE,@CL_CODE,@CASHIER,@RECEICPT_CODE,@RECIVER_TIME,@CASH_AMT,@CARD_AMT,@INSURANCE_AMT,@SUM_AMT,@REFUND_RECP_CODE,@REFUND_DATE,@REFUND_OPT,@REDUCE_AMT,@REDUCE_DATE,@REDUCE_OPT,@REDUCE_REASON,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@CL_RECEIPT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CL_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CASHIER", MySqlDbType.VarChar,18),
                    new MySqlParameter("@RECEICPT_CODE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@RECIVER_TIME", MySqlDbType.Date),
                    new MySqlParameter("@CASH_AMT", MySqlDbType.Float,10),
                    new MySqlParameter("@CARD_AMT", MySqlDbType.Float,10),
                    new MySqlParameter("@INSURANCE_AMT", MySqlDbType.Float,10),
                    new MySqlParameter("@SUM_AMT", MySqlDbType.Float,10),
                    new MySqlParameter("@REFUND_RECP_CODE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@REFUND_DATE", MySqlDbType.Date),
                    new MySqlParameter("@REFUND_OPT", MySqlDbType.VarChar,18),
                    new MySqlParameter("@REDUCE_AMT", MySqlDbType.Int32,11),
                    new MySqlParameter("@REDUCE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@REDUCE_OPT", MySqlDbType.VarChar,18),
                    new MySqlParameter("@REDUCE_REASON", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_USER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_DATE", MySqlDbType.Date),
                    new MySqlParameter("@OPT_TERM", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_ORGA", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.CL_RECEIPT_CODE;
            parameters[1].Value = model.CL_CODE;
            parameters[2].Value = model.CASHIER;
            parameters[3].Value = model.RECEICPT_CODE;
            parameters[4].Value = model.RECIVER_TIME;
            parameters[5].Value = model.CASH_AMT;
            parameters[6].Value = model.CARD_AMT;
            parameters[7].Value = model.INSURANCE_AMT;
            parameters[8].Value = model.SUM_AMT;
            parameters[9].Value = model.REFUND_RECP_CODE;
            parameters[10].Value = model.REFUND_DATE;
            parameters[11].Value = model.REFUND_OPT;
            parameters[12].Value = model.REDUCE_AMT;
            parameters[13].Value = model.REDUCE_DATE;
            parameters[14].Value = model.REDUCE_OPT;
            parameters[15].Value = model.REDUCE_REASON;
            parameters[16].Value = model.OPT_USER;
            parameters[17].Value = model.OPT_DATE;
            parameters[18].Value = model.OPT_TERM;
            parameters[19].Value = model.OPT_ORGA;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:62,代码来源:his_bil_cl_receipt.cs


示例9: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_ds_import model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_ds_import(");
            strSql.Append("ID,IMPORT_CODE,IMPORT_TYPE,MANUFACTURE_CODE,MANUFACTURE_NAME,INVOICE_NO,ACCOUNT_FLAG,ACCOUNT_DATE,ISPAY_FLAG,PAY_TIME,CONTRACT_NO,IMPORT_FLAG,COST,CREATE_BY,CREATE_DATE,PURCHASER,PURCHASE_DATE,CANCEL_OPRATOR,CANCEL_DATE,HOSPITAL_CODE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@IMPORT_CODE,@IMPORT_TYPE,@MANUFACTURE_CODE,@MANUFACTURE_NAME,@INVOICE_NO,@ACCOUNT_FLAG,@ACCOUNT_DATE,@ISPAY_FLAG,@PAY_TIME,@CONTRACT_NO,@IMPORT_FLAG,@COST,@CREATE_BY,@CREATE_DATE,@PURCHASER,@PURCHASE_DATE,@CANCEL_OPRATOR,@CANCEL_DATE,@HOSPITAL_CODE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@IMPORT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@IMPORT_TYPE", MySqlDbType.VarChar,2),
                    new MySqlParameter("@MANUFACTURE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MANUFACTURE_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@INVOICE_NO", MySqlDbType.VarChar,128),
                    new MySqlParameter("@ACCOUNT_FLAG", MySqlDbType.VarChar,2),
                    new MySqlParameter("@ACCOUNT_DATE", MySqlDbType.Date),
                    new MySqlParameter("@ISPAY_FLAG", MySqlDbType.VarChar,2),
                    new MySqlParameter("@PAY_TIME", MySqlDbType.Date),
                    new MySqlParameter("@CONTRACT_NO", MySqlDbType.VarChar,128),
                    new MySqlParameter("@IMPORT_FLAG", MySqlDbType.VarChar,20),
                    new MySqlParameter("@COST", MySqlDbType.Decimal,12),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,20),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@PURCHASER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@PURCHASE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CANCEL_OPRATOR", MySqlDbType.VarChar,20),
                    new MySqlParameter("@CANCEL_DATE", MySqlDbType.Date),
                    new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.IMPORT_CODE;
            parameters[2].Value = model.IMPORT_TYPE;
            parameters[3].Value = model.MANUFACTURE_CODE;
            parameters[4].Value = model.MANUFACTURE_NAME;
            parameters[5].Value = model.INVOICE_NO;
            parameters[6].Value = model.ACCOUNT_FLAG;
            parameters[7].Value = model.ACCOUNT_DATE;
            parameters[8].Value = model.ISPAY_FLAG;
            parameters[9].Value = model.PAY_TIME;
            parameters[10].Value = model.CONTRACT_NO;
            parameters[11].Value = model.IMPORT_FLAG;
            parameters[12].Value = model.COST;
            parameters[13].Value = model.CREATE_BY;
            parameters[14].Value = model.CREATE_DATE;
            parameters[15].Value = model.PURCHASER;
            parameters[16].Value = model.PURCHASE_DATE;
            parameters[17].Value = model.CANCEL_OPRATOR;
            parameters[18].Value = model.CANCEL_DATE;
            parameters[19].Value = model.HOSPITAL_CODE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:62,代码来源:his_ds_import.cs


示例10: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_medinfo model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_medinfo(");
            strSql.Append("ID,MED_CODE,MED_NAME,HELP_CODE,MENUFACTURE_CODE,MED_SPC,MED_UNIT,DOSAGE_CODE,APPROVAL_NUMBER,EFFICACY_CODE,ORIGIN,CREATE_BY,CREATE_DATE,MEDINFO_CODE,PAKAGE_UNIT,PAKAGE_PM_NUMBER,DEFAULT_DOSAGE_AMOUNT)");
            strSql.Append(" values (");
            strSql.Append("@ID,@MED_CODE,@MED_NAME,@HELP_CODE,@MENUFACTURE_CODE,@MED_SPC,@MED_UNIT,@DOSAGE_CODE,@APPROVAL_NUMBER,@EFFICACY_CODE,@ORIGIN,@CREATE_BY,@CREATE_DATE,@MEDINFO_CODE,@PAKAGE_UNIT,@PAKAGE_PM_NUMBER,@DEFAULT_DOSAGE_AMOUNT)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MENUFACTURE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_SPC", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MED_UNIT", MySqlDbType.VarChar,128),
                    new MySqlParameter("@DOSAGE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@APPROVAL_NUMBER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@EFFICACY_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@ORIGIN", MySqlDbType.VarChar,128),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@MEDINFO_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@PAKAGE_UNIT", MySqlDbType.VarChar,20),
                    new MySqlParameter("@PAKAGE_PM_NUMBER", MySqlDbType.Int32,11),
                    new MySqlParameter("@DEFAULT_DOSAGE_AMOUNT", MySqlDbType.Decimal,12)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.MED_CODE;
            parameters[2].Value = model.MED_NAME;
            parameters[3].Value = model.HELP_CODE;
            parameters[4].Value = model.MENUFACTURE_CODE;
            parameters[5].Value = model.MED_SPC;
            parameters[6].Value = model.MED_UNIT;
            parameters[7].Value = model.DOSAGE_CODE;
            parameters[8].Value = model.APPROVAL_NUMBER;
            parameters[9].Value = model.EFFICACY_CODE;
            parameters[10].Value = model.ORIGIN;
            parameters[11].Value = model.CREATE_BY;
            parameters[12].Value = model.CREATE_DATE;
            parameters[13].Value = model.MEDINFO_CODE;
            parameters[14].Value = model.PAKAGE_UNIT;
            parameters[15].Value = model.PAKAGE_PM_NUMBER;
            parameters[16].Value = model.DEFAULT_DOSAGE_AMOUNT;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:56,代码来源:his_comm_medinfo.cs


示例11: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_cl_order_item model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_cl_order_item(");
            strSql.Append("ID,CL_PRES_CODE,CL_CODE,ITEM_CODE,ITEM_NAME,COUNT,PRICE,ITEM_TYPE,SPEC,UNIT,SUM_AMT,STATUS,HERB_NUM,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
            strSql.Append(" values (");
            strSql.Append("@ID,@CL_PRES_CODE,@CL_CODE,@ITEM_CODE,@ITEM_NAME,@COUNT,@PRICE,@ITEM_TYPE,@SPEC,@UNIT,@SUM_AMT,@STATUS,@HERB_NUM,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CL_PRES_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CL_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@ITEM_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@ITEM_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@COUNT", MySqlDbType.Float,10),
                    new MySqlParameter("@PRICE", MySqlDbType.Float,10),
                    new MySqlParameter("@ITEM_TYPE", MySqlDbType.VarChar,1),
                    new MySqlParameter("@SPEC", MySqlDbType.VarChar,128),
                    new MySqlParameter("@UNIT", MySqlDbType.VarChar,128),
                    new MySqlParameter("@SUM_AMT", MySqlDbType.Float,10),
                    new MySqlParameter("@STATUS", MySqlDbType.VarChar,1),
                    new MySqlParameter("@HERB_NUM", MySqlDbType.Float,10),
                    new MySqlParameter("@OPT_USER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_DATE", MySqlDbType.Date),
                    new MySqlParameter("@OPT_TERM", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_ORGA", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.CL_PRES_CODE;
            parameters[2].Value = model.CL_CODE;
            parameters[3].Value = model.ITEM_CODE;
            parameters[4].Value = model.ITEM_NAME;
            parameters[5].Value = model.COUNT;
            parameters[6].Value = model.PRICE;
            parameters[7].Value = model.ITEM_TYPE;
            parameters[8].Value = model.SPEC;
            parameters[9].Value = model.UNIT;
            parameters[10].Value = model.SUM_AMT;
            parameters[11].Value = model.STATUS;
            parameters[12].Value = model.HERB_NUM;
            parameters[13].Value = model.OPT_USER;
            parameters[14].Value = model.OPT_DATE;
            parameters[15].Value = model.OPT_TERM;
            parameters[16].Value = model.OPT_ORGA;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:56,代码来源:his_cl_order_item.cs


示例12: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_manufacture model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_manufacture(");
            strSql.Append("ID,MANUFACTURE_CODE,MANUFACTURE_NAME,LOCALITY_TYPE,CREDIT_CODE,MANUFACTURE_ADDRESS,LINK_MAN,LINK_TEL,LINK_EMAIL,FAX,APTITUDE,APTITUDE_DATE,HELP_CODE,HOSPITAL_CODE,CREATE_DATE,CREATE_BY)");
            strSql.Append(" values (");
            strSql.Append("@ID,@MANUFACTURE_CODE,@MANUFACTURE_NAME,@LOCALITY_TYPE,@CREDIT_CODE,@MANUFACTURE_ADDRESS,@LINK_MAN,@LINK_TEL,@LINK_EMAIL,@FAX,@APTITUDE,@APTITUDE_DATE,@HELP_CODE,@HOSPITAL_CODE,@CREATE_DATE,@CREATE_BY)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MANUFACTURE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MANUFACTURE_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@LOCALITY_TYPE", MySqlDbType.VarChar,2),
                    new MySqlParameter("@CREDIT_CODE", MySqlDbType.Int32,11),
                    new MySqlParameter("@MANUFACTURE_ADDRESS", MySqlDbType.VarChar,128),
                    new MySqlParameter("@LINK_MAN", MySqlDbType.VarChar,128),
                    new MySqlParameter("@LINK_TEL", MySqlDbType.VarChar,128),
                    new MySqlParameter("@LINK_EMAIL", MySqlDbType.VarChar,128),
                    new MySqlParameter("@FAX", MySqlDbType.VarChar,128),
                    new MySqlParameter("@APTITUDE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@APTITUDE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.MANUFACTURE_CODE;
            parameters[2].Value = model.MANUFACTURE_NAME;
            parameters[3].Value = model.LOCALITY_TYPE;
            parameters[4].Value = model.CREDIT_CODE;
            parameters[5].Value = model.MANUFACTURE_ADDRESS;
            parameters[6].Value = model.LINK_MAN;
            parameters[7].Value = model.LINK_TEL;
            parameters[8].Value = model.LINK_EMAIL;
            parameters[9].Value = model.FAX;
            parameters[10].Value = model.APTITUDE;
            parameters[11].Value = model.APTITUDE_DATE;
            parameters[12].Value = model.HELP_CODE;
            parameters[13].Value = model.HOSPITAL_CODE;
            parameters[14].Value = model.CREATE_DATE;
            parameters[15].Value = model.CREATE_BY;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:54,代码来源:his_comm_manufacture.cs


示例13: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_comm_doctor model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_comm_doctor(");
            strSql.Append("ID,DOCTOR_CODE,DOCTOR_NAME,DEPT_CODE,HISPITAL_CODE,DOCTOR_SEX,DOCTOR_TEL,DOCTOR_NATION,MERRIAGE_CODE,DOCTOR_EMAIL,DOCTOR_TITLE,DOCTOR_TITLEGRADE,HELP_CODE,REMARK,USER_TYPE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@DOCTOR_CODE,@DOCTOR_NAME,@DEPT_CODE,@HISPITAL_CODE,@DOCTOR_SEX,@DOCTOR_TEL,@DOCTOR_NATION,@MERRIAGE_CODE,@DOCTOR_EMAIL,@DOCTOR_TITLE,@DOCTOR_TITLEGRADE,@HELP_CODE,@REMARK,@USER_TYPE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@DEPT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@HISPITAL_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_SEX", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_TEL", MySqlDbType.VarChar,128),
                    new MySqlParameter("@DOCTOR_NATION", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MERRIAGE_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_EMAIL", MySqlDbType.VarChar,128),
                    new MySqlParameter("@DOCTOR_TITLE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@DOCTOR_TITLEGRADE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@HELP_CODE", MySqlDbType.VarChar,128),
                    new MySqlParameter("@REMARK", MySqlDbType.VarChar,128),
                    new MySqlParameter("@USER_TYPE", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.DOCTOR_CODE;
            parameters[2].Value = model.DOCTOR_NAME;
            parameters[3].Value = model.DEPT_CODE;
            parameters[4].Value = model.HISPITAL_CODE;
            parameters[5].Value = model.DOCTOR_SEX;
            parameters[6].Value = model.DOCTOR_TEL;
            parameters[7].Value = model.DOCTOR_NATION;
            parameters[8].Value = model.MERRIAGE_CODE;
            parameters[9].Value = model.DOCTOR_EMAIL;
            parameters[10].Value = model.DOCTOR_TITLE;
            parameters[11].Value = model.DOCTOR_TITLEGRADE;
            parameters[12].Value = model.HELP_CODE;
            parameters[13].Value = model.REMARK;
            parameters[14].Value = model.USER_TYPE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:52,代码来源:his_comm_doctor.cs


示例14: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_ds_importinfo model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_ds_importinfo(");
            strSql.Append("ID,IMPORT_CODE,MED_CODE,MED_NAME,PAKAGE_UNIT,PAKAGE_AMOUNT,MENUFACTURE_CODE,MEDINFO_CODE,MED_SPC,MED_PRICE,PURCHASE_PRICE,VALIDITY_DATE,BATCHNO,MED_MADETIME,WHOLESALE_PRICE)");
            strSql.Append(" values (");
            strSql.Append("@ID,@IMPORT_CODE,@MED_CODE,@MED_NAME,@PAKAGE_UNIT,@PAKAGE_AMOUNT,@MENUFACTURE_CODE,@MEDINFO_CODE,@MED_SPC,@MED_PRICE,@PURCHASE_PRICE,@VALIDITY_DATE,@BATCHNO,@MED_MADETIME,@WHOLESALE_PRICE)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@IMPORT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_NAME", MySqlDbType.VarChar,128),
                    new MySqlParameter("@PAKAGE_UNIT", MySqlDbType.VarChar,128),
                    new MySqlParameter("@PAKAGE_AMOUNT", MySqlDbType.Int32,11),
                    new MySqlParameter("@MENUFACTURE_CODE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@MEDINFO_CODE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@MED_SPC", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MED_PRICE", MySqlDbType.Decimal,12),
                    new MySqlParameter("@PURCHASE_PRICE", MySqlDbType.Decimal,12),
                    new MySqlParameter("@VALIDITY_DATE", MySqlDbType.Date),
                    new MySqlParameter("@BATCHNO", MySqlDbType.VarChar,20),
                    new MySqlParameter("@MED_MADETIME", MySqlDbType.Date),
                    new MySqlParameter("@WHOLESALE_PRICE", MySqlDbType.Decimal,12)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.IMPORT_CODE;
            parameters[2].Value = model.MED_CODE;
            parameters[3].Value = model.MED_NAME;
            parameters[4].Value = model.PAKAGE_UNIT;
            parameters[5].Value = model.PAKAGE_AMOUNT;
            parameters[6].Value = model.MENUFACTURE_CODE;
            parameters[7].Value = model.MEDINFO_CODE;
            parameters[8].Value = model.MED_SPC;
            parameters[9].Value = model.MED_PRICE;
            parameters[10].Value = model.PURCHASE_PRICE;
            parameters[11].Value = model.VALIDITY_DATE;
            parameters[12].Value = model.BATCHNO;
            parameters[13].Value = model.MED_MADETIME;
            parameters[14].Value = model.WHOLESALE_PRICE;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:52,代码来源:his_ds_importinfo.cs


示例15: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_pm_checkinfo model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_pm_checkinfo(");
            strSql.Append("ID,MEDINFO_CODE,MED_SPC,MED_UNIT,MED_AMOUNT,REAL_AMOUNT,MED_PRICE,PURCHASE_PRICE,WHOLESALE_PRICE,VALIDITY_DATE,MED_MADETIME,BACHNO,DEPT_CODE,CREATE_DATE,CREATE_BY)");
            strSql.Append(" values (");
            strSql.Append("@ID,@MEDINFO_CODE,@MED_SPC,@MED_UNIT,@MED_AMOUNT,@REAL_AMOUNT,@MED_PRICE,@PURCHASE_PRICE,@WHOLESALE_PRICE,@VALIDITY_DATE,@MED_MADETIME,@BACHNO,@DEPT_CODE,@CREATE_DATE,@CREATE_BY)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MEDINFO_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@MED_SPC", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MED_UNIT", MySqlDbType.VarChar,128),
                    new MySqlParameter("@MED_AMOUNT", MySqlDbType.Decimal,12),
                    new MySqlParameter("@REAL_AMOUNT", MySqlDbType.Decimal,12),
                    new MySqlParameter("@MED_PRICE", MySqlDbType.Decimal,12),
                    new MySqlParameter("@PURCHASE_PRICE", MySqlDbType.Decimal,12),
                    new MySqlParameter("@WHOLESALE_PRICE", MySqlDbType.Decimal,12),
                    new MySqlParameter("@VALIDITY_DATE", MySqlDbType.Date),
                    new MySqlParameter("@MED_MADETIME", MySqlDbType.Date),
                    new MySqlParameter("@BACHNO", MySqlDbType.VarChar,128),
                    new MySqlParameter("@DEPT_CODE", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
                    new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.MEDINFO_CODE;
            parameters[2].Value = model.MED_SPC;
            parameters[3].Value = model.MED_UNIT;
            parameters[4].Value = model.MED_AMOUNT;
            parameters[5].Value = model.REAL_AMOUNT;
            parameters[6].Value = model.MED_PRICE;
            parameters[7].Value = model.PURCHASE_PRICE;
            parameters[8].Value = model.WHOLESALE_PRICE;
            parameters[9].Value = model.VALIDITY_DATE;
            parameters[10].Value = model.MED_MADETIME;
            parameters[11].Value = model.BACHNO;
            parameters[12].Value = model.DEPT_CODE;
            parameters[13].Value = model.CREATE_DATE;
            parameters[14].Value = model.CREATE_BY;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:liyuanli66,项目名称:His,代码行数:52,代码来源:his_pm_checkinfo.cs


示例16: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(HisClient.Model.his_bil_counter model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into his_bil_counter(");
            strSql.Append("ID,CASHIER,START_IVNNO,END_IVNNO,RECP_TYPE,USE_TYPE,RECP_COUNT,PRE_CODE,REFOUNDED_COUNT,INVALID_COUNT,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
            strSql.Append(" values (");
            strSql.Append("@ID,@CASHIER,@START_IVNNO,@END_IVNNO,@RECP_TYPE,@USE_TYPE,@RECP_COUNT,@PRE_CODE,@REFOUNDED_COUNT,@INVALID_COUNT,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@ID", MySqlDbType.VarChar,18),
                    new MySqlParameter("@CASHIER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@START_IVNNO", MySqlDbType.VarChar,20),
                    new MySqlParameter("@END_IVNNO", MySqlDbType.VarChar,20),
                    new MySqlParameter("@RECP_TYPE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@USE_TYPE", MySqlDbType.VarChar,2),
                    new MySqlParameter("@RECP_COUNT", MySqlDbType.Float,5),
                    new MySqlParameter("@PRE_CODE", MySqlDbType.VarChar,20),
                    new MySqlParameter("@REFOUNDED_COUNT", MySqlDbType.Float,5),
                    new MySqlParameter("@INVALID_COUNT", MySqlDbType.Float,5),
                    new MySqlParameter("@OPT_USER", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_DATE", MySqlDbType.Date),
                    new MySqlParameter("@OPT_TERM", MySqlDbType.VarChar,128),
                    new MySqlParameter("@OPT_ORGA", MySqlDbType.VarChar,128)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.CASHIER;
            parameters[2].Value = model.START_IVNNO;
            parameters[3].Value = model.END_IVNNO;
            parameters[4].Value = model.RECP_TYPE;
            parameters[5].Value = model.USE_TYPE;
            parameters[6].Value = model.RECP_COUNT;
            parameters[7].Value = model.PRE_CODE;
            parameters[8].Value = model.REFOUNDED_COUNT;
            parameters[9].Value = model.INVALID_COUNT;
            parameters[10].Value = model.OPT_USER;
            parameters[11].Value = model.OPT_DATE;
            parameters[12].Value = model.OPT_TERM;
            parameters[13].Value = model.OPT_ORGA;

            int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),paramet 

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# HiscoreData类代码示例发布时间:2022-05-24
下一篇:
C# Highcharts类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap