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;
}
}
