本文整理汇总了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
|
请发表评论