public static void Setup(int testItems)
{
SetTestRepo();
for (int i = 0; i < testItems; i++)
{
AdvertisingPosition item = new AdvertisingPosition();
_testRepo._items.Add(item);
}
}
public override bool Equals(object obj)
{
if (obj.GetType() == typeof(AdvertisingPosition))
{
AdvertisingPosition compare = (AdvertisingPosition)obj;
return(compare.KeyValue() == this.KeyValue());
}
else
{
return(base.Equals(obj));
}
}
public static AdvertisingPosition SingleOrDefault(Expression <Func <AdvertisingPosition, bool> > expression, string connectionString, string providerName)
{
var repo = GetRepo(connectionString, providerName);
var results = repo.Find(expression);
AdvertisingPosition single = null;
if (results.Count() > 0)
{
single = results.ToList()[0];
}
return(single);
}
public static AdvertisingPosition SingleOrDefault(Expression <Func <AdvertisingPosition, bool> > expression)
{
var repo = GetRepo();
var results = repo.Find(expression);
AdvertisingPosition single = null;
if (results.Count() > 0)
{
single = results.ToList()[0];
single.OnLoaded();
single.SetIsLoaded(true);
single.SetIsNew(false);
}
return(single);
}
void Init()
{
TestMode = this._db.DataProvider.ConnectionString.Equals("test", StringComparison.InvariantCultureIgnoreCase);
_dirtyColumns = new List <IColumn>();
if (TestMode)
{
AdvertisingPosition.SetTestRepo();
_repo = _testRepo;
}
else
{
_repo = new SubSonicRepository <AdvertisingPosition>(_db);
}
tbl = _repo.GetTable();
SetIsNew(true);
OnCreated();
}
internal static IRepository <AdvertisingPosition> GetRepo(string connectionString, string providerName)
{
Solution.DataAccess.DataModel.SolutionDataBaseDB db;
if (String.IsNullOrEmpty(connectionString))
{
db = new Solution.DataAccess.DataModel.SolutionDataBaseDB();
}
else
{
db = new Solution.DataAccess.DataModel.SolutionDataBaseDB(connectionString, providerName);
}
IRepository <AdvertisingPosition> _repo;
if (db.TestMode)
{
AdvertisingPosition.SetTestRepo();
_repo = _testRepo;
}
else
{
_repo = new SubSonicRepository <AdvertisingPosition>(db);
}
return(_repo);
}
public static void Setup(int testItems)
{
SetTestRepo();
for(int i=0;i<testItems;i++){
AdvertisingPosition item=new AdvertisingPosition();
_testRepo._items.Add(item);
}
}
public static void Setup(AdvertisingPosition item)
{
SetTestRepo();
_testRepo._items.Add(item);
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
return txtName.Label + "不能为空！";
}
var sName = StringHelper.Left(txtName.Text, 50);
if (AdvertisingPositionBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
{
return txtName.Label + "已存在！请重新输入！";
}
if (string.IsNullOrEmpty(txtKey.Text.Trim()))
{
return txtKey.Label + "不能为空！";
}
var sKeyword = StringHelper.Left(txtKey.Text, 50);
if (AdvertisingPositionBll.GetInstence().Exist(x => x.Keyword == sKeyword && x.Id != id))
{
return txtKey.Label + "已存在！请重新输入！";
}
#endregion
#region 赋值
//定义是否更新其他关联表变量
bool isUpdate = false;
//读取当前地址信息
var model = new AdvertisingPosition(x => x.Id == id);
//判断是否更新关联表
if (model.Id > 0 && sName != model.Name)
isUpdate = true;
//设置名称
model.Name = StringHelper.Left(txtName.Text, 50);
//KEY
model.Keyword = StringHelper.Left(txtKey.Text, 50);
//对应的父类id
model.ParentId = ConvertHelper.Cint0(txtParent.Text);
//由于限制了编辑时不能修改父节点，所以这里只对新建记录时处理
if (id == 0)
{
//设定当前的深度与设定当前的层数级
if (model.ParentId == 0)
{
//设定当前的层数级
model.Depth = 0;
}
else
{
//设定当前的层数
model.Depth = ConvertHelper.Cint0(AdvertisingPositionBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), AdvertisingPositionTable.Depth)) + 1;
}
//限制分类层数只能为2层
if (model.Depth > 2)
{
return "广告位置只能创建2层分类！";
}
}
//设置排序
if (txtSort.Text == "0")
{
model.Sort = AdvertisingPositionBll.GetInstence().GetSortMax(model.ParentId) + 1;
}
else
{
model.Sort = ConvertHelper.Cint0(txtSort.Text);
}
//设定当前项是否显示
model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue);
//广告宽与高
model.Width = ConvertHelper.Cint0(txtWidth.Text);
model.Height = ConvertHelper.Cint0(txtHeight.Text);
//添加最后修改人员
model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId();
model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName();
model.AddDate = DateTime.Now;
#endregion
#region 上传图片
//上传广告位置图
if (this.MapImg.HasFile && this.MapImg.FileName.Length > 3)
{
int vid = 5; //5 广告位置图
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.MapImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload);
this.MapImg.Dispose();
//---------------------------------------------------
if (result.Length == 0)//上传成功
{
model.MapImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传出错：" + result, null);//收集异常信息
return "上传出错！" + result;
}
}
//如果是修改，检查用户是否重新上传过新图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.MapImg, AdvertisingPositionTable.TableName, model.Id, model.MapImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
//——————————————————————————————————————————————————————————————————————
//上传广告默认图
if (this.PicImg.HasFile && this.PicImg.FileName.Length > 3)
{
int vid = 6; //6 广告默认图
//---------------------------------------------------
var upload = new UploadFile();
result = new UploadFileBll().Upload_AspNet(this.PicImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload);
this.PicImg.Dispose();
//---------------------------------------------------
if (result.Length == 0)//上传成功
{
model.PicImg = upload.Path;
}
else
{
CommonBll.WriteLog("上传出错：" + result, null);//收集异常信息
return "上传出错！" + result;
}
}
//如果是修改，检查用户是否重新上传过默认图片，如果是删除旧的图片
if (model.Id > 0)
{
UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.PicImg, AdvertisingPositionTable.TableName, model.Id, model.PicImg);
//同步UploadFile上传表
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
#endregion
//----------------------------------------------------------
//存储到数据库
AdvertisingPositionBll.GetInstence().Save(this, model);
#region 同步更新上传图片表绑定Id
if (id == 0)
{
//同步UploadFile上传表记录，绑定刚刚上传成功的文件Id为当前记录Id
UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id);
}
#endregion
//如果本次修改改变了相关名称，则同步更新其他关联表的对应名称
if (isUpdate)
{
AdvertisementBll.GetInstence().UpdateValue_For_AdvertisingPosition_Id(this, model.Id, AdvertisementTable.AdvertisingPosition_Name, model.Name);
}
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return result;
}
public static void Setup(AdvertisingPosition item)
{
SetTestRepo();
_testRepo._items.Add(item);
}
