/// <summary>
/// 得到一个对象实体
/// </summary>
public M_ShippingInfo GetM_ShippingInfoModel(int m_ShippingInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 m_ShippingInfoID,m_TradeInfoID,tid,seller_nick,buyer_nick,delivery_start,delivery_end,out_sid,item_title,receiver_name,receiver_phone,receiver_mobile,status,type,freight_payer,seller_confirm,company_name,is_success,created,modified from tb_M_ShippingInfo ");
strSql.Append(" where m_ShippingInfoID=@m_ShippingInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@m_ShippingInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = m_ShippingInfoID;
M_ShippingInfo model = new M_ShippingInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["m_ShippingInfoID"].ToString() != "")
{
model.m_ShippingInfoID = int.Parse(ds.Tables[0].Rows[0]["m_ShippingInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["m_TradeInfoID"].ToString() != "")
{
model.m_TradeInfoID = int.Parse(ds.Tables[0].Rows[0]["m_TradeInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["tid"].ToString() != "")
{
model.tid = long.Parse(ds.Tables[0].Rows[0]["tid"].ToString());
}
model.seller_nick = ds.Tables[0].Rows[0]["seller_nick"].ToString();
model.buyer_nick = ds.Tables[0].Rows[0]["buyer_nick"].ToString();
if (ds.Tables[0].Rows[0]["delivery_start"].ToString() != "")
{
model.delivery_start = DateTime.Parse(ds.Tables[0].Rows[0]["delivery_start"].ToString());
}
if (ds.Tables[0].Rows[0]["delivery_end"].ToString() != "")
{
model.delivery_end = DateTime.Parse(ds.Tables[0].Rows[0]["delivery_end"].ToString());
}
model.out_sid = ds.Tables[0].Rows[0]["out_sid"].ToString();
model.item_title = ds.Tables[0].Rows[0]["item_title"].ToString();
model.receiver_name = ds.Tables[0].Rows[0]["receiver_name"].ToString();
model.receiver_phone = ds.Tables[0].Rows[0]["receiver_phone"].ToString();
model.receiver_mobile = ds.Tables[0].Rows[0]["receiver_mobile"].ToString();
model.status = ds.Tables[0].Rows[0]["status"].ToString();
model.type = ds.Tables[0].Rows[0]["type"].ToString();
model.freight_payer = ds.Tables[0].Rows[0]["freight_payer"].ToString();
model.seller_confirm = ds.Tables[0].Rows[0]["seller_confirm"].ToString();
model.company_name = ds.Tables[0].Rows[0]["company_name"].ToString();
if (ds.Tables[0].Rows[0]["is_success"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_success"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_success"].ToString().ToLower() == "true"))
{
model.is_success = true;
}
else
{
model.is_success = false;
}
}
if (ds.Tables[0].Rows[0]["created"].ToString() != "")
{
model.created = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString());
}
if (ds.Tables[0].Rows[0]["modified"].ToString() != "")
{
model.modified = DateTime.Parse(ds.Tables[0].Rows[0]["modified"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddM_ShippingInfo(M_ShippingInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_M_ShippingInfo(");
strSql.Append("m_TradeInfoID,tid,seller_nick,buyer_nick,delivery_start,delivery_end,out_sid,item_title,receiver_name,receiver_phone,receiver_mobile,status,type,freight_payer,seller_confirm,company_name,is_success,created,modified)");
strSql.Append(" values (");
strSql.Append("@m_TradeInfoID,@tid,@seller_nick,@buyer_nick,@delivery_start,@delivery_end,@out_sid,@item_title,@receiver_name,@receiver_phone,@receiver_mobile,@status,@type,@freight_payer,@seller_confirm,@company_name,@is_success,@created,@modified)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@m_TradeInfoID", SqlDbType.Int, 4),
new SqlParameter("@tid", SqlDbType.BigInt, 8),
new SqlParameter("@seller_nick", SqlDbType.VarChar, 50),
new SqlParameter("@buyer_nick", SqlDbType.VarChar, 50),
new SqlParameter("@delivery_start", SqlDbType.DateTime),
new SqlParameter("@delivery_end", SqlDbType.DateTime),
new SqlParameter("@out_sid", SqlDbType.VarChar, 50),
new SqlParameter("@item_title", SqlDbType.VarChar, 128),
new SqlParameter("@receiver_name", SqlDbType.VarChar, 50),
new SqlParameter("@receiver_phone", SqlDbType.VarChar, 50),
new SqlParameter("@receiver_mobile", SqlDbType.VarChar, 50),
new SqlParameter("@status", SqlDbType.VarChar, 50),
new SqlParameter("@type", SqlDbType.VarChar, 50),
new SqlParameter("@freight_payer", SqlDbType.VarChar, 50),
new SqlParameter("@seller_confirm", SqlDbType.VarChar, 10),
new SqlParameter("@company_name", SqlDbType.VarChar, 128),
new SqlParameter("@is_success", SqlDbType.Bit, 1),
new SqlParameter("@created", SqlDbType.DateTime),
new SqlParameter("@modified", SqlDbType.DateTime)
};
parameters[0].Value = model.m_TradeInfoID;
parameters[1].Value = model.tid;
parameters[2].Value = model.seller_nick;
parameters[3].Value = model.buyer_nick;
parameters[4].Value = model.delivery_start;
parameters[5].Value = model.delivery_end;
parameters[6].Value = model.out_sid;
parameters[7].Value = model.item_title;
parameters[8].Value = model.receiver_name;
parameters[9].Value = model.receiver_phone;
parameters[10].Value = model.receiver_mobile;
parameters[11].Value = model.status;
parameters[12].Value = model.type;
parameters[13].Value = model.freight_payer;
parameters[14].Value = model.seller_confirm;
parameters[15].Value = model.company_name;
parameters[16].Value = model.is_success;
parameters[17].Value = model.created;
parameters[18].Value = model.modified;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateM_ShippingInfo(M_ShippingInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_M_ShippingInfo set ");
strSql.Append("m_TradeInfoID=@m_TradeInfoID,");
strSql.Append("tid=@tid,");
strSql.Append("seller_nick=@seller_nick,");
strSql.Append("buyer_nick=@buyer_nick,");
strSql.Append("delivery_start=@delivery_start,");
strSql.Append("delivery_end=@delivery_end,");
strSql.Append("out_sid=@out_sid,");
strSql.Append("item_title=@item_title,");
strSql.Append("receiver_name=@receiver_name,");
strSql.Append("receiver_phone=@receiver_phone,");
strSql.Append("receiver_mobile=@receiver_mobile,");
strSql.Append("status=@status,");
strSql.Append("type=@type,");
strSql.Append("freight_payer=@freight_payer,");
strSql.Append("seller_confirm=@seller_confirm,");
strSql.Append("company_name=@company_name,");
strSql.Append("is_success=@is_success,");
strSql.Append("created=@created,");
strSql.Append("modified=@modified");
strSql.Append(" where m_ShippingInfoID=@m_ShippingInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@m_ShippingInfoID", SqlDbType.Int, 4),
new SqlParameter("@m_TradeInfoID", SqlDbType.Int, 4),
new SqlParameter("@tid", SqlDbType.BigInt, 8),
new SqlParameter("@seller_nick", SqlDbType.VarChar, 50),
new SqlParameter("@buyer_nick", SqlDbType.VarChar, 50),
new SqlParameter("@delivery_start", SqlDbType.DateTime),
new SqlParameter("@delivery_end", SqlDbType.DateTime),
new SqlParameter("@out_sid", SqlDbType.VarChar, 50),
new SqlParameter("@item_title", SqlDbType.VarChar, 128),
new SqlParameter("@receiver_name", SqlDbType.VarChar, 50),
new SqlParameter("@receiver_phone", SqlDbType.VarChar, 50),
new SqlParameter("@receiver_mobile", SqlDbType.VarChar, 50),
new SqlParameter("@status", SqlDbType.VarChar, 50),
new SqlParameter("@type", SqlDbType.VarChar, 50),
new SqlParameter("@freight_payer", SqlDbType.VarChar, 50),
new SqlParameter("@seller_confirm", SqlDbType.VarChar, 10),
new SqlParameter("@company_name", SqlDbType.VarChar, 128),
new SqlParameter("@is_success", SqlDbType.Bit, 1),
new SqlParameter("@created", SqlDbType.DateTime),
new SqlParameter("@modified", SqlDbType.DateTime)
};
parameters[0].Value = model.m_ShippingInfoID;
parameters[1].Value = model.m_TradeInfoID;
parameters[2].Value = model.tid;
parameters[3].Value = model.seller_nick;
parameters[4].Value = model.buyer_nick;
parameters[5].Value = model.delivery_start;
parameters[6].Value = model.delivery_end;
parameters[7].Value = model.out_sid;
parameters[8].Value = model.item_title;
parameters[9].Value = model.receiver_name;
parameters[10].Value = model.receiver_phone;
parameters[11].Value = model.receiver_mobile;
parameters[12].Value = model.status;
parameters[13].Value = model.type;
parameters[14].Value = model.freight_payer;
parameters[15].Value = model.seller_confirm;
parameters[16].Value = model.company_name;
parameters[17].Value = model.is_success;
parameters[18].Value = model.created;
parameters[19].Value = model.modified;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString());
}
