public int EditLineGroupDate(B2b_com_LineGroupDate model)
{
using (var helper = new SqlHelper())
{
var list = new InternalB2b_com_LineGroupDate(helper).EditLineGroupDate(model);
return(list);
}
}
internal B2b_com_LineGroupDate GetLineDayGroupDate(DateTime daydate, int lineid)
{
string sql = @"SELECT *
FROM [B2b_com_LineGroupDate] where lineid=@lineid and daydate=@daydate";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@lineid", lineid);
cmd.AddParam("@daydate", daydate);
B2b_com_LineGroupDate u = null;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
u = new B2b_com_LineGroupDate
{
Id = reader.GetValue <int>("id"),
Menprice = reader.GetValue <decimal>("menprice"),
Childprice = reader.GetValue <decimal>("childprice"),
Oldmenprice = reader.GetValue <decimal>("oldmenprice"),
Emptynum = reader.GetValue <int>("emptynum"),
Daydate = reader.GetValue <DateTime>("daydate"),
Lineid = reader.GetValue <int>("lineid"),
agent1_back = reader.GetValue <decimal>("agent1_back"),
agent2_back = reader.GetValue <decimal>("agent2_back"),
agent3_back = reader.GetValue <decimal>("agent3_back"),
};
}
}
if (u != null)
{
//支付成功人数
u.paysucnum = new B2bOrderData().GetPaySucNumByProid(lineid, 0, (int)PayStatus.HasPay, daydate, 0, "2,4,8,22");
//待支付人数
u.waitpaynum = new B2bOrderData().GetPaySucNumByProid(lineid, 0, (int)PayStatus.NotPay, daydate, 0, "1");
return(u);
}
else
{
return(null);
}
}
internal int EditLineGroupDate(B2b_com_LineGroupDate model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand("usp_InsertOrUpdateB2bcomLineGroupDate");
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@Menprice", model.Menprice);
cmd.AddParam("@Childprice", model.Childprice);
cmd.AddParam("@Oldmenprice", model.Oldmenprice);
cmd.AddParam("@Lineid", model.Lineid);
cmd.AddParam("@Emptynum", model.Emptynum);
cmd.AddParam("@Daydate", model.Daydate);
cmd.AddParam("@agent1_back", model.agent1_back);
cmd.AddParam("@agent2_back", model.agent2_back);
cmd.AddParam("@agent3_back", model.agent3_back);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}
