public ADlaunchInfo GetAllDlaunchInfoById(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 advertiserID,BID,positionID,Stardate,enddate,Givindate,addoc,Addates,salesman,LoginName,countID from ADlaunchInfo ");
strSql.Append(" where advertiserID=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
ADlaunchInfo model = new ADlaunchInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["advertiserID"].ToString() != "")
{
model.advertiserID = int.Parse(ds.Tables[0].Rows[0]["advertiserID"].ToString());
}
if (ds.Tables[0].Rows[0]["BID"].ToString() != "")
{
model.BID = int.Parse(ds.Tables[0].Rows[0]["BID"].ToString());
}
if (ds.Tables[0].Rows[0]["positionID"].ToString() != "")
{
model.positionID = int.Parse(ds.Tables[0].Rows[0]["positionID"].ToString());
}
if (ds.Tables[0].Rows[0]["Stardate"].ToString() != "")
{
model.Stardate = DateTime.Parse(ds.Tables[0].Rows[0]["Stardate"].ToString());
}
if (ds.Tables[0].Rows[0]["enddate"].ToString() != "")
{
model.enddate = DateTime.Parse(ds.Tables[0].Rows[0]["enddate"].ToString());
}
if (ds.Tables[0].Rows[0]["Givindate"].ToString() != "")
{
model.Givindate = DateTime.Parse(ds.Tables[0].Rows[0]["Givindate"].ToString());
}
model.addoc = ds.Tables[0].Rows[0]["addoc"].ToString();
if (ds.Tables[0].Rows[0]["Addates"].ToString() != "")
{
model.Addates = DateTime.Parse(ds.Tables[0].Rows[0]["Addates"].ToString());
}
model.salesman = ds.Tables[0].Rows[0]["salesman"].ToString();
model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString();
if (ds.Tables[0].Rows[0]["countID"].ToString() != "")
{
model.countID = int.Parse(ds.Tables[0].Rows[0]["countID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 显示信息绑定
/// </summary>
protected void Bind()
{
int id = Convert.ToInt32(Request.QueryString["infoID"]);
model = manager.GetAllDlaunchInfoById(id); //根据ID查询信息
txtDoc.Value = model.addoc.ToString(); //备注
txtenddate.Text = Convert.ToString(model.enddate); //结束日期
txtGivindate.Text = Convert.ToString(model.Givindate); //赠送日期
txtLoginName.Text = model.LoginName.ToString(); //广告主
txtsalesman.Text = model.salesman.ToString(); //业务员
txtStardate.Text = Convert.ToString(model.Stardate); //开始日期
txtCount.Text = Convert.ToString(model.countID.ToString());
}
public int UpdatechannelInfo(ADlaunchInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ADlaunchInfo set ");
//strSql.Append("BID=@BID,");
//strSql.Append("positionID=@positionID,");
strSql.Append("Stardate=@Stardate,");
strSql.Append("enddate=@enddate,");
strSql.Append("Givindate=@Givindate,");
strSql.Append("addoc=@addoc,");
//strSql.Append("Addates=@Addates,");
strSql.Append("salesman=@salesman,");
strSql.Append("LoginName=@LoginName,");
strSql.Append("countID=@countID");
strSql.Append(" where advertiserID=@advertiserID ");
SqlParameter[] parameters =
{
new SqlParameter("@advertiserID", SqlDbType.Int, 4),
//new SqlParameter("@BID", SqlDbType.Int,4),
//new SqlParameter("@positionID", SqlDbType.Int,4),
new SqlParameter("@Stardate", SqlDbType.DateTime, 50),
new SqlParameter("@enddate", SqlDbType.DateTime, 50),
new SqlParameter("@Givindate", SqlDbType.DateTime, 50),
new SqlParameter("@addoc", SqlDbType.NVarChar, 200),
//new SqlParameter("@Addates", SqlDbType.DateTime),
new SqlParameter("@salesman", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 50),
new SqlParameter("@countID", SqlDbType.Int, 4)
};
parameters[0].Value = model.advertiserID;
//parameters[1].Value = model.BID;
//parameters[2].Value = model.positionID;
parameters[1].Value = model.Stardate;
parameters[2].Value = model.enddate;
parameters[3].Value = model.Givindate;
parameters[4].Value = model.addoc;
//parameters[7].Value = model.Addates;
parameters[5].Value = model.salesman;
parameters[6].Value = model.LoginName;
parameters[7].Value = model.countID;
int num = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(num);
}
public int Add(ADlaunchInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ADlaunchInfo(");
strSql.Append("BID,positionID,Stardate,enddate,Givindate,addoc,Addates,salesman,LoginName,countID)");
strSql.Append(" values (");
strSql.Append("@BID,@positionID,@Stardate,@enddate,@Givindate,@addoc,@Addates,@salesman,@LoginName,@countID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BID", SqlDbType.Int, 4),
new SqlParameter("@positionID", SqlDbType.Int, 4),
new SqlParameter("@Stardate", SqlDbType.DateTime),
new SqlParameter("@enddate", SqlDbType.DateTime),
new SqlParameter("@Givindate", SqlDbType.DateTime),
new SqlParameter("@addoc", SqlDbType.NVarChar, 200),
new SqlParameter("@Addates", SqlDbType.DateTime),
new SqlParameter("@salesman", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 50),
new SqlParameter("@countID", SqlDbType.Int, 4)
};
parameters[0].Value = model.BID;
parameters[1].Value = model.positionID;
parameters[2].Value = model.Stardate;
parameters[3].Value = model.enddate;
parameters[4].Value = model.Givindate;
parameters[5].Value = model.addoc;
parameters[6].Value = model.Addates;
parameters[7].Value = model.salesman;
parameters[8].Value = model.LoginName;
parameters[9].Value = model.countID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
