/// <summary>
/// 退货通知单详情
/// </summary>
/// <param name="phoneNumber"></param>
/// <param name="groupId"></param>
/// <param name="fBillNo"></param>
/// <returns></returns>
public SalesReturnNoticeDetail GetSalesReturnNoticeDetail(string phoneNumber, string fBillNo)
{
try
{
SalesReturnNoticeDetail returnNoticeDetail = new SalesReturnNoticeDetail();
var fields = GetUserGroupFieldDisplayed(phoneNumber, "002");
returnNoticeDetail.Field = fields;
var field = string.Join(",", fields.Select(f => f.FFieldName).ToArray());
SqlParameter[] sqlParameter = new SqlParameter[]
{
new SqlParameter {
ParameterName = "@FBillNo", Value = fBillNo, SqlDbType = SqlDbType.NVarChar
}
};
string sql = "select " + field + " from tm_v_SalesReturnNotice where FBillNo=@FBillNo";
var res = SqlHelper.ExecuteDataTable(CommandType.Text, sql, sqlParameter);
returnNoticeDetail.Order = res;
LoggerHelper.Info("退货通知单详情");
return(returnNoticeDetail);
}
catch (Exception e)
{
LoggerHelper.Info("退货通知单详情，[" + phoneNumber + "],fBillNo：" + fBillNo + e);
return(null);
}
}
/// <summary>
/// 退货通知单详情
/// </summary>
/// <param name="phoneNumber"></param>
/// <param name="groupId"></param>
/// <param name="fBillNo"></param>
/// <returns></returns>
public SalesReturnNoticeDetail GetSalesReturnNoticeDetail(string phoneNumber, string fBillNo)
{
SalesReturnNoticeDetail returnNoticeDetail = new SalesReturnNoticeDetail();
var fields = GetUserGroupFieldDisplayed(phoneNumber, "002");
returnNoticeDetail.Field = fields;
var field = string.Join(",", fields.Select(f => f.FFieldName).ToArray());
SqlParameter[] sqlParameter = new SqlParameter[]
{
new SqlParameter {
ParameterName = "@FBillNo", Value = fBillNo, SqlDbType = SqlDbType.NVarChar
}
};
string sql = $"select {field} from tm_v_SalesReturnNotice where FBillNo=@FBillNo";
var res = SqlHelper.ExecuteDataTable(CommandType.Text, sql, sqlParameter);
returnNoticeDetail.Order = res;
return(returnNoticeDetail);
}
