/// <summary> /// 得到一个对象实体 /// </summary> public kyfly.Model.yewu_tuifeilipeiGJB GetModel(int Id) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select * from 业务_退费理赔改价表 "); strSql.Append(" where Id=@Id LIMIT 1"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySql.Data.MySqlClient.MySqlDbType.Int16, 11) }; parameters[0].Value = Id; kyfly.Model.yewu_tuifeilipeiGJB model = new kyfly.Model.yewu_tuifeilipeiGJB(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(kyfly.Model.yewu_tuifeilipeiGJB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 业务_退费理赔改价表("); strSql.Append("姓名,收件人手机号,OpenId,地址,状态,配送人手机号,配送时间,审核人手机号,审核结果,金额,退款金额,类别,订单表Id,支付单号,微信订单号,退款单号,备注) values ("); strSql.Append("@姓名,@收件人手机号,@OpenId,@地址,@状态,@配送人手机号,@配送时间,@审核人手机号,@审核结果,@金额,@退款金额,@类别,@订单表Id,@支付单号,@微信订单号,@退款单号,@备注)"); strSql.Append(";"); MySqlParameter[] parameters = { new MySqlParameter("@姓名", MySqlDbType.VarChar, 30), new MySqlParameter("@收件人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@OpenId", MySqlDbType.VarChar, 30), new MySqlParameter("@地址", MySqlDbType.VarChar, 100), new MySqlParameter("@状态", MySqlDbType.VarChar, 20), new MySqlParameter("@配送人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@配送时间", MySqlDbType.DateTime), new MySqlParameter("@审核人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@审核结果", MySqlDbType.VarChar, 20), new MySqlParameter("@金额", MySqlDbType.Double, 0), new MySqlParameter("@退款金额", MySqlDbType.Double, 0), new MySqlParameter("@类别", MySqlDbType.VarChar, 20), new MySqlParameter("@订单表Id", MySqlDbType.Int32, 11), new MySqlParameter("@支付单号", MySqlDbType.VarChar, 30), new MySqlParameter("@微信订单号", MySqlDbType.VarChar, 50), new MySqlParameter("@退款单号", MySqlDbType.VarChar, 50), new MySqlParameter("@备注", MySqlDbType.VarChar, 30) }; parameters[0].Value = model.姓名; parameters[1].Value = model.收件人手机号; parameters[2].Value = model.OpenId; parameters[3].Value = model.地址; parameters[4].Value = model.状态; parameters[5].Value = model.配送人手机号; parameters[6].Value = model.配送时间; parameters[7].Value = model.审核人手机号; parameters[8].Value = model.审核结果; parameters[9].Value = model.金额; parameters[10].Value = model.退款金额; parameters[11].Value = model.类别; parameters[12].Value = model.订单表Id; parameters[13].Value = model.支付单号; parameters[14].Value = model.微信订单号; parameters[15].Value = model.退款单号; parameters[16].Value = model.备注; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(rows); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(kyfly.Model.yewu_tuifeilipeiGJB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 业务_退费理赔改价表 set "); strSql.Append("姓名=@姓名,"); strSql.Append("收件人手机号=@收件人手机号,"); strSql.Append("OpenId=@OpenId,"); strSql.Append("地址=@地址,"); strSql.Append("状态=@状态,"); strSql.Append("配送人手机号=@配送人手机号,"); strSql.Append("配送时间=@配送时间,"); strSql.Append("审核人手机号=@审核人手机号,"); strSql.Append("审核结果=@审核结果,"); strSql.Append("金额=@金额,"); strSql.Append("退款金额=@退款金额,"); strSql.Append("类别=@类别,"); strSql.Append("订单表Id=@订单表Id,"); strSql.Append("支付单号=@支付单号,"); strSql.Append("微信订单号=@微信订单号,"); strSql.Append("退款单号=@退款单号,"); strSql.Append("备注=@备注"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@姓名", MySqlDbType.VarChar, 30), new MySqlParameter("@收件人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@OpenId", MySqlDbType.VarChar, 30), new MySqlParameter("@地址", MySqlDbType.VarChar, 100), new MySqlParameter("@状态", MySqlDbType.VarChar, 20), new MySqlParameter("@配送人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@配送时间", MySqlDbType.DateTime), new MySqlParameter("@审核人手机号", MySqlDbType.VarChar, 11), new MySqlParameter("@审核结果", MySqlDbType.VarChar, 20), new MySqlParameter("@金额", MySqlDbType.Double, 0), new MySqlParameter("@退款金额", MySqlDbType.Double, 0), new MySqlParameter("@类别", MySqlDbType.VarChar, 20), new MySqlParameter("@订单表Id", MySqlDbType.Int32, 11), new MySqlParameter("@支付单号", MySqlDbType.VarChar, 30), new MySqlParameter("@微信订单号", MySqlDbType.VarChar, 50), new MySqlParameter("@退款单号", MySqlDbType.VarChar, 50), new MySqlParameter("@备注", MySqlDbType.VarChar, 30), new MySqlParameter("@Id", MySqlDbType.Int16, 6) }; parameters[0].Value = model.姓名; parameters[1].Value = model.收件人手机号; parameters[2].Value = model.OpenId; parameters[3].Value = model.地址; parameters[4].Value = model.状态; parameters[5].Value = model.配送人手机号; parameters[6].Value = model.配送时间; parameters[7].Value = model.审核人手机号; parameters[8].Value = model.审核结果; parameters[9].Value = model.金额; parameters[10].Value = model.退款金额; parameters[11].Value = model.类别; parameters[12].Value = model.订单表Id; parameters[13].Value = model.支付单号; parameters[14].Value = model.微信订单号; parameters[15].Value = model.退款单号; parameters[16].Value = model.备注; parameters[17].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public kyfly.Model.yewu_tuifeilipeiGJB DataRowToModel(DataRow row) { kyfly.Model.yewu_tuifeilipeiGJB model = new kyfly.Model.yewu_tuifeilipeiGJB(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["姓名"] != null) { model.姓名 = row["姓名"].ToString(); } if (row["收件人手机号"] != null) { model.收件人手机号 = row["收件人手机号"].ToString(); } if (row["OpenId"] != null) { model.OpenId = row["OpenId"].ToString(); } if (row["地址"] != null) { model.地址 = row["地址"].ToString(); } if (row["状态"] != null) { model.状态 = row["状态"].ToString(); } if (row["配送人手机号"] != null) { model.配送人手机号 = row["配送人手机号"].ToString(); } if (row["配送时间"] != null && row["配送时间"].ToString() != "") { model.配送时间 = DateTime.Parse(row["配送时间"].ToString()); } if (row["审核人手机号"] != null) { model.审核人手机号 = row["审核人手机号"].ToString(); } if (row["审核结果"] != null) { model.审核结果 = row["审核结果"].ToString(); } if (row["金额"] != null) { model.金额 = row["金额"].ToString(); } if (row["退款金额"] != null) { model.退款金额 = row["退款金额"].ToString(); } if (row["类别"] != null) { model.类别 = row["类别"].ToString(); } if (row["订单表Id"] != null && row["订单表Id"].ToString() != "") { model.订单表Id = int.Parse(row["订单表Id"].ToString()); } if (row["支付单号"] != null) { model.支付单号 = row["支付单号"].ToString(); } if (row["微信订单号"] != null) { model.微信订单号 = row["微信订单号"].ToString(); } if (row["退款单号"] != null) { model.退款单号 = row["退款单号"].ToString(); } if (row["备注"] != null) { model.备注 = row["备注"].ToString(); } } return(model); }