/// <summary> /// 录入新沟通记录 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>qipengfei 2010-10-14</remarks> public bool Add(E_Exchange data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@ClientInfoID", SqlDbType.Int), new SqlParameter("@EPUserTMRID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.NVarChar,512), new SqlParameter("@ExchangeDate", SqlDbType.DateTime), new SqlParameter("@ReturnValue", SqlDbType.Int, 4,ParameterDirection.ReturnValue,false, 0, 0, string.Empty, DataRowVersion.Default, null) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.ClientInfoID; parms[2].Value = data.EPUserTMRID; parms[3].Value = data.Detail; parms[4].Value = Convert.ToDateTime(data.ExchangeDate).ToString("yyyy-MM-dd HH:mm:ss"); string returnValue = ""; DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_ExchangeS_Insert", parms, parms.Length - 1, ref returnValue); if (returnValue.Equals("0")) { return(false); } if (dt != null && dt.Rows.Count == 1)//判断是否录入成功 { data.Detail = dt.Rows[0]["Detail"].ToString(); data.ExchangeDate = Convert.ToDateTime(dt.Rows[0]["ExchangeDate"]); data.UserInfo = dt.Rows[0]["UserInfo"].ToString(); return(true); } return(false); }
/// <summary> /// 获取名录下的沟通列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>qipengfei 2010-10-14</remarks> public DataTable GetList(E_Exchange 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_Exchange_Select", parms)); }
/// <summary> /// 新沟通记录 /// </summary> private void Exchange() { E_Exchange data = new E_Exchange(); data.PersonalID = bp.PersonalID; data.ClientInfoID = Convert.ToInt32(nv["id"]); data.Detail = nv["info"]; data.ExchangeDate = Convert.ToDateTime(nv["date"]); bool b = new T_Exchange().Add(data); JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("result", b ? "1" : "0")); colDR.Add(new JsonStringValue("detail", data.Detail)); colDR.Add(new JsonStringValue("date", Convert.ToDateTime(data.ExchangeDate).ToString("yyyy-MM-dd HH:mm"))); HttpContext.Current.Response.Write(colDR.ToString()); }
/// <summary> /// 添加名录沟通记录 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-26</remarks> public bool Add(E_Exchange data) { SqlParameter[] parms = { new SqlParameter("@PersonalID", SqlDbType.Int), new SqlParameter("@ClientInfoID", SqlDbType.Int), new SqlParameter("@Detail", SqlDbType.VarChar,512), new SqlParameter("@ExchangeDate", SqlDbType.SmallDateTime) }; parms[0].Value = data.PersonalID; parms[1].Value = data.ClientInfoID; parms[2].Value = data.Detail; parms[3].Value = data.ExchangeDate; int ReturnValue = 0; DbHelperSQL.RunProcedures("ProcPI_B_Exchange_Insert", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 获取沟通记录列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public DataTable GetList(E_Exchange data) { return(dal.GetList(data)); }
/// <summary> /// 添加沟通名录 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool Add(E_Exchange data) { return(dal.Add(data)); }