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