public bool Add(Tz888.Model.Info.InfoContactModel model) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Career", SqlDbType.VarChar, 20), new SqlParameter("@TelNum", SqlDbType.VarChar, 100), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@WebSite", SqlDbType.VarChar, 200), new SqlParameter("@Mobile", SqlDbType.VarChar, 30), new SqlParameter("@address", SqlDbType.VarChar, 100), new SqlParameter("@TelStateCode", SqlDbType.VarChar, 10) }; parameters[0].Value = model.InfoID; parameters[1].Value = model.OrganizationName; parameters[2].Value = model.Name; parameters[3].Value = model.Career; parameters[4].Value = model.TelNum; parameters[5].Value = model.Email; parameters[6].Value = model.WebSite; parameters[7].Value = model.Mobile; parameters[8].Value = model.Address; parameters[9].Value = model.TelStateCode; bool b = false; b = DbHelperSQL.RunProcLob("InfoContact", parameters); return(b); }
/// <summary> /// 统计信息完整度 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int CountInfoInte(Tz888.Model.Info.MerchantInfoModel model, Tz888.Model.Info.InfoContactModel model1) { int allScore = 82; //地方经济指标描述 if (model.EconomicIndicators.ToString().Length != 0) { allScore += 5; } //投资环境 if (model.InvestmentEnvironment.ToString().Length != 0) { allScore += 5; } //项目承办单位 //职位 if (model1.Position.ToString().Length != 0) { allScore += 4; } //联系地址 if (model1.Address.ToString().Length != 0) { allScore += 4; } return(allScore); }
/// <summary> /// 添加融资资源信息最新 /// </summary> public long InsertNew( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.ProjectInfoModel projectInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { return(dal.InsertNew(mainInfoModel, projectInfoModel, infoContactModel, infoResourceModels)); }
/// <summary> /// 获取信息资源的联系方式 /// </summary> /// <param name="InfoID">资源ID</param> /// <returns></returns> public Tz888.Model.Info.InfoContactModel GetModel(long InfoID) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8) }; parameters[0].Value = InfoID; Tz888.Model.Info.InfoContactModel model = new Tz888.Model.Info.InfoContactModel(); DataSet ds = DbHelperSQL.RunProcedure("InfoContactTab_GetModel", parameters, "ds"); model.InfoID = InfoID; if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ContactID"].ToString() != "") { model.ContactID = Convert.ToInt64(ds.Tables[0].Rows[0]["ContactID"]); } model.OrganizationName = ds.Tables[0].Rows[0]["OrganizationName"].ToString(); model.OrgIntro = ds.Tables[0].Rows[0]["OrgIntro"].ToString(); model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Career = ds.Tables[0].Rows[0]["Career"].ToString(); model.TelCountryCode = ds.Tables[0].Rows[0]["TelCountryCode"].ToString(); model.TelStateCode = ds.Tables[0].Rows[0]["TelStateCode"].ToString(); model.TelNum = ds.Tables[0].Rows[0]["TelNum"].ToString(); model.FaxCountryCode = ds.Tables[0].Rows[0]["FaxCountryCode"].ToString(); model.FaxStateCode = ds.Tables[0].Rows[0]["FaxStateCode"].ToString(); model.FaxNum = ds.Tables[0].Rows[0]["FaxNum"].ToString(); model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); model.WebSite = ds.Tables[0].Rows[0]["WebSite"].ToString(); model.Address = ds.Tables[0].Rows[0]["address"].ToString(); model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); model.PostCode = ds.Tables[0].Rows[0]["PostCode"].ToString(); //2010-06-11新增 model.Position = ds.Tables[0].Rows[0]["Position"].ToString(); //end if (ds.Tables[0].Rows[0]["IsDel"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsDel"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDel"].ToString().ToLower() == "true")) { model.IsDel = true; } else { model.IsDel = false; } } model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 招商信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="merchantInfoModel"></param> /// <param name="infoContactModel"></param> /// <param name="shortInfoModel"></param> /// <param name="infoContactManModels"></param> /// <param name="infoResourceModels"></param> /// <returns></returns> public long Insert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.MerchantInfoModel merchantInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, // List<Tz888.Model.Info.InfoContactManModel> infoContactManModels, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { return(dal.Insert(mainInfoModel, merchantInfoModel, infoContactModel, shortInfoModel, infoResourceModels)); }
/// <summary> /// 投资信息发布 /// </summary> /// <param name="mainInfoModel"></param> /// <param name="capitalInfoModel"></param> /// <param name="infoContactModel"></param> /// <param name="shortInfoModel"></param> /// <param name="capitalInfoAreaModels"></param> /// <param name="infoContactManModels"></param> /// <returns></returns> public long Insert( Tz888.Model.Info.MainInfoModel mainInfoModel, Tz888.Model.Info.V124.CapitalInfoModel capitalInfoModel, Tz888.Model.Info.InfoContactModel infoContactModel, Tz888.Model.Info.ShortInfoModel shortInfoModel, List <Tz888.Model.Info.CapitalInfoAreaModel> capitalInfoAreaModels, // List<Tz888.Model.Info.InfoContactManModel> infoContactManModelsm, List <Tz888.Model.Info.InfoResourceModel> infoResourceModels ) { // return dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoContactManModelsm,infoResourceModels); return(dal.Insert(mainInfoModel, capitalInfoModel, infoContactModel, shortInfoModel, capitalInfoAreaModels, infoResourceModels)); }
public bool Update(Tz888.Model.Info.InfoContactModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Career", SqlDbType.VarChar, 20), new SqlParameter("@TelCountryCode", SqlDbType.Char, 6), new SqlParameter("@TelStateCode", SqlDbType.Char, 8), new SqlParameter("@TelNum", SqlDbType.VarChar, 100), new SqlParameter("@FaxCountryCode", SqlDbType.Char, 6), new SqlParameter("@FaxStateCode", SqlDbType.Char, 8), new SqlParameter("@FaxNum", SqlDbType.VarChar, 100), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@WebSite", SqlDbType.VarChar, 200), new SqlParameter("@Mobile", SqlDbType.VarChar, 30), new SqlParameter("@address", SqlDbType.VarChar, 100), new SqlParameter("@PostCode", SqlDbType.VarChar, 10), new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100), new SqlParameter("@Position", SqlDbType.VarChar, 50) }; parameters[0].Value = model.InfoID; parameters[1].Value = model.Name; parameters[2].Value = model.Career; parameters[3].Value = model.TelCountryCode; parameters[4].Value = model.TelStateCode; parameters[5].Value = model.TelNum; parameters[6].Value = model.FaxCountryCode; parameters[7].Value = model.FaxStateCode; parameters[8].Value = model.FaxNum; parameters[9].Value = model.Email; parameters[10].Value = model.WebSite; parameters[11].Value = model.Mobile; parameters[12].Value = model.Address; parameters[13].Value = model.PostCode; parameters[14].Value = model.OrganizationName; parameters[15].Value = model.Position; DbHelperSQL.RunProcedure("InfoContactTab_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } return(false); }
//以下是插入数据 public bool InsertInformationIntegrity(Tz888.Model.Info.InfoContactModel model) { int score = 94; if (model.Position.ToString().Length != 0) { score += 2; } if (model.Address.ToString().Length != 0) { score += 2; } if (model.WebSite.ToString().Length != 0) { score += 2; } Tz888.Model.Info.V124.CapitalInfoModel model1 = new Tz888.Model.Info.V124.CapitalInfoModel(); model1.InfoID = model.InfoID; model1.InformationIntegrity = score; //信息的完整度 return(dal.UpdateInformationIntegrity(model1)); }
public bool Update(Tz888.Model.Info.InfoContactModel model) { return(dal.Update(model)); }
public bool Add(Tz888.Model.Info.InfoContactModel model) { return(dal.Add(model)); }