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