/// <summary>
/// 根据编号查看广告定制
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public CompanyMadeModel SelGetMade(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MadeID,CompanyID,Price,SumPrice,UserName,CreateDate,BeginTime,EndTime,LinkName,TelPhone,Email,Audit,AuditName,Hit,VisitHit from CompanyMadeTab ");
strSql.Append(" where MadeID=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CompanyMadeModel model = new CompanyMadeModel();
DataSet ds = crm.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["MadeID"].ToString() != "")
{
model.MadeID = int.Parse(ds.Tables[0].Rows[0]["MadeID"].ToString());
}
model.CompanyID = ds.Tables[0].Rows[0]["CompanyID"].ToString();
model.Price = ds.Tables[0].Rows[0]["Price"].ToString();
model.SumPrice = ds.Tables[0].Rows[0]["SumPrice"].ToString();
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["BeginTime"].ToString() != "")
{
model.BeginTime = DateTime.Parse(ds.Tables[0].Rows[0]["BeginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
}
model.LinkName = ds.Tables[0].Rows[0]["LinkName"].ToString();
model.TelPhone = ds.Tables[0].Rows[0]["TelPhone"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["Audit"].ToString() != "")
{
model.Audit = int.Parse(ds.Tables[0].Rows[0]["Audit"].ToString());
}
model.AuditName = ds.Tables[0].Rows[0]["AuditName"].ToString();
if (ds.Tables[0].Rows[0]["Hit"].ToString() != "")
{
model.Hit = int.Parse(ds.Tables[0].Rows[0]["Hit"].ToString());
}
if (ds.Tables[0].Rows[0]["VisitHit"].ToString() != "")
{
model.VisitHit = int.Parse(ds.Tables[0].Rows[0]["VisitHit"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="id"></param>
/// <returns></returns>
public int UpdateMade(CompanyMadeModel model, int id)
{
return(dal.UpdateMade(model, id));
}
/// <summary>
/// 广告定制修改
/// </summary>
/// <param name="model"></param>
/// <param name="id"></param>
/// <returns></returns>
public int UpdateMade(CompanyMadeModel model, int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CompanyMadeTab set ");
//strSql.Append("CompanyID=@CompanyID,");
//strSql.Append("Price=@Price,");
strSql.Append("SumPrice=@SumPrice,");
//strSql.Append("UserName=@UserName,");
//strSql.Append("CreateDate=@CreateDate,");
strSql.Append("BeginTime=@BeginTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("LinkName=@LinkName,");
strSql.Append("TelPhone=@TelPhone,");
strSql.Append("Email=@Email,");
strSql.Append("Audit=@Audit,");
strSql.Append("AuditName=@AuditName,");
strSql.Append("Remark=@Remark ");
//strSql.Append("Hit=@Hit,");
//strSql.Append("VisitHit=@VisitHit");
strSql.Append(" where MadeID=@MadeID ");
SqlParameter[] parameters =
{
new SqlParameter("@MadeID", SqlDbType.Int, 4),
//new SqlParameter("@CompanyID", SqlDbType.VarChar,50),
//new SqlParameter("@Price", SqlDbType.VarChar,100),
new SqlParameter("@SumPrice", SqlDbType.VarChar, 50),
//new SqlParameter("@UserName", SqlDbType.VarChar,50),
//new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@TelPhone", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Audit", SqlDbType.Int, 4),
new SqlParameter("@AuditName", SqlDbType.VarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 4000)
//new SqlParameter("@Hit", SqlDbType.Int,4),
//new SqlParameter("@VisitHit", SqlDbType.Int,4)
};
model.MadeID = id;
parameters[0].Value = model.MadeID;
//parameters[1].Value = model.CompanyID;
//parameters[2].Value = model.Price;
parameters[1].Value = model.SumPrice;
//parameters[4].Value = model.UserName;
//parameters[5].Value = model.CreateDate;
parameters[2].Value = model.BeginTime;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.LinkName;
parameters[5].Value = model.TelPhone;
parameters[6].Value = model.Email;
parameters[7].Value = model.Audit;
parameters[8].Value = model.AuditName;
parameters[9].Value = model.Remark;
//parameters[13].Value = model.Hit;
//parameters[14].Value = model.VisitHit;
int num = Convert.ToInt32(crm.GetSingle(strSql.ToString(), parameters));
return(num);
}
