public List <ui.ReturnMerchRecord> QueryReturnMerchRecord2(string content, string st, string et, string opera)
{
List <ui.ReturnMerchRecord> data_list = new List <ui.ReturnMerchRecord>();
DataSet ds;
UserDAL dal = new UserDAL();
if (string.IsNullOrEmpty(opera))
{
ds = ExecuteDataSet(@"select a.*,b.card_id,b.name,b.mobile from sales_return a, member b where a.member_id = b.uuid and (b.card_id like @Hykh or " +
"b.name like @Xm or b.mobile like @Dh) and (dt BETWEEN @st and @et)",
new MySqlParameter("@Hykh", "%" + content + "%"),
new MySqlParameter("@Xm", "%" + content + "%"),
new MySqlParameter("@Dh", "%" + content + "%"),
new MySqlParameter("@st", st),
new MySqlParameter("@et", et)
);
}
else
{
ds = ExecuteDataSet(@"select a.*,b.card_id,b.name,b.mobile from sales_return a, member b where a.member_id = b.uuid and (b.card_id like @Hykh or " +
"b.name like @Xm or b.mobile like @Dh) and (dt BETWEEN @st and @et) and operator_id=@operator",
new MySqlParameter("@Hykh", "%" + content + "%"),
new MySqlParameter("@Xm", "%" + content + "%"),
new MySqlParameter("@Dh", "%" + content + "%"),
new MySqlParameter("@st", st),
new MySqlParameter("@et", et),
new MySqlParameter("@operator", dal.QueryByUserName(opera).OptrID)
);
}
if (null != ds && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
ui.ReturnMerchRecord record = BuildRecordData(dr);
data_list.Add(record);
}
}
return(data_list);
}
private ui.ReturnMerchRecord BuildRecordData(DataRow dr)
{
ui.ReturnMerchRecord record = new ui.ReturnMerchRecord();
record.ReturnID = (string)dr["uuid"];
if (!string.IsNullOrEmpty(dr["order_id"].ToString()))
{
record.OrderID = (string)dr["order_id"];
}
if (!string.IsNullOrEmpty(dr["dt"].ToString()))
{
record.ReturnDate = (DateTime)dr["dt"];
}
if (!string.IsNullOrEmpty(dr["member_id"].ToString()))
{
record.MemberID = (string)dr["member_id"];
}
if (!string.IsNullOrEmpty(dr["total"].ToString()))
{
record.TotalMoney = (decimal)dr["total"];
}
if (!string.IsNullOrEmpty(dr["return_value"].ToString()))
{
record.TotalMerchMoney = (decimal)dr["return_value"];
}
if (!string.IsNullOrEmpty(dr["pledge"].ToString()))
{
record.TotalDeposit = (decimal)dr["pledge"];
}
if (!string.IsNullOrEmpty(dr["operator_id"].ToString()))
{
UserDAL dal = new UserDAL();
record.Operator = dal.QueryByOptrID((int)dr["operator_id"]).name;
}
if (!string.IsNullOrEmpty(dr["comment"].ToString()))
{
record.Remark = (string)dr["comment"];
}
return(record);
}
public List <ui.ReturnMerchRecord> QueryReturnMerchRecord(string memberId, string st, string et, string opera)
{
List <ui.ReturnMerchRecord> data_list = new List <ui.ReturnMerchRecord>();
DataSet ds;
UserDAL dal = new UserDAL();
if (string.IsNullOrEmpty(opera))
{
ds = ExecuteDataSet(@"select * from sales_return where member_id=@id and (dt BETWEEN @st and @et)",
new MySqlParameter("@id", memberId),
new MySqlParameter("@st", st),
new MySqlParameter("@et", et)
);
}
else
{
ds = ExecuteDataSet(@"select * from sales_return where member_id=@id and (dt BETWEEN @st and @et) and operator_id=@operator",
new MySqlParameter("@id", memberId),
new MySqlParameter("@st", st),
new MySqlParameter("@et", et),
new MySqlParameter("@operator", dal.QueryByUserName(opera).OptrID)
);
}
if (null != ds && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
ui.ReturnMerchRecord record = BuildRecordData(dr);
data_list.Add(record);
}
}
return(data_list);
}
