public T_BusinessConsulting GetModel(int id) { T_BusinessConsulting model = null; string strSql = string.Format("select top 1 Id,UserName,UserAddress,UserTel,UserEmail,ConsTitle,ConsContent,ConsDate,ReplyContent,ReplyDate,ReplyUser from T_BusinessConsulting where Id={0}", id); using (dynamic read = DbHelper.Factory().ExecuteReader(strSql)) { model = new T_BusinessConsulting(); if (read.Read()) { model.Id = int.Parse(read["Id"].ToString()); model.UserName = read["UserName"].ToString(); model.UserAddress = read["UserAddress"].ToString(); model.UserTel = read["UserTel"].ToString(); model.UserEmail = read["UserEmail"].ToString(); model.ConsTitle = read["ConsTitle"].ToString(); model.ConsContent = read["ConsContent"].ToString(); try { model.ConsDate = DateTime.Parse(read["ConsDate"].ToString()); } catch { } model.ReplyContent = read["ReplyContent"].ToString(); try { model.ReplyDate = DateTime.Parse(read["ReplyDate"].ToString()); } catch { } model.ReplyUser = read["ReplyUser"].ToString(); } read.Dispose(); } return(model); }
private string Update(T_BusinessConsulting model) { try { if (dal.Update(model)) { return("业务咨询信息修改成功!"); } else { return("业务咨询信息修改失败,错误代码:500 "); } } catch { return("Error 500"); } }
// public bool Update(T_BusinessConsulting model) { try { object[] obj = { model.ReplyContent, model.ReplyDate.ToString("yyyy-MM-dd HH:mm:ss"), model.ReplyUser, model.Id, model.BusinsessState }; string strSql = string.Format("update [T_BusinessConsulting] set [ReplyContent] ='{0}',[ReplyDate] ='{1}',[ReplyUser] ='{2}',BusinsessState='{4}' where [Id]={3} ", obj); if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0) { return(true); } else { return(false); } } catch { throw; } }
// public bool Create(T_BusinessConsulting model) { try { object[] obj = { model.UserName, model.UserAddress, model.UserTel, model.UserEmail, model.ConsTitle, model.ConsContent, model.ConsDate.ToString("yyyy-MM-dd HH:mm:ss"), model.ReplyContent, model.ReplyDate.ToString("yyyy-MM-dd HH:mm:ss"), model.ReplyUser, model.BusinessType }; string strSql = string.Format("insert into [T_BusinessConsulting]([UserName],[UserAddress],[UserTel],[UserEmail],[ConsTitle],[ConsContent],[ConsDate],[ReplyContent],[ReplyDate],[ReplyUser],BusinessType)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", obj); if (DbHelper.Factory().ExecuteNonQuery(strSql) > 0) { return(true); } else { return(false); } } catch { throw; } }
private T_BusinessConsulting GetModel(HttpContext context) { T_BusinessConsulting model = new T_BusinessConsulting(); try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); } catch { } model.UserName = context.Request.Form["UserName"].ToString(); model.UserAddress = context.Request.Form["UserAddress"].ToString(); model.UserTel = context.Request.Form["UserTel"].ToString(); model.UserEmail = context.Request.Form["UserEmail"].ToString(); model.ConsTitle = context.Request.Form["ConsTitle"].ToString(); model.ConsContent = context.Request.Form["ConsContent"].ToString(); try { model.ConsDate = DateTime.Parse(context.Request.Form["ConsDate"].ToString()); } catch { } model.ReplyContent = context.Request.Form["ReplyContent"].ToString(); try { model.ReplyDate = DateTime.Parse(context.Request.Form["ReplyDate"].ToString()); } catch { } model.ReplyUser = context.Request.Form["ReplyUser"].ToString(); model.BusinsessState = "1"; return(model); }
public void Add(T_BusinessConsulting model) { dal.Create(model); }