/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_anpai model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@a_id", SqlDbType.Int, 4), new SqlParameter("@a_title", SqlDbType.VarChar, 50), new SqlParameter("@a_content", SqlDbType.VarChar, 500), new SqlParameter("@a_date", SqlDbType.DateTime), new SqlParameter("@a_ampm", SqlDbType.VarChar, 50), new SqlParameter("@a_userId", SqlDbType.Int, 4), new SqlParameter("@a_createDate", SqlDbType.DateTime) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.a_title; parameters[2].Value = model.a_content; parameters[3].Value = model.a_date; parameters[4].Value = model.a_ampm; parameters[5].Value = model.a_userId; parameters[6].Value = model.a_createDate; DbHelperSQL.RunProcedure("UP_Tunnel_anpai_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_anpai> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_anpai> modelList = new List <Tunnel.Model.Tunnel_anpai>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_anpai model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_anpai(); if (dt.Rows[n]["a_id"].ToString() != "") { model.a_id = int.Parse(dt.Rows[n]["a_id"].ToString()); } model.a_title = dt.Rows[n]["a_title"].ToString(); model.a_content = dt.Rows[n]["a_content"].ToString(); if (dt.Rows[n]["a_date"].ToString() != "") { model.a_date = DateTime.Parse(dt.Rows[n]["a_date"].ToString()); } model.a_ampm = dt.Rows[n]["a_ampm"].ToString(); if (dt.Rows[n]["a_userId"].ToString() != "") { model.a_userId = int.Parse(dt.Rows[n]["a_userId"].ToString()); } if (dt.Rows[n]["a_createDate"].ToString() != "") { model.a_createDate = DateTime.Parse(dt.Rows[n]["a_createDate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_anpai GetModel(int a_id) { SqlParameter[] parameters = { new SqlParameter("@a_id", SqlDbType.Int, 4) }; parameters[0].Value = a_id; Tunnel.Model.Tunnel_anpai model = new Tunnel.Model.Tunnel_anpai(); DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_anpai_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["a_id"].ToString() != "") { model.a_id = int.Parse(ds.Tables[0].Rows[0]["a_id"].ToString()); } model.a_title = ds.Tables[0].Rows[0]["a_title"].ToString(); model.a_content = ds.Tables[0].Rows[0]["a_content"].ToString(); if (ds.Tables[0].Rows[0]["a_date"].ToString() != "") { model.a_date = DateTime.Parse(ds.Tables[0].Rows[0]["a_date"].ToString()); } model.a_ampm = ds.Tables[0].Rows[0]["a_ampm"].ToString(); if (ds.Tables[0].Rows[0]["a_userId"].ToString() != "") { model.a_userId = int.Parse(ds.Tables[0].Rows[0]["a_userId"].ToString()); } if (ds.Tables[0].Rows[0]["a_createDate"].ToString() != "") { model.a_createDate = DateTime.Parse(ds.Tables[0].Rows[0]["a_createDate"].ToString()); } return(model); } else { return(null); } }
public List <Tunnel.Model.Tunnel_anpai> GetList(PageBase pb, ref int count) { DataTable dt = dal.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_anpai> modelList = new List <Tunnel.Model.Tunnel_anpai>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_anpai model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_anpai(); if (dt.Rows[n]["a_id"].ToString() != "") { model.a_id = int.Parse(dt.Rows[n]["a_id"].ToString()); } model.a_title = dt.Rows[n]["a_title"].ToString(); model.a_content = dt.Rows[n]["a_content"].ToString(); if (dt.Rows[n]["a_date"].ToString() != "") { model.a_date = DateTime.Parse(dt.Rows[n]["a_date"].ToString()); } model.a_ampm = dt.Rows[n]["a_ampm"].ToString(); if (dt.Rows[n]["a_userId"].ToString() != "") { model.a_userId = int.Parse(dt.Rows[n]["a_userId"].ToString()); } if (dt.Rows[n]["a_createDate"].ToString() != "") { model.a_createDate = DateTime.Parse(dt.Rows[n]["a_createDate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_anpai model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_anpai model) { return(dal.Add(model)); }