/// <summary> /// 添加沟通记录 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-15</remarks> public E_ItemExchange Add(E_ItemExchange data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ClientInfoID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.NVarChar, 512) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ClientInfoID; parms[2].Value = data.UserID; parms[3].Value = data.Detail; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_ItemExchange_Insert", parms); if (dt != null && dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; data.ClientInfoID = Convert.ToInt32(row["ClientInfoID"]); data.Detail = row["Detail"].ToString(); data.AddDate = Convert.ToDateTime(row["AddDate"]); data.RealName = row["RealName"].ToString(); return(data); } return(null); }
/// <summary> /// 获取沟通记录列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-15</remarks> public DataTable GetList(E_ItemExchange data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ClientInfoID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ClientInfoID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_ItemExchange_ListSelect", parms)); }
/// <summary> /// 添加沟通记录 /// </summary> private void AddExchange() { E_ItemExchange data = new E_ItemExchange(); data.EnterpriseID = pp.EnterpriseID; data.UserID = pp.UserID; data.ClientInfoID = Convert.ToInt32(nv["ciid"]); data.Detail = nv["info"]; data.AddDate = Convert.ToDateTime(nv["date"]); data = new T_ItemExchange().Add(data); JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("result", data != null ? "1" : "0")); colDR.Add(new JsonStringValue("detail", data.Detail)); colDR.Add(new JsonStringValue("date", Convert.ToDateTime(data.AddDate).ToString("yyyy-MM-dd HH:mm"))); colDR.Add(new JsonStringValue("realname", data.RealName)); HttpContext.Current.Response.Write(colDR.ToString()); }
/// <summary> /// 获取沟通记录列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-15</remarks> public DataTable GetList(E_ItemExchange data) { return(dal.GetList(data)); }
/// <summary> /// 添加沟通记录 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-15</remarks> public E_ItemExchange Add(E_ItemExchange data) { return(dal.Add(data)); }