/// <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);
}
