/// <summary> /// 增加一条数据 /// </summary> public int Add(FMS_Model.fms_dkmassage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_dkmassage("); strSql.Append("id,datetime,price,account,user_id,user_name,channel,deal,stats,notes,is_delete,erp_dakuanhao,add_time,erp_bank_id,confirm_admin_id,confirm_time,erp_time,erp_type,acc_type,kingdee_current_account,is_send_out,kingdee_out_code,from_type,operate_userId,operate_time)"); strSql.Append(" values ("); strSql.Append("@id,@datetime,@price,@account,@user_id,@user_name,@channel,@deal,@stats,@notes,@is_delete,@erp_dakuanhao,@add_time,@erp_bank_id,@confirm_admin_id,@confirm_time,@erp_time,@erp_type,@acc_type,@kingdee_current_account,@is_send_out,@kingdee_out_code,@from_type,@operate_userId,@operate_time)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@datetime", MySqlDbType.DateTime), new MySqlParameter("@price", MySqlDbType.Decimal, 10), new MySqlParameter("@account", MySqlDbType.VarChar, 100), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@channel", MySqlDbType.VarChar, 100), new MySqlParameter("@deal", MySqlDbType.VarChar, 100), new MySqlParameter("@stats", MySqlDbType.VarChar, 2), new MySqlParameter("@notes", MySqlDbType.VarChar, 200), new MySqlParameter("@is_delete", MySqlDbType.Int16, 1), new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32), new MySqlParameter("@add_time", MySqlDbType.DateTime), new MySqlParameter("@erp_bank_id", MySqlDbType.VarChar, 32), new MySqlParameter("@confirm_admin_id", MySqlDbType.Int32, 11), new MySqlParameter("@confirm_time", MySqlDbType.DateTime), new MySqlParameter("@erp_time", MySqlDbType.DateTime), new MySqlParameter("@erp_type", MySqlDbType.Int16, 2), new MySqlParameter("@acc_type", MySqlDbType.Int16, 2), new MySqlParameter("@kingdee_current_account", MySqlDbType.VarChar, 100), new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2), new MySqlParameter("@kingdee_out_code", MySqlDbType.VarChar, 32), new MySqlParameter("@from_type", MySqlDbType.Int16, 2), new MySqlParameter("@operate_userId", MySqlDbType.Int32, 11), new MySqlParameter("@operate_time", MySqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.datetime; parameters[2].Value = model.price; parameters[3].Value = model.account; parameters[4].Value = model.user_id; parameters[5].Value = model.user_name; parameters[6].Value = model.channel; parameters[7].Value = model.deal; parameters[8].Value = model.stats; parameters[9].Value = model.notes; parameters[10].Value = model.is_delete; parameters[11].Value = model.erp_dakuanhao; parameters[12].Value = model.add_time; parameters[13].Value = model.erp_bank_id; parameters[14].Value = model.confirm_admin_id; parameters[15].Value = model.confirm_time; parameters[16].Value = model.erp_time; parameters[17].Value = model.erp_type; parameters[18].Value = model.acc_type; parameters[19].Value = model.kingdee_current_account; parameters[20].Value = model.is_send_out; parameters[21].Value = model.kingdee_out_code; parameters[22].Value = model.from_type; parameters[23].Value = model.operate_userId; parameters[24].Value = model.operate_time; object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.fms_ac_period model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fms_ac_period set "); strSql.Append("Factory_Id=@Factory_Id,"); strSql.Append("C_customerid=@C_customerid,"); strSql.Append("C_customer_code=@C_customer_code,"); strSql.Append("C_customername=@C_customername,"); strSql.Append("C_userid=@C_userid,"); strSql.Append("C_username=@C_username,"); strSql.Append("period_year=@period_year,"); strSql.Append("period_start=@period_start,"); strSql.Append("period_end=@period_end,"); strSql.Append("period_start_date=@period_start_date,"); strSql.Append("period_end_date=@period_end_date,"); strSql.Append("Is_stop=@Is_stop,"); strSql.Append("C_type=@C_type"); strSql.Append(" where Id=@Id "); MySqlParameter[] parameters = { new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@C_customerid", MySqlDbType.Int32, 11), new MySqlParameter("@C_customer_code", MySqlDbType.VarChar, 60), new MySqlParameter("@C_customername", MySqlDbType.VarChar, 200), new MySqlParameter("@C_userid", MySqlDbType.Int32, 11), new MySqlParameter("@C_username", MySqlDbType.VarChar, 60), new MySqlParameter("@period_year", MySqlDbType.VarChar, 4), new MySqlParameter("@period_start", MySqlDbType.Decimal, 18), new MySqlParameter("@period_end", MySqlDbType.Decimal, 18), new MySqlParameter("@period_start_date", MySqlDbType.DateTime), new MySqlParameter("@period_end_date", MySqlDbType.DateTime), new MySqlParameter("@Is_stop", MySqlDbType.Int16, 1), new MySqlParameter("@C_type", MySqlDbType.Int16, 1), new MySqlParameter("@Id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.Factory_Id; parameters[1].Value = model.C_customerid; parameters[2].Value = model.C_customer_code; parameters[3].Value = model.C_customername; parameters[4].Value = model.C_userid; parameters[5].Value = model.C_username; parameters[6].Value = model.period_year; parameters[7].Value = model.period_start; parameters[8].Value = model.period_end; parameters[9].Value = model.period_start_date; parameters[10].Value = model.period_end_date; parameters[11].Value = model.Is_stop; parameters[12].Value = model.C_type; parameters[13].Value = model.Id; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.fms_dkmassage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fms_dkmassage set "); strSql.Append("datetime=@datetime,"); strSql.Append("price=@price,"); strSql.Append("account=@account,"); strSql.Append("user_id=@user_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("channel=@channel,"); strSql.Append("deal=@deal,"); strSql.Append("stats=@stats,"); strSql.Append("notes=@notes,"); strSql.Append("is_delete=@is_delete,"); strSql.Append("erp_dakuanhao=@erp_dakuanhao,"); strSql.Append("add_time=@add_time,"); strSql.Append("erp_bank_id=@erp_bank_id,"); strSql.Append("confirm_admin_id=@confirm_admin_id,"); strSql.Append("confirm_time=@confirm_time,"); strSql.Append("erp_time=@erp_time,"); strSql.Append("erp_type=@erp_type,"); strSql.Append("acc_type=@acc_type"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@datetime", MySqlDbType.VarChar, 100), new MySqlParameter("@price", MySqlDbType.DateTime), new MySqlParameter("@account", MySqlDbType.VarChar, 100), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@channel", MySqlDbType.VarChar, 100), new MySqlParameter("@deal", MySqlDbType.VarChar, 100), new MySqlParameter("@stats", MySqlDbType.VarChar, 2), new MySqlParameter("@notes", MySqlDbType.VarChar, 200), new MySqlParameter("@is_delete", MySqlDbType.Int16, 1), new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32), new MySqlParameter("@add_time", MySqlDbType.DateTime), new MySqlParameter("@erp_bank_id", MySqlDbType.VarChar, 32), new MySqlParameter("@confirm_admin_id", MySqlDbType.Int32, 11), new MySqlParameter("@confirm_time", MySqlDbType.DateTime), new MySqlParameter("@erp_time", MySqlDbType.DateTime), new MySqlParameter("@erp_type", MySqlDbType.Int16, 2), new MySqlParameter("@acc_type", MySqlDbType.Int16, 2), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.datetime; parameters[1].Value = model.price; parameters[2].Value = model.account; parameters[3].Value = model.user_id; parameters[4].Value = model.user_name; parameters[5].Value = model.channel; parameters[6].Value = model.deal; parameters[7].Value = model.stats; parameters[8].Value = model.notes; parameters[9].Value = model.is_delete; parameters[10].Value = model.erp_dakuanhao; parameters[11].Value = model.add_time; parameters[12].Value = model.erp_bank_id; parameters[13].Value = model.confirm_admin_id; parameters[14].Value = model.confirm_time; parameters[15].Value = model.erp_time; parameters[16].Value = model.erp_type; parameters[17].Value = model.acc_type; parameters[18].Value = model.id; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(FMS_DbHelperMySQL.GetMaxID("id", "fms_dkmassage")); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_Model.fms_refund_bill model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_refund_bill("); strSql.Append("refund_id,refund_sn,refund_type,refund_status,emp_id,emp_code,emp_name,apply_date,user_id,customer_id,customer_name,refund_money,refund_capital_money,refund_remark,refund_bank_name,refund_bank_account,pay_method,pay_method_name,pay_id,pay_code,pay_name,pay_date,approvalOne_id,approvalOne_code,approvalOne_name,approvalOne_date,approvalTwo_id,approvalTwo_code,approvalTwo_name,approvalTwo_date,approvalThree_id,approvalThree_code,approvalThree_name,approvalThree_date,approvalFour_id,approvalFour_code,approvalFour_name,approvalFour_date,is_del,kingdee_current_account,is_send_out,kingdee_in_code,kingdee_out_code,print_num)"); strSql.Append(" values ("); strSql.Append("@refund_id,@refund_sn,@refund_type,@refund_status,@emp_id,@emp_code,@emp_name,@apply_date,@user_id,@customer_id,@customer_name,@refund_money,@refund_capital_money,@refund_remark,@refund_bank_name,@refund_bank_account,@pay_method,@pay_method_name,@pay_id,@pay_code,@pay_name,@pay_date,@approvalOne_id,@approvalOne_code,@approvalOne_name,@approvalOne_date,@approvalTwo_id,@approvalTwo_code,@approvalTwo_name,@approvalTwo_date,@approvalThree_id,@approvalThree_code,@approvalThree_name,@approvalThree_date,@approvalFour_id,@approvalFour_code,@approvalFour_name,@approvalFour_date,@is_del,@kingdee_current_account,@is_send_out,@kingdee_in_code,@kingdee_out_code,@print_num)"); MySqlParameter[] parameters = { new MySqlParameter("@refund_id", MySqlDbType.Int32, 11), new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20), new MySqlParameter("@refund_type", MySqlDbType.Int16, 2), new MySqlParameter("@refund_status", MySqlDbType.Int16, 2), new MySqlParameter("@emp_id", MySqlDbType.Int32, 11), new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20), new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50), new MySqlParameter("@apply_date", MySqlDbType.DateTime), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@customer_id", MySqlDbType.Int32, 11), new MySqlParameter("@customer_name", MySqlDbType.VarChar, 250), new MySqlParameter("@refund_money", MySqlDbType.Decimal, 12), new MySqlParameter("@refund_capital_money", MySqlDbType.VarChar, 200), new MySqlParameter("@refund_remark", MySqlDbType.VarChar, 500), new MySqlParameter("@refund_bank_name", MySqlDbType.VarChar, 200), new MySqlParameter("@refund_bank_account", MySqlDbType.VarChar, 200), new MySqlParameter("@pay_method", MySqlDbType.VarChar, 100), new MySqlParameter("@pay_method_name", MySqlDbType.VarChar, 200), new MySqlParameter("@pay_id", MySqlDbType.Int32, 11), new MySqlParameter("@pay_code", MySqlDbType.VarChar, 20), new MySqlParameter("@pay_name", MySqlDbType.VarChar, 20), new MySqlParameter("@pay_date", MySqlDbType.DateTime), new MySqlParameter("@approvalOne_id", MySqlDbType.Int32, 11), new MySqlParameter("@approvalOne_code", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalOne_name", MySqlDbType.VarChar, 50), new MySqlParameter("@approvalOne_date", MySqlDbType.DateTime), new MySqlParameter("@approvalTwo_id", MySqlDbType.Int32, 11), new MySqlParameter("@approvalTwo_code", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalTwo_name", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalTwo_date", MySqlDbType.DateTime), new MySqlParameter("@approvalThree_id", MySqlDbType.Int32, 11), new MySqlParameter("@approvalThree_code", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalThree_name", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalThree_date", MySqlDbType.DateTime), new MySqlParameter("@approvalFour_id", MySqlDbType.Int32, 11), new MySqlParameter("@approvalFour_code", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalFour_name", MySqlDbType.VarChar, 20), new MySqlParameter("@approvalFour_date", MySqlDbType.DateTime), new MySqlParameter("@is_del", MySqlDbType.Int16, 2), new MySqlParameter("@kingdee_current_account", MySqlDbType.VarChar, 100), new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2), new MySqlParameter("@kingdee_in_code", MySqlDbType.VarChar, 32), new MySqlParameter("@kingdee_out_code", MySqlDbType.VarChar, 32), new MySqlParameter("@print_num", MySqlDbType.Int32, 11) }; parameters[0].Value = model.refund_id; parameters[1].Value = model.refund_sn; parameters[2].Value = model.refund_type; parameters[3].Value = model.refund_status; parameters[4].Value = model.emp_id; parameters[5].Value = model.emp_code; parameters[6].Value = model.emp_name; parameters[7].Value = model.apply_date; parameters[8].Value = model.user_id; parameters[9].Value = model.customer_id; parameters[10].Value = model.customer_name; parameters[11].Value = model.refund_money; parameters[12].Value = model.refund_capital_money; parameters[13].Value = model.refund_remark; parameters[14].Value = model.refund_bank_name; parameters[15].Value = model.refund_bank_account; parameters[16].Value = model.pay_method; parameters[17].Value = model.pay_method_name; parameters[18].Value = model.pay_id; parameters[19].Value = model.pay_code; parameters[20].Value = model.pay_name; parameters[21].Value = model.pay_date; parameters[22].Value = model.approvalOne_id; parameters[23].Value = model.approvalOne_code; parameters[24].Value = model.approvalOne_name; parameters[25].Value = model.approvalOne_date; parameters[26].Value = model.approvalTwo_id; parameters[27].Value = model.approvalTwo_code; parameters[28].Value = model.approvalTwo_name; parameters[29].Value = model.approvalTwo_date; parameters[30].Value = model.approvalThree_id; parameters[31].Value = model.approvalThree_code; parameters[32].Value = model.approvalThree_name; parameters[33].Value = model.approvalThree_date; parameters[34].Value = model.approvalFour_id; parameters[35].Value = model.approvalFour_code; parameters[36].Value = model.approvalFour_name; parameters[37].Value = model.approvalFour_date; parameters[38].Value = model.is_del; parameters[39].Value = model.kingdee_current_account; parameters[40].Value = model.is_send_out; parameters[41].Value = model.kingdee_in_code; parameters[42].Value = model.kingdee_out_code; parameters[43].Value = model.print_num; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(FMS_DbHelperMySQL.GetMaxID("Id", "fms_supply_bank")); }
/// <summary> /// 审核 /// </summary> public bool updateStatus(FMS_Model.fms_refund_bill model, string idList) { List <string> strSqlList = new List <string>(); string strSql = string.Empty; DataSet ds = GetList(" refund_id in (" + idList + ")"); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { switch (model.refund_status.ToString()) { case "1": case "2": strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',approvalOne_id='{1}',approvalOne_code='{2}',approvalOne_name='{3}',approvalOne_date='{4}' where refund_id='{5}'", model.refund_status, model.approvalOne_id, model.approvalOne_code, model.approvalOne_name, model.approvalOne_date, Convert.ToInt32(ds.Tables[0].Rows[i]["refund_id"].ToString())); strSqlList.Add(strSql); break; case "3": case "4": strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',approvalTwo_id='{1}',approvalTwo_code='{2}',approvalTwo_name='{3}',approvalTwo_date='{4}' where refund_id='{5}'", model.refund_status, model.approvalTwo_id, model.approvalTwo_code, model.approvalTwo_name, model.approvalTwo_date, Convert.ToInt32(ds.Tables[0].Rows[i]["refund_id"].ToString())); strSqlList.Add(strSql); break; case "5": //判断是三级审核还是四级审核 0:三级审核;1:四级审核 int state = model.refund_status; if (ds.Tables[0].Rows[i]["refund_type"].ToString() == "0") { state = 9; } strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',approvalThree_id='{1}',approvalThree_code='{2}',approvalThree_name='{3}',approvalThree_date='{4}' where refund_id='{5}'", state, model.approvalThree_id, model.approvalThree_code, model.approvalThree_name, model.approvalThree_date, Convert.ToInt32(ds.Tables[0].Rows[i]["refund_id"].ToString())); strSqlList.Add(strSql); break; case "6": strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',approvalThree_id='{1}',approvalThree_code='{2}',approvalThree_name='{3}',approvalThree_date='{4}' where refund_id='{5}'", model.refund_status, model.approvalThree_id, model.approvalThree_code, model.approvalThree_name, model.approvalThree_date, Convert.ToInt32(ds.Tables[0].Rows[i]["refund_id"].ToString())); strSqlList.Add(strSql); break; case "8": case "9": strSql = string.Format(@" update fms_refund_bill set refund_status='{0}',approvalFour_id='{1}',approvalFour_code='{2}',approvalFour_name='{3}',approvalFour_date='{4}' where refund_id='{5}'", model.refund_status, model.approvalFour_id, model.approvalFour_code, model.approvalFour_name, model.approvalFour_date, Convert.ToInt32(ds.Tables[0].Rows[i]["refund_id"].ToString())); strSqlList.Add(strSql); break; default: break; } } } int rows = FMS_DbHelperMySQL.ExecuteSqlTran(strSqlList); if (rows >= 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(FMS_DbHelperMySQL.GetMaxID("refund_id", "fms_refund_bill")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.fms_refund_bill model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fms_refund_bill set "); strSql.Append("refund_sn=@refund_sn,"); strSql.Append("refund_type=@refund_type,"); strSql.Append("refund_status=@refund_status,"); strSql.Append("user_id=@user_id,"); strSql.Append("customer_id=@customer_id,"); strSql.Append("customer_name=@customer_name,"); strSql.Append("refund_money=@refund_money,"); strSql.Append("refund_capital_money=@refund_capital_money,"); strSql.Append("refund_remark=@refund_remark,"); strSql.Append("refund_bank_name=@refund_bank_name,"); strSql.Append("refund_bank_account=@refund_bank_account,"); strSql.Append("pay_method=@pay_method,"); strSql.Append("pay_method_name=@pay_method_name,"); strSql.Append("is_send_out=@is_send_out "); strSql.Append(" where refund_id=@refund_id "); MySqlParameter[] parameters = { new MySqlParameter("@refund_sn", MySqlDbType.VarChar, 20), new MySqlParameter("@refund_type", MySqlDbType.Int16, 2), new MySqlParameter("@refund_status", MySqlDbType.Int16, 2), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@customer_id", MySqlDbType.Int32, 11), new MySqlParameter("@customer_name", MySqlDbType.VarChar, 250), new MySqlParameter("@refund_money", MySqlDbType.Decimal, 12), new MySqlParameter("@refund_capital_money", MySqlDbType.VarChar, 200), new MySqlParameter("@refund_remark", MySqlDbType.VarChar, 500), new MySqlParameter("@refund_bank_name", MySqlDbType.VarChar, 200), new MySqlParameter("@refund_bank_account", MySqlDbType.VarChar, 200), new MySqlParameter("@pay_method", MySqlDbType.VarChar, 100), new MySqlParameter("@pay_method_name", MySqlDbType.VarChar, 200), new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2), new MySqlParameter("@refund_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.refund_sn; parameters[1].Value = model.refund_type; parameters[2].Value = model.refund_status; parameters[3].Value = model.user_id; parameters[4].Value = model.customer_id; parameters[5].Value = model.customer_name; parameters[6].Value = model.refund_money; parameters[7].Value = model.refund_capital_money; parameters[8].Value = model.refund_remark; parameters[9].Value = model.refund_bank_name; parameters[10].Value = model.refund_bank_account; parameters[11].Value = model.pay_method; parameters[12].Value = model.pay_method_name; parameters[13].Value = model.is_send_out; parameters[14].Value = model.refund_id; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(FMS_DbHelperMySQL.GetMaxID("id", "fms_costitem")); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_Model.fms_bank_list_excel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fms_bank_list_excel("); strSql.Append("id,collection_bank_id,collection_bank_code,collection_bank_name,collection_account,dk_time,dk_time_only,dk_money,dk_account,dk_username,dk_bank_name,dk_channel,dk_message_remarks,start_line,excel_exist_collection_account,sort,excel_type,is_use,is_show_full,acc_type,is_collect,is_send_out)"); strSql.Append(" values ("); strSql.Append("@id,@collection_bank_id,@collection_bank_code,@collection_bank_name,@collection_account,@dk_time,@dk_time_only,@dk_money,@dk_account,@dk_username,@dk_bank_name,@dk_channel,@dk_message_remarks,@start_line,@excel_exist_collection_account,@sort,@excel_type,@is_use,@is_show_full,@acc_type,@is_collect,@is_send_out)"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@collection_bank_id", MySqlDbType.Int16, 5), new MySqlParameter("@collection_bank_code", MySqlDbType.VarChar, 20), new MySqlParameter("@collection_bank_name", MySqlDbType.VarChar, 50), new MySqlParameter("@collection_account", MySqlDbType.VarChar, 255), new MySqlParameter("@dk_time", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_time_only", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_money", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_account", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_username", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_bank_name", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_channel", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_message_remarks", MySqlDbType.VarChar, 6), new MySqlParameter("@start_line", MySqlDbType.Int16, 5), new MySqlParameter("@excel_exist_collection_account", MySqlDbType.Int16, 2), new MySqlParameter("@sort", MySqlDbType.Int32, 3), new MySqlParameter("@excel_type", MySqlDbType.VarChar, 10), new MySqlParameter("@is_use", MySqlDbType.Int16, 2), new MySqlParameter("@is_show_full", MySqlDbType.Int16, 2), new MySqlParameter("@acc_type", MySqlDbType.Int16, 2), new MySqlParameter("@is_collect", MySqlDbType.Int16, 2), new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2) }; parameters[0].Value = model.id; parameters[1].Value = model.collection_bank_id; parameters[2].Value = model.collection_bank_code; parameters[3].Value = model.collection_bank_name; parameters[4].Value = model.collection_account; parameters[5].Value = model.dk_time; parameters[6].Value = model.dk_time_only; parameters[7].Value = model.dk_money; parameters[8].Value = model.dk_account; parameters[9].Value = model.dk_username; parameters[10].Value = model.dk_bank_name; parameters[11].Value = model.dk_channel; parameters[12].Value = model.dk_message_remarks; parameters[13].Value = model.start_line; parameters[14].Value = model.excel_exist_collection_account; parameters[15].Value = model.sort; parameters[16].Value = model.excel_type; parameters[17].Value = model.is_use; parameters[18].Value = model.is_show_full; parameters[19].Value = model.acc_type; parameters[20].Value = model.is_collect; parameters[21].Value = model.is_send_out; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到最大ID /// </summary> public int GetMaxId() { return(FMS_DbHelperMySQL.GetMaxID("id", "fms_bank_list_excel")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.fms_bank_list_excel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fms_bank_list_excel set "); strSql.Append("collection_bank_id=@collection_bank_id,"); strSql.Append("collection_bank_code=@collection_bank_code,"); strSql.Append("collection_bank_name=@collection_bank_name,"); strSql.Append("collection_account=@collection_account,"); strSql.Append("dk_time=@dk_time,"); strSql.Append("dk_time_only=@dk_time_only,"); strSql.Append("dk_money=@dk_money,"); strSql.Append("dk_account=@dk_account,"); strSql.Append("dk_username=@dk_username,"); strSql.Append("dk_bank_name=@dk_bank_name,"); strSql.Append("dk_channel=@dk_channel,"); strSql.Append("dk_message_remarks=@dk_message_remarks,"); strSql.Append("start_line=@start_line,"); strSql.Append("excel_exist_collection_account=@excel_exist_collection_account,"); strSql.Append("sort=@sort,"); strSql.Append("excel_type=@excel_type,"); strSql.Append("is_use=@is_use,"); strSql.Append("is_show_full=@is_show_full,"); strSql.Append("acc_type=@acc_type,"); strSql.Append("is_collect=@is_collect,"); strSql.Append("is_send_out=@is_send_out"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@collection_bank_id", MySqlDbType.Int16, 5), new MySqlParameter("@collection_bank_code", MySqlDbType.VarChar, 20), new MySqlParameter("@collection_bank_name", MySqlDbType.VarChar, 50), new MySqlParameter("@collection_account", MySqlDbType.VarChar, 255), new MySqlParameter("@dk_time", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_time_only", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_money", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_account", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_username", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_bank_name", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_channel", MySqlDbType.VarChar, 6), new MySqlParameter("@dk_message_remarks", MySqlDbType.VarChar, 6), new MySqlParameter("@start_line", MySqlDbType.Int16, 5), new MySqlParameter("@excel_exist_collection_account", MySqlDbType.Int16, 2), new MySqlParameter("@sort", MySqlDbType.Int32, 3), new MySqlParameter("@excel_type", MySqlDbType.VarChar, 10), new MySqlParameter("@is_use", MySqlDbType.Int16, 2), new MySqlParameter("@is_show_full", MySqlDbType.Int16, 2), new MySqlParameter("@acc_type", MySqlDbType.Int16, 2), new MySqlParameter("@is_collect", MySqlDbType.Int16, 2), new MySqlParameter("@is_send_out", MySqlDbType.Int16, 2), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.collection_bank_id; parameters[1].Value = model.collection_bank_code; parameters[2].Value = model.collection_bank_name; parameters[3].Value = model.collection_account; parameters[4].Value = model.dk_time; parameters[5].Value = model.dk_time_only; parameters[6].Value = model.dk_money; parameters[7].Value = model.dk_account; parameters[8].Value = model.dk_username; parameters[9].Value = model.dk_bank_name; parameters[10].Value = model.dk_channel; parameters[11].Value = model.dk_message_remarks; parameters[12].Value = model.start_line; parameters[13].Value = model.excel_exist_collection_account; parameters[14].Value = model.sort; parameters[15].Value = model.excel_type; parameters[16].Value = model.is_use; parameters[17].Value = model.is_show_full; parameters[18].Value = model.acc_type; parameters[19].Value = model.is_collect; parameters[20].Value = model.is_send_out; parameters[21].Value = model.id; int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }