/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.video DataRowToModel(DataRow row)
{
la.Model.video model=new la.Model.video();
if (row != null)
{
if(row["video_ID"]!=null && row["video_ID"].ToString()!="")
{
model.video_ID=int.Parse(row["video_ID"].ToString());
}
if(row["user_telphone"]!=null)
{
model.user_telphone=row["user_telphone"].ToString();
}
if(row["video_url"]!=null)
{
model.video_url=row["video_url"].ToString();
}
if(row["video_uploadtime"]!=null && row["video_uploadtime"].ToString()!="")
{
model.video_uploadtime=DateTime.Parse(row["video_uploadtime"].ToString());
}
if(row["video_comment"]!=null)
{
model.video_comment=row["video_comment"].ToString();
}
if(row["video_state"]!=null)
{
model.video_state=row["video_state"].ToString();
}
}
return model;
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtvideo_ID.Text))
{
strErr+="视频ID格式错误！\\n";
}
if(this.txtuser_telphone.Text.Trim().Length==0)
{
strErr+="用户Phone不能为空！\\n";
}
if(this.txtvideo_url.Text.Trim().Length==0)
{
strErr+="视频路径不能为空！\\n";
}
if(!PageValidate.IsDateTime(txtvideo_uploadtime.Text))
{
strErr+="视频上传时间格式错误！\\n";
}
if(this.txtvideo_comment.Text.Trim().Length==0)
{
strErr+="视频说明不能为空！\\n";
}
if(this.txtvideo_state.Text.Trim().Length==0)
{
strErr+="视频审核状态不能为空！\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int video_ID=int.Parse(this.txtvideo_ID.Text);
string user_telphone=this.txtuser_telphone.Text;
string video_url=this.txtvideo_url.Text;
DateTime video_uploadtime=DateTime.Parse(this.txtvideo_uploadtime.Text);
string video_comment=this.txtvideo_comment.Text;
string video_state=this.txtvideo_state.Text;
la.Model.video model=new la.Model.video();
model.video_ID=video_ID;
model.user_telphone=user_telphone;
model.video_url=video_url;
model.video_uploadtime=video_uploadtime;
model.video_comment=video_comment;
model.video_state=video_state;
la.BLL.video bll=new la.BLL.video();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功！","add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.video GetModel(int video_ID,string user_telphone)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 video_ID,user_telphone,video_url,video_uploadtime,video_comment,video_state from video ");
strSql.Append(" where video_ID=@video_ID and user_telphone=@user_telphone ");
SqlParameter[] parameters = {
new SqlParameter("@video_ID", SqlDbType.Int,4),
new SqlParameter("@user_telphone", SqlDbType.VarChar,20) };
parameters[0].Value = video_ID;
parameters[1].Value = user_telphone;
la.Model.video model=new la.Model.video();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 获取最后一条语音信息。
/// </summary>
/// <param name="tel"></param>
/// <returns></returns>
public Model.video getLastVideo(string tel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 video_ID,user_telphone,video_url,video_uploadtime,video_comment,video_state from video");
strSql.Append(" where user_telphone=@user_telphone order by video_uploadtime desc ");
SqlParameter[] parameters = { new SqlParameter("@user_telphone", SqlDbType.VarChar, 20) };
parameters[0].Value = tel;
la.Model.video ad = new la.Model.video();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
