public List <ActivityDetail> GetActivityDetails(int act_id)
{
List <ActivityDetail> activityDetails = new List <ActivityDetail>();
string sql = "select * from activity where act_id='" + act_id + "'" + " and status = 1";
var row = _theDataSource.SelectOne(sql);
string material = row["material"].ToString();
List <MWMaterial> mWMaterials = (List <MWMaterial>)DaoUtil.ConvertMaterialJson(material);
for (int i = 0; i < mWMaterials.Count; i++)
{
MWMaterial data = mWMaterials[i];
//Debug.Log(data[i]["cuteffect_id"]);
ActivityDetail activityDetail = new ActivityDetail();
if (data.type == "video")
{
activityDetail.Type = 1;
activityDetail.Image = data.cover;
activityDetail.VideoUrl = data.path;
}
else if (data.type == "image")
{
activityDetail.Type = 0;
activityDetail.Image = data.path;
}
activityDetail.Description = data.description;
activityDetails.Add(activityDetail);
}
return(activityDetails);
}
public List <Video> GetVideosByEnvId(int envId)
{
List <Video> videos = new List <Video>();
string sql = "select video from company where com_id=" + envId + " and status = 1";
//Debug.Log("GetVideosByEnvId : " + sql);
var row = _theDataSource.SelectOne(sql);
if (row != null)
{
string material = row["video"].ToString();
object mWMaterialsObj = DaoUtil.ConvertMaterialJson(material);
if (mWMaterialsObj != null)
{
List <MWMaterial> mWMaterials = (List <MWMaterial>)mWMaterialsObj;
for (int i = 0; i < mWMaterials.Count; i++)
{
MWMaterial data = mWMaterials[i];
//Debug.Log(data[i]["cuteffect_id"]);
Video video = new Video();
video.V_id = i;
if (data.type == "video")
{
video.Cover = data.cover;
video.Address = data.path;
}
video.Description = data.description;
videos.Add(video);
}
}
}
return(videos);
}
public List <ProductDetail> GetProductDetails(int pro_id)
{
List <ProductDetail> productDetails = new List <ProductDetail>();
string sql = "select * from product where prod_id=" + pro_id;
var row = _theDataSource.SelectOne(sql);
if (row != null)
{
string material = row["material"].ToString();
List <MWMaterial> mWMaterials = (List <MWMaterial>)DaoUtil.ConvertMaterialJson(material);
for (int i = 0; i < mWMaterials.Count; i++)
{
MWMaterial data = mWMaterials[i];
//Debug.Log(data[i]["cuteffect_id"]);
ProductDetail productDetail = new ProductDetail();
if (data.type == "video")
{
productDetail.Type = 1;
productDetail.Image = data.cover;
productDetail.VideoUrl = data.path;
}
else if (data.type == "image")
{
productDetail.Type = 0;
productDetail.Image = data.path;
}
productDetail.Description = data.description;
productDetails.Add(productDetail);
}
}
return(productDetails);
}
