public void AddPlans(int ChanID, string PlanContent, string PlanResult) { int[] a = new int[4]; a = GetRandomByGuid(a); string bh = "PN" + DateTime.Now.ToString("yyyyMMdd"); for (int j = 0; j < a.Length; j++) { bh += a[j]; } Model.Plans model = new Model.Plans { ChanID = ChanID, PlanContent = PlanContent, PlanDate = DateTime.Now, PlanResult = PlanResult, PlanResultDate = DateTime.Now, PlanID = bh }; bool check = new BLL.Plans().Add(model); }
/// <summary> /// 此方法用于根据id查询客户开发计划信息 /// </summary> /// <param name="planId"></param> /// <returns></returns> public static List<Model.Plans> PlanFindByID(int chanid) { string sql = "select * from plans where chanid=@chanid"; using (SqlDataReader sdr = DBHelp.ExecuteReader(sql, new List<SqlParameter> { new SqlParameter("@chanid", chanid) })) { List<Model.Plans> list = new List<Model.Plans>(); while (sdr.Read()) { Model.Plans obj = new Model.Plans(); obj.PlanID=sdr["PlanID"].ToString(); obj.ChanID=Convert.ToInt32(sdr["ChanID"].ToString()); obj.PlanDate=sdr["PlanDate"].ToString(); obj.PlanContent=sdr["PlanContent"].ToString(); if (sdr["PlanResultDate"] == null) { return null; } obj.PlanResultDate = sdr["PlanResultDate"].ToString(); obj.PlanResult=sdr["PlanResult"].ToString(); list.Add(obj); } return list; } }