/// <summary>
/// 自定义视图
/// </summary>
public cms_user viewtestModel()
{
using (SelectAction action = new SelectAction(""))
{
action.SqlClomns = "_cms_user.*,_cms_manager.name as managername";
{
//添加视图的关联关系
List <QueryField> field = new List <QueryField>();
field.Add(new QueryField()
{
FiledName = "mangerid", Condition = ConditionEnum.And, Value = "id"
});
action.AddJoin(ViewJoinEnum.leftjoin, "cms_user", "cms_manager", field);
}
action.SqlWhere(
new QueryField {
FiledName = cms_user.Columns.username, Value = "wangjun"
});
action.SqlWhere(cms_user.Columns.password, "123456");
PageList <cms_user> lists = action.QueryPage <cms_user>(1);
return(null);
}
}
public PageList <SmsBatchDetailsMoreInfo> GetList(int PageIndex, int PageSize, string phone, string state, string starttime, string endtime, int eid)
{
using (SelectAction action = new SelectAction(""))
{
action.SqlClomns = "_sms_batch_details.*,_sms_batch.batchname";
{
//添加视图的关联关系
List <QueryField> field = new List <QueryField>();
field.Add(new QueryField()
{
Value = SmsBatchDetailsInfo.Columns.BatchID,
Condition = ConditionEnum.And,
FiledName = SmsBatchInfo.Columns.ID
});
action.AddJoin(ViewJoinEnum.innerjoin, "sms_batch", "sms_batch_details", field);
}
if (eid != 1)
{
action.SqlWhere("_sms_batch." + SmsBatchInfo.Columns.EnterPriseID, eid);
}
if (!string.IsNullOrEmpty(phone))
{
action.SqlWhere(SmsBatchDetailsInfo.Columns.Phone, phone, RelationEnum.Like);
}
if (!string.IsNullOrEmpty(state) && int.Parse(state) > 0)
{
action.SqlWhere(SmsBatchDetailsInfo.Columns.State, state);
}
if (!string.IsNullOrEmpty(starttime) && string.IsNullOrEmpty(endtime))
{
action.SqlWhere(SmsBatchDetailsInfo.Columns.SubmitTime, starttime, ConditionEnum.And, RelationEnum.LargeThen);
}
if (!string.IsNullOrEmpty(endtime) && string.IsNullOrEmpty(starttime))
{
action.SqlWhere(SmsBatchDetailsInfo.Columns.SubmitTime, endtime, ConditionEnum.And, RelationEnum.LessThen);
}
if (!string.IsNullOrEmpty(endtime) && !string.IsNullOrEmpty(starttime))
{
action.SqlWhere(SmsBatchDetailsInfo.Columns.SubmitTime, starttime, endtime, ConditionEnum.And, RelationEnum.Between);
}
action.SqlOrderBy("_sms_batch_details.SubmitTime", OrderByEnum.Desc);
action.PageSize = PageSize;
return(action.QueryPage <SmsBatchDetailsMoreInfo>(PageIndex));
}
}
public PageList <BatchMoreInfo> GetList(int PageIndex, int PageSize, string batchname, string state, string starttime, string endtime, int eid)
{
using (SelectAction action = new SelectAction(""))
{
action.SqlClomns = "_sms_batch.*,_sms_batch_amount.RealAmount,_sms_batch_amount.SendAmount,_sms_batch_amount.SuccessAmount";
{
//添加视图的关联关系
List <QueryField> field = new List <QueryField>();
field.Add(new QueryField()
{
Value = SmsBatchAmountInfo.Columns.BatchID,
Condition = ConditionEnum.And,
FiledName = SmsBatchInfo.Columns.ID
});
action.AddJoin(ViewJoinEnum.leftjoin, "sms_batch", "sms_batch_amount", field);
}
if (eid != 1)
{
action.SqlWhere("_sms_batch." + SmsBatchInfo.Columns.EnterPriseID, eid);
}
if (!string.IsNullOrEmpty(batchname))
{
action.SqlWhere(SmsBatchInfo.Columns.BatchName, batchname, ConditionEnum.And, RelationEnum.Like);
}
if (!string.IsNullOrEmpty(state) && int.Parse(state) > 0)
{
action.SqlWhere(SmsBatchInfo.Columns.BatchState, state);
}
if (!string.IsNullOrEmpty(starttime) && string.IsNullOrEmpty(endtime))
{
action.SqlWhere(SmsBatchInfo.Columns.PostTime, starttime, ConditionEnum.And, RelationEnum.LargeThen);
}
if (!string.IsNullOrEmpty(endtime) && string.IsNullOrEmpty(starttime))
{
action.SqlWhere(SmsBatchInfo.Columns.PostTime, endtime, ConditionEnum.And, RelationEnum.LessThen);
}
if (!string.IsNullOrEmpty(endtime) && !string.IsNullOrEmpty(starttime))
{
action.SqlWhere(SmsBatchInfo.Columns.PostTime, starttime, endtime, ConditionEnum.And, RelationEnum.Between);
}
action.SqlOrderBy("_sms_batch.Createtime", OrderByEnum.Desc);
action.PageSize = PageSize;
return(action.QueryPage <BatchMoreInfo>(PageIndex));
}
}
/// <summary>
/// 获取账号的基本信息
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public SmsAddrecordInfo GetAccountInfo(string username, string password)
{
using (SelectAction action = new SelectAction(Entity))
{
action.SqlClomns = "_Sms_AddRecord.*";
{
//添加视图的关联关系
List <QueryField> field = new List <QueryField>();
field.Add(new QueryField()
{
FiledName = SmsAddrecordInfo.Columns.AccountID,
Condition = ConditionEnum.And,
Value = SmsAccountInfo.Columns.ID
});
action.AddJoin(ViewJoinEnum.leftjoin, "SmsAccountInfo", "Sms_AddRecord", field);
}
action.SqlWhere(SmsAccountInfo.Columns.Account, username);
action.SqlWhere(SmsAccountInfo.Columns.Password, password);
action.SqlOrderBy("_Sms_AddRecord." + SmsAddrecordInfo.Columns.CreateTime, OrderByEnum.Desc);
return(action.QueryEntity <SmsAddrecordInfo>());
}
}
public List <SmsMoInfo> GetUserMo(string username, string password)
{
using (SelectAction action = new SelectAction(""))
{
action.SqlClomns = "_SmsMoInfo.*";
{
//添加视图的关联关系
List <QueryField> field = new List <QueryField>();
field.Add(new QueryField()
{
Value = SmsMoInfo.Columns.AccountID,
Condition = ConditionEnum.And,
FiledName = SmsAccountInfo.Columns.ID
});
action.AddJoin(ViewJoinEnum.innerjoin, "sms_account", "sms_mo", field);
}
action.SqlWhere(SmsAccountInfo.Columns.Account, username);
action.SqlWhere(SmsAccountInfo.Columns.Password, password);
action.PageSize = 20;
return(action.QueryPage <SmsMoInfo>(1));
}
}