/// <summary>
///[To_OrderCollectDetial]表修改的方法
/// </summary>
public static int updateTo_OrderCollectDetialById(To_OrderCollectDetial to_ordercollectdetial)
{
string sql = "update To_OrderCollectDetial set orderid=@orderid,cusid=@cusid,cusName=@cusName,salesman=@salesman,salemanid=@salemanid,adultNum=@adultNum,childNum=@childNum,withNum=@withNum,money=@money,collectStatus=@collectStatus,collectAmount=@collectAmount,remark=@remark,linkid=@linkid,linkname=@linkname,departName=@departName where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", to_ordercollectdetial.Id),
new SqlParameter("@orderid", to_ordercollectdetial.Orderid),
new SqlParameter("@cusid", to_ordercollectdetial.CustId),
new SqlParameter("@cusName", to_ordercollectdetial.CusName),
new SqlParameter("@salesman", to_ordercollectdetial.Salesman),
new SqlParameter("@salemanid", to_ordercollectdetial.Salemanid),
new SqlParameter("@adultNum", to_ordercollectdetial.AdultNum),
new SqlParameter("@childNum", to_ordercollectdetial.ChildNum),
new SqlParameter("@withNum", to_ordercollectdetial.WithNum),
new SqlParameter("@money", to_ordercollectdetial.Money),
new SqlParameter("@collectStatus", to_ordercollectdetial.CollectStatus),
new SqlParameter("@collectAmount", to_ordercollectdetial.CollectAmount),
new SqlParameter("@remark", to_ordercollectdetial.Remark),
new SqlParameter("@linkid", to_ordercollectdetial.LinkID),
new SqlParameter("@linkname", to_ordercollectdetial.LinkName),
new SqlParameter("@departName", to_ordercollectdetial.DepartName)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static To_OrderCollectDetial getTo_OrderCollectDetialBySql(string sql)
{
To_OrderCollectDetial to_ordercollectdetial = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
to_ordercollectdetial = new To_OrderCollectDetial();
foreach (DataRow dr in dt.Rows)
{
to_ordercollectdetial.Id = Convert.ToInt32(dr["id"]);
to_ordercollectdetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_ordercollectdetial.CustId = Convert.ToInt32(dr["cusid"]);
to_ordercollectdetial.CusName = Convert.ToString(dr["cusName"]);
to_ordercollectdetial.Salesman = Convert.ToString(dr["salesman"]);
to_ordercollectdetial.Salemanid = Convert.ToInt32(dr["salemanid"]);
to_ordercollectdetial.AdultNum = Convert.ToInt32(dr["adultNum"]);
to_ordercollectdetial.ChildNum = Convert.ToInt32(dr["childNum"]);
to_ordercollectdetial.WithNum = Convert.ToInt32(dr["withNum"]);
to_ordercollectdetial.Money = Convert.ToDouble(dr["money"]);
to_ordercollectdetial.CollectStatus = Convert.ToString(dr["collectStatus"]);
to_ordercollectdetial.CollectAmount = Convert.ToDouble(dr["collectAmount"]);
to_ordercollectdetial.Remark = Convert.ToString(dr["remark"]);
to_ordercollectdetial.LinkID = Convert.ToInt32(dr["linkid"]);
to_ordercollectdetial.LinkName = Convert.ToString(dr["linkname"]);
to_ordercollectdetial.DepartName = Convert.ToString(dr["departName"]);
}
}
return(to_ordercollectdetial);
}
/// <summary>
///[To_OrderCollectDetial]表查询实体的方法
/// </summary>
public static To_OrderCollectDetial getTo_OrderCollectDetialById(int id)
{
To_OrderCollectDetial to_ordercollectdetial = null;
string sql = "select * from To_OrderCollectDetial where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
to_ordercollectdetial = new To_OrderCollectDetial();
foreach (DataRow dr in dt.Rows)
{
to_ordercollectdetial.Id = Convert.ToInt32(dr["id"]);
to_ordercollectdetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_ordercollectdetial.CustId = Convert.ToInt32(dr["cusid"]);
to_ordercollectdetial.CusName = Convert.ToString(dr["cusName"]);
to_ordercollectdetial.Salesman = Convert.ToString(dr["salesman"]);
to_ordercollectdetial.Salemanid = Convert.ToInt32(dr["salemanid"]);
to_ordercollectdetial.AdultNum = Convert.ToInt32(dr["adultNum"]);
to_ordercollectdetial.ChildNum = Convert.ToInt32(dr["childNum"]);
to_ordercollectdetial.WithNum = Convert.ToInt32(dr["withNum"]);
to_ordercollectdetial.Money = Convert.IsDBNull(dr["money"]) ? 0.0 : Convert.ToDouble(dr["money"]);
to_ordercollectdetial.CollectStatus = Convert.ToString(dr["collectStatus"]);
to_ordercollectdetial.CollectAmount = Convert.IsDBNull(dr["collectAmount"]) ? 0.0 : Convert.ToDouble(dr["collectAmount"]);
to_ordercollectdetial.Remark = Convert.ToString(dr["remark"]);
to_ordercollectdetial.LinkID = Convert.IsDBNull(dr["linkid"]) ? 0 : Convert.ToInt32(dr["linkid"]);
to_ordercollectdetial.LinkName = Convert.ToString(dr["linkname"]);
to_ordercollectdetial.DepartName = Convert.ToString(dr["departName"]);
}
}
return(to_ordercollectdetial);
}
/// <summary>
///[To_OrderCollectDetial]表添加的方法
/// </summary>
public static int addTo_OrderCollectDetial(To_OrderCollectDetial to_ordercollectdetial)
{
string sql = "insert into To_OrderCollectDetial([orderid],[cusid],[cusName],[salesman],[salemanid],[adultNum],[childNum],[withNum],[money],[collectStatus],[collectAmount],[remark],[linkid],[linkname],[departName]) values (@orderid,@cusid,@cusName,@salesman,@salemanid,@adultNum,@childNum,@withNum,@money,@collectStatus,@collectAmount,@remark,@linkid,@linkname,@departName)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@orderid", to_ordercollectdetial.Orderid),
new SqlParameter("@cusid", to_ordercollectdetial.CustId),
new SqlParameter("@cusName", to_ordercollectdetial.CusName),
new SqlParameter("@salesman", to_ordercollectdetial.Salesman),
new SqlParameter("@salemanid", to_ordercollectdetial.Salemanid),
new SqlParameter("@adultNum", to_ordercollectdetial.AdultNum),
new SqlParameter("@childNum", to_ordercollectdetial.ChildNum),
new SqlParameter("@withNum", to_ordercollectdetial.WithNum),
new SqlParameter("@money", to_ordercollectdetial.Money),
new SqlParameter("@collectStatus", to_ordercollectdetial.CollectStatus),
new SqlParameter("@collectAmount", to_ordercollectdetial.CollectAmount),
new SqlParameter("@remark", to_ordercollectdetial.Remark),
new SqlParameter("@linkid", to_ordercollectdetial.LinkID),
new SqlParameter("@linkname", to_ordercollectdetial.LinkName),
new SqlParameter("@departName", to_ordercollectdetial.DepartName)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
public static int addTo_OrderCollectDetial(To_OrderCollectDetial to_ordercollectdetial)
{
return(To_OrderCollectDetialService.addTo_OrderCollectDetial(to_ordercollectdetial));
}
public static int updateTo_OrderCollectDetial(To_OrderCollectDetial to_ordercollectdetial)
{
return(To_OrderCollectDetialService.updateTo_OrderCollectDetialById(to_ordercollectdetial));
}
