private static ShowPlanInfo GetShowPlanInfoByDataRow(DataRow row)
{
ShowPlanInfo info = new ShowPlanInfo();
info.SpID = Convert.ToInt32(row["spID"].ToString());
info.ShowPlan = (ShowPlan)ShowPlanService.GetShowPlanByPID(Convert.ToInt32(row["pID"].ToString()));
info.DeptInfo = (DeptInfo)DeptInfoService.GetDeptInfoByDID(Convert.ToInt32(row["dID"].ToString()));
info.SwfFile = (SwfFile)SwfFileService.GetSwfFileByFID(Convert.ToInt32(row["fID"].ToString()));
return info;
}
public static int AddShowPlanInfo(ShowPlanInfo showPlanInfo)
{
string sql = "INSERT INTO showPlanInfo(pID,dID,fID) values(@pID,@dID,@fID)";
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@pID",showPlanInfo.ShowPlan.PID),
new SqlParameter("@dID",showPlanInfo.DeptInfo.DID),
new SqlParameter("@fID",showPlanInfo.SwfFile.FID)
};
return DBHelper.GetScalar(sql,par);
}