/// <summary>
/// 获取项目资料列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-13</remarks>
public DataTable GetList(E_Material data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@MaterialType", SqlDbType.TinyInt),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int),
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = (int)data.MaterialType;
parms[2].Value = data.Page.PageIndex;
parms[3].Value = data.Page.PageSize;
parms[4].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_MaterialS_ListSelect", parms);
data.Page.TotalCount = Convert.ToInt32(parms[4].Value == DBNull.Value?0:parms[4].Value);
return(dt);
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind()
{
E_Material data = new E_Material();
data.MaterialType = EnumMaterialType.项目资料;
data.EnterpriseID = EnterpriceID;
//分页参数
data.Page = new MLMGC.DataEntity.E_Page();
data.Page.PageSize = pageSize;
data.Page.PageIndex = pageIndex;
rpList.DataSource = new T_Material().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
//加载文件基本信息
int id = Requests.GetQueryInt("id", 0);
E_Material data = new E_Material();
data.MaterialID = id;
data.EnterpriseID = EnterpriceID;
data = new T_Material().GetModel(data);
txtCaption.Text = data.MaterialName;
hlUrl.Text = data.FileName;
hlUrl.NavigateUrl = MLMGC.COMP.Config.GetEnterpriseStudyUrl(EnterpriceID, data.Url);
//用隐藏域存储附件信息
hfFile.Value = string.Format("{0}|{1}|{2}|{3}", data.FileName, data.FileType, data.FileSize, data.Url);
//验证要共享的文件是否存在，若存在则不能共享
bool flag = new T_WenKu().Exists(new E_WenKu()
{
FileName = data.FileName
});
if (flag)
{
Jscript.AlertAndRedirect(this, "该文档已存在无法共享", "../Material/StudyMaterialList.aspx");
return;
}
//获取文库目录分类
DataTable dt = new T_WenKuClass().GetList();
if (dt == null)
{
return;
}
foreach (DataRow row in dt.Rows)
{
ddlCategory.Items.Add(new ListItem(row["WenKuClassName"].ToString(), row["WenKuClassID"].ToString()));
}
//绑定目录分类
ddlCategory.Items.Add(new ListItem("其它", "0"));
}
/// <summary>
/// 删除项目资料
/// </summary>
/// <param name="materialID"></param>
protected void Delete(long materialID)
{
E_Material data = new E_Material();
data.MaterialID = materialID;
data.EnterpriseID = EnterpriceID;
bool flag = new T_Material().Delete(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "删除项目资料", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
//MLMGC.COMP.Jscript.AlertAndRedirect(this, "删除成功", "MaterialList.aspx");
MLMGC.COMP.Jscript.ShowMsg("删除成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("删除失败", this);
}
}
/// <summary>
/// 得到一个项目资料对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-13</remarks>
public E_Material GetModel(E_Material data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@MaterialID", SqlDbType.Int),
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.MaterialID;
parms[1].Value = data.EnterpriseID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_MaterialS_Select", parms);
if (dt != null && dt.Rows.Count == 1)
{
data.MaterialName = dt.Rows[0]["MaterialName"].ToString();
data.ClassName = dt.Rows[0]["ClassName"].ToString();
data.FileName = dt.Rows[0]["FileName"].ToString();
data.Url = dt.Rows[0]["Url"].ToString();
data.FileType = dt.Rows[0]["FileType"].ToString();
data.FileSize = Convert.ToInt32(dt.Rows[0]["FileSize"]);
return(data);
}
return(null);
}
/// <summary>
/// 企业资料共享
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-03-16</remarks>
public bool Share(E_Material data)
{
return(dal.Share(data));
}
/// <summary>
/// 得到项目资料列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetList(E_Material data)
{
return(dal.GetList(data));
}
/// <summary>
/// 得到项目资料对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public E_Material GetModel(E_Material data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 删除项目资料
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Delete(E_Material data)
{
return(dal.Delete(data));
}
/// <summary>
/// 更新项目资料
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Update(E_Material data)
{
return(dal.Update(data));
}
/// <summary>
/// 增加项目资料
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Add(E_Material data)
{
return(dal.Add(data));
}
/// <summary>
/// 点击上传按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string caption = txtCaption.Text.Trim();
string intro = txtIntro.Text.Trim();
string keyword = txtKeyword.Text.Trim();
string custom = txtCustom.Text.Trim();
int value = Convert.ToInt32(ddlCategory.SelectedValue);
if (string.IsNullOrEmpty(caption))
{
Jscript.ShowMsg("请输入标题", this);
return;
}
if (value == -1 && string.IsNullOrWhiteSpace(custom))
{
Jscript.ShowMsg("请输入自定义分类", this);
return;
}
//获取附件基本信息
string attach = hfFile.Value;
string[] arr = attach.Split('|');
if (arr.Length == 0)
{
return;
}
if (Convert.ToInt64(arr[2]) > sizelimit)
{
Jscript.ShowMsg("文件过大无法共享！", this);
return;
}
//1.-------拷贝对象资料到WenKu目录-------
//原文件的物理路径
string filepath = MLMGC.COMP.Config.GetEnterpriseS(EnterpriceID, arr[3]);
if (File.Exists(filepath))
{
//目标文件的物理路径
string destpath = MLMGC.COMP.Config.GetWenKu(arr[3]);
File.Copy(filepath, destpath, true);//拷贝原文件
}
//-----------------------------------
//2.----------插入WenKu数据------------
E_WenKu data = new E_WenKu();
data.EnterpriseID = EnterpriceID;
data.UserID = 0;
data.Caption = caption;
data.Intro = intro;
data.Keywords = keyword;
data.WenKuClassID = value;
data.CustomClassName = custom;
data.UserType = MLMGC.DataEntity.User.UserType.企业用户;
data.FileName = arr[0];
data.SetFileType2 = arr[1];
data.FileSize = Convert.ToInt32(arr[2]);
data.FileUrl = arr[3];
data.StatusFlag = EnumStatusFlag.待审核;
bool flag = new T_WenKu().Add(data);
//--------------------------------------------
if (flag) //如果成功则继续
{
//3.-------------修改数据库，标识该资料已被共享------------------
E_Material dataM = new E_Material();
dataM.EnterpriseID = EnterpriceID;
dataM.MaterialID = Requests.GetQueryInt("id", 0);
dataM.WenKuFlag = EnumWenKuFlag.待审核;
dataM.WenKuID = data.WenKuID;
flag = new T_Material().Share(dataM);
//-------------------------------------------------------------
//4.--------------------修改监控文件 生成swf文件-------------------
//转换文档为swf
System.IO.FileStream fs = new System.IO.FileStream(MLMGC.COMP.Config.MonitorFilePath + data.WenKuID.ToString() + ".txt", System.IO.FileMode.Create, System.IO.FileAccess.Write);
System.IO.StreamWriter sw = new System.IO.StreamWriter(fs);
sw.WriteLine(string.Format("\r\n{0}|{1}", data.WenKuID, arr[3]));
sw.Close();
fs.Close();
//----------------------------------------------------
}
if (flag)
{
Jscript.AlertAndRedirect(this, "共享成功", "/enterprise/material/studymateriallist.aspx");
}
else
{
Jscript.ShowMsg("共享失败", this);
}
}
/// <summary>
/// 点击确定处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//判断是否输入标题和分类
if (txtMaterialName.Text == "" && txtClassName.Text == "")
{
MLMGC.COMP.Jscript.ShowMsg("请输入标题和分类", this);
return;
}
else if (txtMaterialName.Text == "")
{
MLMGC.COMP.Jscript.ShowMsg("请输入标题", this);
return;
}
else if (txtClassName.Text == "")
{
MLMGC.COMP.Jscript.ShowMsg("请输入分类", this);
return;
}
//上传文件
List <PFileInfo> list = FileUpload1.Upload();
if (list == null || list.Count == 0)
{
MLMGC.COMP.Jscript.ShowMsg("上传文件失败", this);
return;
}
//----------------文件上传成功 生成txt文本 进行文件类型转换---------------
//----------------------------------------------------------------------
//----封装对象----
E_Material data = new E_Material();
data.MaterialType = EnumMaterialType.项目资料;
data.EnterpriseID = EnterpriceID;
data.MaterialName = txtMaterialName.Text;
data.ClassName = txtClassName.Text;
data.FileName = list[0].FileName;
data.FileType = list[0].FileType;
data.FileSize = Convert.ToInt32(list[0].FileSize);
data.Url = list[0].FileAddress;
//判断是添加还是修改
if (type == "add")
{
bool flag = new T_Material().Add(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "添加项目资料", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "MaterialList.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("添加失败", this);
}
}
else
{
//获取项目资料编号
long materialID = MLMGC.COMP.Requests.GetQueryLong("materialid", 0);
data.MaterialID = materialID;
bool flag = new T_Material().Update(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改项目资料", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "MaterialList.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("修改失败", this);
}
}
}
protected void databind()
{
string type = Requests.GetQueryString("type");
string ids = Requests.GetQueryString("ids");
//显示邮件配置信息
E_MailConfig data = new T_MailConfig().GetConfig(new E_MailConfig()
{
EnterpriseID = base.EnterpriceID,
UserID = UserID
});
if (data == null)
{
//隐藏发送邮件信息
plSend.Visible = false;
return;
}
else
{
//隐藏配置信息
plConfig.Visible = false;
lbSendUser.Text = data.Name;
lbSendUser.ToolTip = "发送邮箱：" + data.Email;
}
//----------------读取邮件地址----------------
if (StringUtil.IsStringArrayList(ids))
{
DataTable dt = new T_ClientInfoHelper().SelectOperate(new E_ClientInfoHelper()
{
EnterpriseID = EnterpriceID, ClientInfoIDs = ids
});
List <string> listEmail = new List <string>();
List <string> listErr = new List <string>();
//--遍历取出邮箱地址
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["Email"].ToString()))
{
listEmail.Add(dr["Email"].ToString());
}
else
{
listErr.Add(dr["ClientName"].ToString());
}
}
txtReceiveEmail.Text = string.Join(",", listEmail.ToArray());
if (listErr.Count > 0)
{
lbErrClient.Text = "部分客户无邮箱地址无法发送邮件";// +string.Join(",", listErr);
}
}
//----------------显示项目资料信息----------------
E_Material dataM = new E_Material();
dataM.EnterpriseID = EnterpriceID;
dataM.Page = new MLMGC.DataEntity.E_Page();
dataM.Page.PageSize = 0;
dataM.Page.PageIndex = 1;
rpList.DataSource = new MLMGC.BLL.Enterprise.Material.T_Material().GetList(dataM);
rpList.DataBind();
}
