public static string share(string ResourceToResourceFolder_Id)
{
Rc.Model.Resources.Model_F_User FloginUser = Rc.Common.StrUtility.clsUtility.IsFPageFlag() as Rc.Model.Resources.Model_F_User;
try
{
string strsql = "select distinct(SchoolId) from dbo.VW_UserOnClassGradeSchool where UserId='" + FloginUser.UserId + "' and SchoolId<>''";
DataTable dt = Rc.Common.DBUtility.DbHelperSQL.Query(strsql).Tables[0];
Model_ResourceShare rs = new Model_ResourceShare();
rs.ResourceShareId = Guid.NewGuid().ToString();
rs.ResourceToResourceFolder_Id = ResourceToResourceFolder_Id;
rs.ShareObjectId = dt.Rows.Count > 0 ? dt.Rows[0]["SchoolId"].ToString() : "";
rs.CreateUserId = FloginUser.UserId;
rs.CreateTime = DateTime.Now;
Model_ResourceToResourceFolder rtr = new Model_ResourceToResourceFolder();
BLL_ResourceToResourceFolder rtrbll = new BLL_ResourceToResourceFolder();
rtr = rtrbll.GetModel(ResourceToResourceFolder_Id);
rtr.Resource_shared = "1";
BLL_ResourceShare bllrs = new BLL_ResourceShare();
if (bllrs.ShareResource(rs, rtr))
{
return("1");
}
else
{
return("");
}
}
catch (Exception)
{
return("");
}
}
public bool Add(Model_ResourceShare model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ResourceShare(");
builder.Append("ResourceShareId,ResourceToResourceFolder_Id,ResourceShareType,ShareObjectId,Remark,CreateTime,CreateUserId)");
builder.Append(" values (");
builder.Append("@ResourceShareId,@ResourceToResourceFolder_Id,@ResourceShareType,@ShareObjectId,@Remark,@CreateTime,@CreateUserId)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceShareId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceShareType", SqlDbType.NVarChar, 30), new SqlParameter("@ShareObjectId", SqlDbType.VarChar, 0x24), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserId", SqlDbType.VarChar, 0x24) };
cmdParms[0].Value = model.ResourceShareId;
cmdParms[1].Value = model.ResourceToResourceFolder_Id;
cmdParms[2].Value = model.ResourceShareType;
cmdParms[3].Value = model.ShareObjectId;
cmdParms[4].Value = model.Remark;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.CreateUserId;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <Model_ResourceShare> DataTableToList(DataTable dt)
{
List <Model_ResourceShare> list = new List <Model_ResourceShare>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_ResourceShare item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Update(Model_ResourceShare model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ResourceShare set ");
builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,");
builder.Append("ResourceShareType=@ResourceShareType,");
builder.Append("ShareObjectId=@ShareObjectId,");
builder.Append("Remark=@Remark,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("CreateUserId=@CreateUserId");
builder.Append(" where ResourceShareId=@ResourceShareId ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceShareType", SqlDbType.NVarChar, 30), new SqlParameter("@ShareObjectId", SqlDbType.VarChar, 0x24), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceShareId", SqlDbType.VarChar, 0x24) };
cmdParms[0].Value = model.ResourceToResourceFolder_Id;
cmdParms[1].Value = model.ResourceShareType;
cmdParms[2].Value = model.ShareObjectId;
cmdParms[3].Value = model.Remark;
cmdParms[4].Value = model.CreateTime;
cmdParms[5].Value = model.CreateUserId;
cmdParms[6].Value = model.ResourceShareId;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_ResourceShare DataRowToModel(DataRow row)
{
Model_ResourceShare share = new Model_ResourceShare();
if (row != null)
{
if (row["ResourceShareId"] != null)
{
share.ResourceShareId = row["ResourceShareId"].ToString();
}
if (row["ResourceToResourceFolder_Id"] != null)
{
share.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString();
}
if (row["ResourceShareType"] != null)
{
share.ResourceShareType = row["ResourceShareType"].ToString();
}
if (row["ShareObjectId"] != null)
{
share.ShareObjectId = row["ShareObjectId"].ToString();
}
if (row["Remark"] != null)
{
share.Remark = row["Remark"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
share.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["CreateUserId"] != null)
{
share.CreateUserId = row["CreateUserId"].ToString();
}
}
return(share);
}
public bool ShareResource(Model_ResourceShare model, Model_ResourceToResourceFolder rtrmodel)
{
Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>();
StringBuilder builder = new StringBuilder();
builder = new StringBuilder();
builder.Append("insert into ResourceShare(");
builder.Append("ResourceShareId,ResourceToResourceFolder_Id,ResourceShareType,ShareObjectId,Remark,CreateTime,CreateUserId)");
builder.Append(" values (");
builder.Append("@ResourceShareId,@ResourceToResourceFolder_Id,@ResourceShareType,@ShareObjectId,@Remark,@CreateTime,@CreateUserId)");
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ResourceShareId", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.VarChar, 0x24), new SqlParameter("@ResourceShareType", SqlDbType.NVarChar, 30), new SqlParameter("@ShareObjectId", SqlDbType.VarChar, 0x24), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserId", SqlDbType.VarChar, 0x24) };
parameterArray[0].Value = model.ResourceShareId;
parameterArray[1].Value = model.ResourceToResourceFolder_Id;
parameterArray[2].Value = model.ResourceShareType;
parameterArray[3].Value = model.ShareObjectId;
parameterArray[4].Value = model.Remark;
parameterArray[5].Value = model.CreateTime;
parameterArray[6].Value = model.CreateUserId;
dictionary.Add(builder.ToString(), parameterArray);
builder = new StringBuilder();
builder.Append("update ResourceToResourceFolder set ");
builder.Append("ResourceFolder_Id=@ResourceFolder_Id,");
builder.Append("Resource_Id=@Resource_Id,");
builder.Append("File_Name=@File_Name,");
builder.Append("Resource_Type=@Resource_Type,");
builder.Append("Resource_Name=@Resource_Name,");
builder.Append("Resource_Class=@Resource_Class,");
builder.Append("Resource_Version=@Resource_Version,");
builder.Append("File_Owner=@File_Owner,");
builder.Append("CreateFUser=@CreateFUser,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("UpdateTime=@UpdateTime,");
builder.Append("File_Suffix=@File_Suffix,");
builder.Append("LessonPlan_Type=@LessonPlan_Type,");
builder.Append("GradeTerm=@GradeTerm,");
builder.Append("Subject=@Subject,");
builder.Append("Resource_Domain=@Resource_Domain,");
builder.Append("Resource_Url=@Resource_Url,");
builder.Append("Resource_shared=@Resource_shared,");
builder.Append("Book_ID=@Book_ID,");
builder.Append("ParticularYear=@ParticularYear,");
builder.Append("ResourceToResourceFolder_Order=@ResourceToResourceFolder_Order");
builder.Append(" where ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id ");
SqlParameter[] parameterArray2 = new SqlParameter[] {
new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Id", SqlDbType.Char, 0x24), new SqlParameter("@File_Name", SqlDbType.NVarChar, 250), new SqlParameter("@Resource_Type", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Name", SqlDbType.NVarChar, 250), new SqlParameter("@Resource_Class", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@File_Owner", SqlDbType.Char, 0x24), new SqlParameter("@CreateFUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@File_Suffix", SqlDbType.VarChar, 10), new SqlParameter("@LessonPlan_Type", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Domain", SqlDbType.NVarChar, 100),
new SqlParameter("@Resource_Url", SqlDbType.VarChar, 500), new SqlParameter("@Resource_shared", SqlDbType.VarChar, 10), new SqlParameter("@Book_ID", SqlDbType.Char, 0x24), new SqlParameter("@ParticularYear", SqlDbType.Int, 4), new SqlParameter("@ResourceToResourceFolder_Order", SqlDbType.Int, 4), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24)
};
parameterArray2[0].Value = rtrmodel.ResourceFolder_Id;
parameterArray2[1].Value = rtrmodel.Resource_Id;
parameterArray2[2].Value = rtrmodel.File_Name;
parameterArray2[3].Value = rtrmodel.Resource_Type;
parameterArray2[4].Value = rtrmodel.Resource_Name;
parameterArray2[5].Value = rtrmodel.Resource_Class;
parameterArray2[6].Value = rtrmodel.Resource_Version;
parameterArray2[7].Value = rtrmodel.File_Owner;
parameterArray2[8].Value = rtrmodel.CreateFUser;
parameterArray2[9].Value = rtrmodel.CreateTime;
parameterArray2[10].Value = rtrmodel.UpdateTime;
parameterArray2[11].Value = rtrmodel.File_Suffix;
parameterArray2[12].Value = rtrmodel.LessonPlan_Type;
parameterArray2[13].Value = rtrmodel.GradeTerm;
parameterArray2[14].Value = rtrmodel.Subject;
parameterArray2[15].Value = rtrmodel.Resource_Domain;
parameterArray2[0x10].Value = rtrmodel.Resource_Url;
parameterArray2[0x11].Value = rtrmodel.Resource_shared;
parameterArray2[0x12].Value = rtrmodel.Book_ID;
parameterArray2[0x13].Value = rtrmodel.ParticularYear;
parameterArray2[20].Value = rtrmodel.ResourceToResourceFolder_Order;
parameterArray2[0x15].Value = rtrmodel.ResourceToResourceFolder_Id;
dictionary.Add(builder.ToString(), parameterArray2);
return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0);
}
public bool Add(Model_ResourceShare model)
{
return(this.dal.Add(model));
}
public bool Update(Model_ResourceShare model)
{
return(this.dal.Update(model));
}
public bool ShareResource(Model_ResourceShare model, Model_ResourceToResourceFolder rtrmodel)
{
return(this.dal.ShareResource(model, rtrmodel));
}
