/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_weekplan model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.BigInt, 8), new SqlParameter("@w_title", SqlDbType.VarChar, 200), new SqlParameter("@w_content", SqlDbType.VarChar, 500), new SqlParameter("@w_address", SqlDbType.VarChar, 100), new SqlParameter("@w_time", SqlDbType.VarChar, 50), new SqlParameter("@w_daytime", SqlDbType.VarChar, 50), new SqlParameter("@w_adddate", SqlDbType.DateTime), new SqlParameter("@w_weekID", SqlDbType.VarChar, 200), new SqlParameter("@w_date", SqlDbType.VarChar, 50) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.w_title; parameters[2].Value = model.w_content; parameters[3].Value = model.w_address; parameters[4].Value = model.w_time; parameters[5].Value = model.w_daytime; parameters[6].Value = model.w_adddate; parameters[7].Value = model.w_weekID; parameters[8].Value = model.w_date; DbHelperSQL.RunProcedure("UP_Tunnel_weekplan_ADD", parameters, out rowsAffected); return(int.Parse(parameters[0].Value.ToString())); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_weekplan model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.BigInt, 8), new SqlParameter("@w_title", SqlDbType.VarChar, 200), new SqlParameter("@w_content", SqlDbType.VarChar, 500), new SqlParameter("@w_address", SqlDbType.VarChar, 100), new SqlParameter("@w_time", SqlDbType.VarChar, 50), new SqlParameter("@w_daytime", SqlDbType.VarChar, 50), new SqlParameter("@w_adddate", SqlDbType.DateTime), new SqlParameter("@w_weekID", SqlDbType.VarChar, 200), new SqlParameter("@w_date", SqlDbType.VarChar, 50) }; parameters[0].Value = model.w_id; parameters[1].Value = model.w_title; parameters[2].Value = model.w_content; parameters[3].Value = model.w_address; parameters[4].Value = model.w_time; parameters[5].Value = model.w_daytime; parameters[6].Value = model.w_adddate; parameters[7].Value = model.w_weekID; parameters[8].Value = model.w_date; DbHelperSQL.RunProcedure("UP_Tunnel_weekplan_Update", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_weekplan GetModel(long w_id) { SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.BigInt) }; parameters[0].Value = w_id; Tunnel.Model.Tunnel_weekplan model = new Tunnel.Model.Tunnel_weekplan(); DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_weekplan_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["w_id"].ToString() != "") { model.w_id = long.Parse(ds.Tables[0].Rows[0]["w_id"].ToString()); } model.w_title = ds.Tables[0].Rows[0]["w_title"].ToString(); model.w_content = ds.Tables[0].Rows[0]["w_content"].ToString(); model.w_address = ds.Tables[0].Rows[0]["w_address"].ToString(); model.w_time = ds.Tables[0].Rows[0]["w_time"].ToString(); model.w_daytime = ds.Tables[0].Rows[0]["w_daytime"].ToString(); if (ds.Tables[0].Rows[0]["w_adddate"].ToString() != "") { model.w_adddate = DateTime.Parse(ds.Tables[0].Rows[0]["w_adddate"].ToString()); } model.w_weekID = ds.Tables[0].Rows[0]["w_weekID"].ToString(); model.w_date = ds.Tables[0].Rows[0]["w_date"].ToString(); return(model); } else { return(null); } }