private static ShowPlan GetShowPlanByDataRow(DataRow row) { ShowPlan showPlan = new ShowPlan(); showPlan.PID = Convert.ToInt32(row["pID"].ToString()); showPlan.PName = (string)row["pName"].ToString(); showPlan.PDesc = (string)row["pDesc"].ToString(); showPlan.PBegin = Convert.ToDateTime(row["pBegin"].ToString()); showPlan.PEnd = Convert.ToDateTime(row["pEnd"].ToString()); showPlan.PInTime = Convert.ToDateTime(row["pInTime"].ToString()); showPlan.IsPlay = Convert.ToInt32(row["IsPlay"]); return showPlan; }
/// <summary> /// 新增计划 /// </summary> /// <param name="showPlan">展示计划对象</param> /// <returns>受影响的行数</returns> public static int AddShowPlan(ShowPlan showPlan) { string sql = "INSERT INTO showPlan(pName,pDesc,pBegin,pEnd) value(@pName,@pDesc,@pBegin,@pEnd)"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@pName",showPlan.PName), new SqlParameter("@pDesc",showPlan.PDesc), new SqlParameter("@pBegin",showPlan.PBegin), new SqlParameter("@pEnd",showPlan.PEnd) }; return DBHelper.GetScalar(sql,par); }