/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Chances DataRowToModel(DataRow row) { Maticsoft.Model.Chances model = new Maticsoft.Model.Chances(); if (row != null) { if (row["ChanID"] != null && row["ChanID"].ToString() != "") { model.ChanID = int.Parse(row["ChanID"].ToString()); } if (row["ChanName"] != null) { model.ChanName = row["ChanName"].ToString(); } if (row["ChanRate"] != null && row["ChanRate"].ToString() != "") { model.ChanRate = int.Parse(row["ChanRate"].ToString()); } if (row["ChanLinkMan"] != null) { model.ChanLinkMan = row["ChanLinkMan"].ToString(); } if (row["ChanLinkTel"] != null) { model.ChanLinkTel = row["ChanLinkTel"].ToString(); } if (row["ChanTitle"] != null) { model.ChanTitle = row["ChanTitle"].ToString(); } if (row["ChanDesc"] != null) { model.ChanDesc = row["ChanDesc"].ToString(); } if (row["ChanCreateMan"] != null && row["ChanCreateMan"].ToString() != "") { model.ChanCreateMan = int.Parse(row["ChanCreateMan"].ToString()); } if (row["ChanCreateDate"] != null && row["ChanCreateDate"].ToString() != "") { model.ChanCreateDate = DateTime.Parse(row["ChanCreateDate"].ToString()); } if (row["ChanDueMan"] != null && row["ChanDueMan"].ToString() != "") { model.ChanDueMan = int.Parse(row["ChanDueMan"].ToString()); } if (row["ChanDueDate"] != null && row["ChanDueDate"].ToString() != "") { model.ChanDueDate = DateTime.Parse(row["ChanDueDate"].ToString()); } if (row["ChanState"] != null && row["ChanState"].ToString() != "") { model.ChanState = int.Parse(row["ChanState"].ToString()); } if (row["ChanError"] != null) { model.ChanError = row["ChanError"].ToString(); } } return(model); }
/// <summary> /// 销售机会状态为成功 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SetChanceSuccess(Maticsoft.Model.Chances model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Chances set "); strSql.Append("ChanState=@ChanState"); strSql.Append(" where ChanID=@ChanID"); SqlParameter[] parameters = { new SqlParameter("@ChanState", SqlDbType.Int, 4), new SqlParameter("@ChanID", SqlDbType.Int, 4) }; parameters[0].Value = model.ChanState; parameters[1].Value = model.ChanID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Chances model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Chances set "); strSql.Append("ChanName=@ChanName,"); strSql.Append("ChanRate=@ChanRate,"); strSql.Append("ChanLinkMan=@ChanLinkMan,"); strSql.Append("ChanLinkTel=@ChanLinkTel,"); strSql.Append("ChanTitle=@ChanTitle,"); strSql.Append("ChanDesc=@ChanDesc,"); strSql.Append("ChanCreateMan=@ChanCreateMan,"); strSql.Append("ChanDueMan=@ChanDueMan,"); strSql.Append("ChanDueDate=@ChanDueDate,"); strSql.Append("ChanState=@ChanState,"); strSql.Append("ChanError=@ChanError"); strSql.Append(" where ChanID=@ChanID"); SqlParameter[] parameters = { new SqlParameter("@ChanName", SqlDbType.NVarChar, 50), new SqlParameter("@ChanRate", SqlDbType.Int, 4), new SqlParameter("@ChanLinkMan", SqlDbType.NVarChar, 50), new SqlParameter("@ChanLinkTel", SqlDbType.VarChar, 50), new SqlParameter("@ChanTitle", SqlDbType.NVarChar, 500), new SqlParameter("@ChanDesc", SqlDbType.NVarChar, 2000), new SqlParameter("@ChanCreateMan", SqlDbType.Int, 4), new SqlParameter("@ChanDueMan", SqlDbType.Int, 4), new SqlParameter("@ChanDueDate", SqlDbType.DateTime), new SqlParameter("@ChanState", SqlDbType.Int, 4), new SqlParameter("@ChanError", SqlDbType.NVarChar, 500), new SqlParameter("@ChanID", SqlDbType.Int, 4) }; parameters[0].Value = model.ChanName; parameters[1].Value = model.ChanRate; parameters[2].Value = model.ChanLinkMan; parameters[3].Value = model.ChanLinkTel; parameters[4].Value = model.ChanTitle; parameters[5].Value = model.ChanDesc; parameters[6].Value = model.ChanCreateMan; parameters[7].Value = model.ChanDueMan; parameters[8].Value = model.ChanDueDate; parameters[9].Value = model.ChanState; parameters[10].Value = model.ChanError; parameters[11].Value = model.ChanID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Chances model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Chances("); strSql.Append("ChanName,ChanRate,ChanLinkMan,ChanLinkTel,ChanTitle,ChanDesc,ChanCreateMan,ChanCreateDate,ChanDueMan,ChanDueDate,ChanState,ChanError)"); strSql.Append(" values ("); strSql.Append("@ChanName,@ChanRate,@ChanLinkMan,@ChanLinkTel,@ChanTitle,@ChanDesc,@ChanCreateMan,@ChanCreateDate,@ChanDueMan,@ChanDueDate,@ChanState,@ChanError)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ChanName", SqlDbType.NVarChar, 50), new SqlParameter("@ChanRate", SqlDbType.Int, 4), new SqlParameter("@ChanLinkMan", SqlDbType.NVarChar, 50), new SqlParameter("@ChanLinkTel", SqlDbType.VarChar, 50), new SqlParameter("@ChanTitle", SqlDbType.NVarChar, 500), new SqlParameter("@ChanDesc", SqlDbType.NVarChar, 2000), new SqlParameter("@ChanCreateMan", SqlDbType.Int, 4), new SqlParameter("@ChanCreateDate", SqlDbType.DateTime), new SqlParameter("@ChanDueMan", SqlDbType.Int, 4), new SqlParameter("@ChanDueDate", SqlDbType.DateTime), new SqlParameter("@ChanState", SqlDbType.Int, 4), new SqlParameter("@ChanError", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.ChanName; parameters[1].Value = model.ChanRate; parameters[2].Value = model.ChanLinkMan; parameters[3].Value = model.ChanLinkTel; parameters[4].Value = model.ChanTitle; parameters[5].Value = model.ChanDesc; parameters[6].Value = model.ChanCreateMan; parameters[7].Value = model.ChanCreateDate; parameters[8].Value = model.ChanDueMan; parameters[9].Value = model.ChanDueDate; parameters[10].Value = model.ChanState; parameters[11].Value = model.ChanError; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Chances GetModel(int ChanID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ChanID,ChanName,ChanRate,ChanLinkMan,ChanLinkTel,ChanTitle,ChanDesc,ChanCreateMan,ChanCreateDate,ChanDueMan,ChanDueDate,ChanState,ChanError from Chances "); strSql.Append(" where ChanID=@ChanID"); SqlParameter[] parameters = { new SqlParameter("@ChanID", SqlDbType.Int, 4) }; parameters[0].Value = ChanID; Maticsoft.Model.Chances model = new Maticsoft.Model.Chances(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }