public bool Update(Model.wx_travel_marker model)
{
using (IDbConnection db = DbFactory.GetOpenedConnection())
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.Append("Update [dbo].[wx_travel_marker]");
queryBuilder.Append(" Set [wid] = @wid");
queryBuilder.Append(" ,[Name] = @Name");
queryBuilder.Append(" ,[Remark] = @Remark");
queryBuilder.Append(" ,[Left] = @Left");
queryBuilder.Append(" ,[Top] = @Top");
queryBuilder.Append(" ,[Lng] = @Lng");
queryBuilder.Append(" ,[Lat] = @Lat");
queryBuilder.Append(" ,[Url] = @Url");
queryBuilder.Append(" ,[Description] = @Description");
queryBuilder.Append(" ,[extStr1] = @extStr1");
queryBuilder.Append(" ,[extStr2] = @extStr2");
queryBuilder.Append(" ,[extInt1] = @extInt1");
queryBuilder.Append(" ,[extInt2] = @extInt2");
queryBuilder.Append(" ,[Recommend] = @Recommend");
queryBuilder.Append(" ,[ScenicId] = @ScenicId");
queryBuilder.Append(" Where [Id]=@Id");
return(db.Execute(queryBuilder.ToString(), model) > 0);
}
}
private bool DoAdd()
{
Model.wx_travel_marker model = new Model.wx_travel_marker();
model.wid = GetWeiXinCode().id;
model.Name = txtName.Text;
model.Remark = txtRemark.Text;
model.Url = txtUrl.Text;
model.Description = txtDescription.Text;
model.Top = _top;
model.Left = _left;
model.ScenicId = Convert.ToInt32(hfScenicId.Value);
//model.extStr1 = txtAddress.Text;
model.Lat = Convert.ToDouble(txtLatXPoint.Text);
model.Lng = Convert.ToDouble(txtLngYPoint.Text);
model.Recommend = rblRecommend.SelectedValue == "1";
if (_bll.Add(model) > 0)
{
AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加手绘图景点:" + model.Name); //记录日志
return(true);
}
;
return(false);
}
public int Add(Model.wx_travel_marker model)
{
using (IDbConnection db = DbFactory.GetOpenedConnection())
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.Append("Insert Into dbo.wx_travel_marker");
queryBuilder.Append(" (wid,Name,Remark,[Left],[Top],Lng,Lat,Url,Description,extStr1,extStr2,extInt1,extInt2,Recommend,ScenicId)");
queryBuilder.Append("Values ");
queryBuilder.Append(" (@wid,@Name,@Remark,@Left,@Top,@Lng,@Lat,@Url,@Description,@extStr1,@extStr2,@extInt1,@extInt2,@Recommend,@ScenicId)");
queryBuilder.Append("Select @Id=Scope_Identity()");
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.AddDynamicParams(model);
dynamicParameters.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
db.Execute(queryBuilder.ToString(), dynamicParameters);
return(dynamicParameters.Get <int>("@Id"));
}
}
private void ShowInfo(int id)
{
Model.wx_travel_marker model = _bll.GetModel(id);
if (model != null)
{
txtName.Text = model.Name;
txtRemark.Text = model.Remark;
txtUrl.Text = model.Url;
txtDescription.Text = model.Description;
//txtAddress.Text = model.extStr1;
hfScenicId.Value = model.ScenicId.ToString();
txtLatXPoint.Text = model.Lat.ToString();
txtLngYPoint.Text = model.Lng.ToString();
ClientScript.RegisterStartupScript(GetType(), "message",
"<script language='javascript'> $(\"#qqframe\").attr(\"src\", \"../../weixin/map/qqmap/qqmap_getLocation.html?lng=" + model.Lng + "&lat=" + model.Lat + "\");</script>");
rblRecommend.SelectedValue = model.Recommend.HasValue && model.Recommend.Value ? "1" : "0";
}
}
private bool DoEdit()
{
Model.wx_travel_marker model = _bll.GetModel(_id);
model.wid = GetWeiXinCode().id;
model.Remark = txtRemark.Text;
model.Url = txtUrl.Text;
model.Description = txtDescription.Text;
//model.extStr1 = txtAddress.Text;
model.ScenicId = Convert.ToInt32(hfScenicId.Value);
model.Lat = Convert.ToDouble(txtLatXPoint.Text);
model.Lng = Convert.ToDouble(txtLngYPoint.Text);
model.Recommend = rblRecommend.SelectedValue == "1";
if (_bll.Update(model))
{
AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "修改手绘图景点:" + model.Name); //记录日志
return(true);
}
return(false);
}
public bool Update(Model.wx_travel_marker model)
{
return(_dal.Update(model));
}
public int Add(Model.wx_travel_marker model)
{
return(_dal.Add(model));
}
