/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_ds_export model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_ds_export(");
strSql.Append("ID,EXPORT_CODE,MANUFACTURE_NAME,MANUFACTURE_CODE,EXPORT_TYPE,EXPORT_DEPT,CREATE_BY,CREATE_DATE,COST,OPERATOR_NAME,OPERATOR_DATE,CANCEL_OPERATOR,CANCEL_DATE)");
strSql.Append(" values (");
strSql.Append("@ID,@EXPORT_CODE,@MANUFACTURE_NAME,@MANUFACTURE_CODE,@EXPORT_TYPE,@EXPORT_DEPT,@CREATE_BY,@CREATE_DATE,@COST,@OPERATOR_NAME,@OPERATOR_DATE,@CANCEL_OPERATOR,@CANCEL_DATE)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@EXPORT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@MANUFACTURE_NAME", MySqlDbType.VarChar,128),
new MySqlParameter("@MANUFACTURE_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@EXPORT_TYPE", MySqlDbType.VarChar,2),
new MySqlParameter("@EXPORT_DEPT", MySqlDbType.VarChar,18),
new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
new MySqlParameter("@COST", MySqlDbType.Decimal,12),
new MySqlParameter("@OPERATOR_NAME", MySqlDbType.VarChar,128),
new MySqlParameter("@OPERATOR_DATE", MySqlDbType.Date),
new MySqlParameter("@CANCEL_OPERATOR", MySqlDbType.VarChar,20),
new MySqlParameter("@CANCEL_DATE", MySqlDbType.Date)};
parameters[0].Value = model.ID;
parameters[1].Value = model.EXPORT_CODE;
parameters[2].Value = model.MANUFACTURE_NAME;
parameters[3].Value = model.MANUFACTURE_CODE;
parameters[4].Value = model.EXPORT_TYPE;
parameters[5].Value = model.EXPORT_DEPT;
parameters[6].Value = model.CREATE_BY;
parameters[7].Value = model.CREATE_DATE;
parameters[8].Value = model.COST;
parameters[9].Value = model.OPERATOR_NAME;
parameters[10].Value = model.OPERATOR_DATE;
parameters[11].Value = model.CANCEL_OPERATOR;
parameters[12].Value = model.CANCEL_DATE;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_hos_receipt_detail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_hos_receipt_detail(");
strSql.Append("ID,HOS_RECEIPT_CODE,HIS_HOS_CODE,FEEITEM_CODE,FEEITEM_NAME,PRICE,COUNT,UNIT,AMT,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
strSql.Append(" values (");
strSql.Append("@ID,@HOS_RECEIPT_CODE,@HIS_HOS_CODE,@FEEITEM_CODE,@FEEITEM_NAME,@PRICE,@COUNT,@UNIT,@AMT,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@HOS_RECEIPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@HIS_HOS_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@FEEITEM_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@FEEITEM_NAME", MySqlDbType.VarChar,18),
new MySqlParameter("@PRICE", MySqlDbType.Float,10),
new MySqlParameter("@COUNT", MySqlDbType.Float,10),
new MySqlParameter("@UNIT", MySqlDbType.VarChar,128),
new MySqlParameter("@AMT", 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.HOS_RECEIPT_CODE;
parameters[2].Value = model.HIS_HOS_CODE;
parameters[3].Value = model.FEEITEM_CODE;
parameters[4].Value = model.FEEITEM_NAME;
parameters[5].Value = model.PRICE;
parameters[6].Value = model.COUNT;
parameters[7].Value = model.UNIT;
parameters[8].Value = model.AMT;
parameters[9].Value = model.OPT_USER;
parameters[10].Value = model.OPT_DATE;
parameters[11].Value = model.OPT_TERM;
parameters[12].Value = model.OPT_ORGA;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_cl_medical_record model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_cl_medical_record(");
strSql.Append("CL_CODE,PHA_CODE,DOCTOR_CODE,CL_DATE,IP,ICD_CODE,ICD_NAME,MEMO,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
strSql.Append(" values (");
strSql.Append("@CL_CODE,@PHA_CODE,@DOCTOR_CODE,@CL_DATE,@IP,@ICD_CODE,@ICD_NAME,@MEMO,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
MySqlParameter[] parameters = {
new MySqlParameter("@CL_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@PHA_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@DOCTOR_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@CL_DATE", MySqlDbType.Date),
new MySqlParameter("@IP", MySqlDbType.VarChar,18),
new MySqlParameter("@ICD_CODE", MySqlDbType.VarChar,128),
new MySqlParameter("@ICD_NAME", MySqlDbType.VarChar,128),
new MySqlParameter("@MEMO", 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_CODE;
parameters[1].Value = model.PHA_CODE;
parameters[2].Value = model.DOCTOR_CODE;
parameters[3].Value = model.CL_DATE;
parameters[4].Value = model.IP;
parameters[5].Value = model.ICD_CODE;
parameters[6].Value = model.ICD_NAME;
parameters[7].Value = model.MEMO;
parameters[8].Value = model.OPT_USER;
parameters[9].Value = model.OPT_DATE;
parameters[10].Value = model.OPT_TERM;
parameters[11].Value = model.OPT_ORGA;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_comm_account model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_comm_account(");
strSql.Append("ID,ACCOUNT,PASSWORD,ROLE_CODE,USER_CODE,ADMIN_TYPE,IS_USE,AUTHORITY_XML,CREATE_DATE,CREATE_BY,LAST_LOGINTIME,HOSPITAL_CODE)");
strSql.Append(" values (");
strSql.Append("@ID,@ACCOUNT,@PASSWORD,@ROLE_CODE,@USER_CODE,@ADMIN_TYPE,@IS_USE,@AUTHORITY_XML,@CREATE_DATE,@CREATE_BY,@LAST_LOGINTIME,@HOSPITAL_CODE)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@ACCOUNT", MySqlDbType.VarChar,128),
new MySqlParameter("@PASSWORD", MySqlDbType.VarChar,128),
new MySqlParameter("@ROLE_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@USER_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@ADMIN_TYPE", MySqlDbType.VarChar,2),
new MySqlParameter("@IS_USE", MySqlDbType.VarChar,2),
new MySqlParameter("@AUTHORITY_XML", MySqlDbType.VarChar,4000),
new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
new MySqlParameter("@LAST_LOGINTIME", MySqlDbType.Date),
new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18)};
parameters[0].Value = model.ID;
parameters[1].Value = model.ACCOUNT;
parameters[2].Value = model.PASSWORD;
parameters[3].Value = model.ROLE_CODE;
parameters[4].Value = model.USER_CODE;
parameters[5].Value = model.ADMIN_TYPE;
parameters[6].Value = model.IS_USE;
parameters[7].Value = model.AUTHORITY_XML;
parameters[8].Value = model.CREATE_DATE;
parameters[9].Value = model.CREATE_BY;
parameters[10].Value = model.LAST_LOGINTIME;
parameters[11].Value = model.HOSPITAL_CODE;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_cl_pres_detail_cancle model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_cl_pres_detail_cancle(");
strSql.Append("ID,CL_PRES_CODE,CL_CODE,STATUS,APPLY_DEPT_CODE,DOCTOR_CODE,OPERATE_DEPT_CODE,SUM_AMT,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
strSql.Append(" values (");
strSql.Append("@ID,@CL_PRES_CODE,@CL_CODE,@STATUS,@APPLY_DEPT_CODE,@DOCTOR_CODE,@OPERATE_DEPT_CODE,@SUM_AMT,@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("@STATUS", MySqlDbType.VarChar,2),
new MySqlParameter("@APPLY_DEPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@DOCTOR_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@OPERATE_DEPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@SUM_AMT", 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.STATUS;
parameters[4].Value = model.APPLY_DEPT_CODE;
parameters[5].Value = model.DOCTOR_CODE;
parameters[6].Value = model.OPERATE_DEPT_CODE;
parameters[7].Value = model.SUM_AMT;
parameters[8].Value = model.OPT_USER;
parameters[9].Value = model.OPT_DATE;
parameters[10].Value = model.OPT_TERM;
parameters[11].Value = model.OPT_ORGA;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_hos_account model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_hos_account(");
strSql.Append("HOS_ACC_CODE,HIS_HOS_CODE,IP,SUM_IN,SUM_OUT,ACCOUNT_BALANCE,LOWER_LIMIT,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
strSql.Append(" values (");
strSql.Append("@HOS_ACC_CODE,@HIS_HOS_CODE,@IP,@SUM_IN,@SUM_OUT,@ACCOUNT_BALANCE,@LOWER_LIMIT,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
MySqlParameter[] parameters = {
new MySqlParameter("@HOS_ACC_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@HIS_HOS_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@IP", MySqlDbType.VarChar,18),
new MySqlParameter("@SUM_IN", MySqlDbType.Float,10),
new MySqlParameter("@SUM_OUT", MySqlDbType.Float,10),
new MySqlParameter("@ACCOUNT_BALANCE", MySqlDbType.Float,10),
new MySqlParameter("@LOWER_LIMIT", 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.HOS_ACC_CODE;
parameters[1].Value = model.HIS_HOS_CODE;
parameters[2].Value = model.IP;
parameters[3].Value = model.SUM_IN;
parameters[4].Value = model.SUM_OUT;
parameters[5].Value = model.ACCOUNT_BALANCE;
parameters[6].Value = model.LOWER_LIMIT;
parameters[7].Value = model.OPT_USER;
parameters[8].Value = model.OPT_DATE;
parameters[9].Value = model.OPT_TERM;
parameters[10].Value = model.OPT_ORGA;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_hos_monthly_statement model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_hos_monthly_statement(");
strSql.Append("OPERATOR,OPERATE_TIME,RECIVER,START_TIME,END_TIME,START_RECEIPT_CODE,END_RECEIPT_CODE,RECEIPT__NUM,RETUEN_RECEIPT_NUM,ID)");
strSql.Append(" values (");
strSql.Append("@OPERATOR,@OPERATE_TIME,@RECIVER,@START_TIME,@END_TIME,@START_RECEIPT_CODE,@END_RECEIPT_CODE,@RECEIPT__NUM,@RETUEN_RECEIPT_NUM,@ID)");
MySqlParameter[] parameters = {
new MySqlParameter("@OPERATOR", MySqlDbType.VarChar,18),
new MySqlParameter("@OPERATE_TIME", MySqlDbType.Date),
new MySqlParameter("@RECIVER", MySqlDbType.VarChar,18),
new MySqlParameter("@START_TIME", MySqlDbType.Date),
new MySqlParameter("@END_TIME", MySqlDbType.Date),
new MySqlParameter("@START_RECEIPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@END_RECEIPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@RECEIPT__NUM", MySqlDbType.VarChar,18),
new MySqlParameter("@RETUEN_RECEIPT_NUM", MySqlDbType.VarChar,18),
new MySqlParameter("@ID", MySqlDbType.VarChar,18)};
parameters[0].Value = model.OPERATOR;
parameters[1].Value = model.OPERATE_TIME;
parameters[2].Value = model.RECIVER;
parameters[3].Value = model.START_TIME;
parameters[4].Value = model.END_TIME;
parameters[5].Value = model.START_RECEIPT_CODE;
parameters[6].Value = model.END_RECEIPT_CODE;
parameters[7].Value = model.RECEIPT__NUM;
parameters[8].Value = model.RETUEN_RECEIPT_NUM;
parameters[9].Value = model.ID;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_hos_account_log model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_hos_account_log(");
strSql.Append("ID,HOS_ACC_CODE,HIS_HOS_CODE,AMT,PAY_TYPE,IS_REFUND,OPT_USER,OPT_DATE,OPT_TERM,OPT_ORGA)");
strSql.Append(" values (");
strSql.Append("@ID,@HOS_ACC_CODE,@HIS_HOS_CODE,@AMT,@PAY_TYPE,@IS_REFUND,@OPT_USER,@OPT_DATE,@OPT_TERM,@OPT_ORGA)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@HOS_ACC_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@HIS_HOS_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@AMT", MySqlDbType.Float,12),
new MySqlParameter("@PAY_TYPE", MySqlDbType.VarChar,1),
new MySqlParameter("@IS_REFUND", MySqlDbType.VarChar,1),
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.HOS_ACC_CODE;
parameters[2].Value = model.HIS_HOS_CODE;
parameters[3].Value = model.AMT;
parameters[4].Value = model.PAY_TYPE;
parameters[5].Value = model.IS_REFUND;
parameters[6].Value = model.OPT_USER;
parameters[7].Value = model.OPT_DATE;
parameters[8].Value = model.OPT_TERM;
parameters[9].Value = model.OPT_ORGA;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_pm_check model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_pm_check(");
strSql.Append("ID,CHECK_CODE,CREATE_BY,CREATE_DATE,DEPT_CODE,DEPT_NAME,MEMO,LOSE_COST,PROFIT_COST)");
strSql.Append(" values (");
strSql.Append("@ID,@CHECK_CODE,@CREATE_BY,@CREATE_DATE,@DEPT_CODE,@DEPT_NAME,@MEMO,@LOSE_COST,@PROFIT_COST)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@CHECK_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128),
new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
new MySqlParameter("@DEPT_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@DEPT_NAME", MySqlDbType.VarChar,128),
new MySqlParameter("@MEMO", MySqlDbType.VarChar,128),
new MySqlParameter("@LOSE_COST", MySqlDbType.Decimal,12),
new MySqlParameter("@PROFIT_COST", MySqlDbType.Decimal,12)};
parameters[0].Value = model.ID;
parameters[1].Value = model.CHECK_CODE;
parameters[2].Value = model.CREATE_BY;
parameters[3].Value = model.CREATE_DATE;
parameters[4].Value = model.DEPT_CODE;
parameters[5].Value = model.DEPT_NAME;
parameters[6].Value = model.MEMO;
parameters[7].Value = model.LOSE_COST;
parameters[8].Value = model.PROFIT_COST;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HisClient.Model.his_comm_function model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into his_comm_function(");
strSql.Append("ID,MODULE_CODE,FUNCTION_CODE,FUNCTION_NAME,IS_USE,HOSPITAL_CODE,REMARKS,CREATE_DATE,CREATE_BY)");
strSql.Append(" values (");
strSql.Append("@ID,@MODULE_CODE,@FUNCTION_CODE,@FUNCTION_NAME,@IS_USE,@HOSPITAL_CODE,@REMARKS,@CREATE_DATE,@CREATE_BY)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,18),
new MySqlParameter("@MODULE_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@FUNCTION_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@FUNCTION_NAME", MySqlDbType.VarChar,128),
new MySqlParameter("@IS_USE", MySqlDbType.VarChar,2),
new MySqlParameter("@HOSPITAL_CODE", MySqlDbType.VarChar,18),
new MySqlParameter("@REMARKS", MySqlDbType.VarChar,128),
new MySqlParameter("@CREATE_DATE", MySqlDbType.Date),
new MySqlParameter("@CREATE_BY", MySqlDbType.VarChar,128)};
parameters[0].Value = model.ID;
parameters[1].Value = model.MODULE_CODE;
parameters[2].Value = model.FUNCTION_CODE;
parameters[3].Value = model.FUNCTION_NAME;
parameters[4].Value = model.IS_USE;
parameters[5].Value = model.HOSPITAL_CODE;
parameters[6].Value = model.REMARKS;
parameters[7].Value = model.CREATE_DATE;
parameters[8].Value = model.CREATE_BY;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(HisClient.Model.his_pm_import model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HisClient.Model.his_pm_import model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(HisClient.Model.his_hos_daily_statement_itemty model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HisClient.Model.his_hos_daily_statement_itemty model)
{
return dal.Update(model);
}