internal DataSet DayJSListByPosId(string pos_id)
{
//判断验码日志表中是否含有pos未验证的记录（有，向当日结算表中录入新纪录，同时更改验码日志表中jsid；没有，返回null）
var verifylogcount = DayJieSuanData.GetVerifyLogCount(pos_id);
if (verifylogcount > 0)
{
B2b_dayjiesuan newdayjs = new B2b_dayjiesuan
{
Id = 0,
Jstime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
Jsstartdate = new B2bEticketLogData().GetFrontNotJS() == null?DateTime.Parse("1900-01-01") : new B2bEticketLogData().GetFrontNotJS().Actiondate, //得到未开始结算的记录
Jsenddate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")),
Com_id = new B2bCompanyPosData().GetPosByPosId(pos_id).Id,
PosId = int.Parse(pos_id)
};
var JSid = new DayJieSuanData().InsertOrUpdate(newdayjs);
//更改此次结算的电子票发码日志表中的关联jsid（当前pos 验码 状态成功 js=0即未结算过的）
new B2bEticketLogData().ModifyJsidByPosId(JSid, pos_id);
const string sqltxt = @"SELECT
[eticket_id]
,COUNT(1) as TotalVerifyNum
,sum(use_pnum) as TotalConsumedNum
FROM [EtownDB].[dbo].[b2b_etcket_log] where jsid=@jsid group by eticket_id";
var cmd = this.sqlHelper.PrepareTextSqlCommand(sqltxt);
cmd.AddParam("@jsid", JSid);
using (var reader = cmd.ExecuteReader())
{
DataTable dt = new DataTable("dayjs");
DataColumn dc1 = dt.Columns.Add("proname");
DataColumn dc2 = dt.Columns.Add("TotalConsumedNum");
DataColumn dc3 = dt.Columns.Add("e_face_price");
DataColumn dc4 = dt.Columns.Add("TotalVerifyNum");//验票笔数
DataRow drr;
while (reader.Read())
{
drr = dt.NewRow();
drr["proname"] = new B2bEticketData().GetEticketByID(reader.GetValue <int>("eticket_id").ToString()).E_proname;
drr["TotalConsumedNum"] = reader.GetValue <int>("TotalConsumedNum");
drr["TotalVerifyNum"] = reader.GetValue <int>("TotalVerifyNum");
drr["e_face_price"] = new B2bEticketData().GetEticketByID(reader.GetValue <int>("eticket_id").ToString()).E_face_price.ToString("f2");
dt.Rows.Add(drr);
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
}
else
{
return(null);
}
}
//#region 获得当天的结算信息对象
//internal static B2b_dayjiesuan GetDateDayJS(string comid)
//{
// using (var helper = new SqlHelper())
// {
// var dayjs = new InternalDayJieSuan(helper).GetDateDayJS(comid);
// return dayjs;
// }
//}
//#endregion
#region 编辑当日结算信息
internal int InsertOrUpdate(B2b_dayjiesuan newdayjs)
{
using (var sql = new SqlHelper())
{
try
{
int result = new InternalDayJieSuan(sql).InsertOrUpdate(newdayjs);
return(result);
}
catch
{
throw;
}
}
}
internal int InsertOrUpdate(B2b_dayjiesuan model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate);
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@Jstime", model.Jstime);
cmd.AddParam("@Jsstartdate", model.Jsstartdate);
cmd.AddParam("@Jsenddate", model.Jsenddate);
cmd.AddParam("@Com_id", model.Com_id);
cmd.AddParam("@PosId", model.PosId);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}