public int Update(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "UPDATE DocumentsReadUsers SET \r\n\t\t\t\tIsRead=:IsRead\r\n\t\t\t\tWHERE DocumentID=:DocumentID and UserID=:UserID";
OracleParameter[] oracleParameterArray = new OracleParameter[3];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":IsRead", OracleDbType.Int32);
oracleParameter1.Value = (object)model.IsRead;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":DocumentID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.DocumentID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":UserID", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.UserID;
oracleParameterArray[index3] = oracleParameter3;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "UPDATE DocumentsReadUsers SET \r\n\t\t\t\tIsRead=@IsRead\r\n\t\t\t\tWHERE DocumentID=@DocumentID and UserID=@UserID";
SqlParameter[] sqlParameterArray = new SqlParameter[3];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@IsRead", SqlDbType.Int, -1);
sqlParameter1.Value = (object)model.IsRead;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@DocumentID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.DocumentID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter3.Value = (object)model.UserID;
sqlParameterArray[index3] = sqlParameter3;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "INSERT INTO DocumentsReadUsers\r\n\t\t\t\t(DocumentID,UserID,IsRead) \r\n\t\t\t\tVALUES(:DocumentID,:UserID,:IsRead)";
OracleParameter[] oracleParameterArray = new OracleParameter[3];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":DocumentID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.DocumentID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":UserID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.UserID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":IsRead", OracleDbType.Int32);
oracleParameter3.Value = (object)model.IsRead;
oracleParameterArray[index3] = oracleParameter3;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "INSERT INTO DocumentsReadUsers\r\n\t\t\t\t(DocumentID,UserID,IsRead) \r\n\t\t\t\tVALUES(@DocumentID,@UserID,@IsRead)";
SqlParameter[] sqlParameterArray = new SqlParameter[3];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@DocumentID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.DocumentID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.UserID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@IsRead", SqlDbType.Int, -1);
sqlParameter3.Value = (object)model.IsRead;
sqlParameterArray[index3] = sqlParameter3;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "UPDATE documentsreadusers SET \r\n\t\t\t\tIsRead=@IsRead\r\n\t\t\t\tWHERE DocumentID=@DocumentID and UserID=@UserID";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[3];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@IsRead", MySqlDbType.Int32, 11);
mySqlParameter1.Value = (object)model.IsRead;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@DocumentID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.DocumentID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36);
mySqlParameter3.Value = (object)model.UserID;
mySqlParameterArray[index3] = mySqlParameter3;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.DocumentsReadUsers model)
{
string sql = "INSERT INTO documentsreadusers\r\n\t\t\t\t(DocumentID,UserID,IsRead) \r\n\t\t\t\tVALUES(@DocumentID,@UserID,@IsRead)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[3];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@DocumentID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.DocumentID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.UserID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@IsRead", MySqlDbType.Int32, 11);
mySqlParameter3.Value = (object)model.IsRead;
mySqlParameterArray[index3] = mySqlParameter3;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string Title1 = this.Title1.Value;
string ReadUsers = Request.Form["ReadUsers"];
string Contents = Request.Form["Contents"];
string Files = Request.Form["Files"];
string Source = Request.Form["Source"];
bool isAdd = false;
string oldxml = string.Empty;
if (doc == null)
{
doc = new RoadFlow.Data.Model.Documents();
isAdd = true;
doc.ID = Guid.NewGuid();
doc.ReadCount = 0;
doc.WriteTime = RoadFlow.Utility.DateTimeNew.Now;
doc.WriteUserID = CurrentUserID;
doc.WriteUserName = CurrentUserName;
}
else
{
oldxml = doc.Serialize();
doc.EditTime = RoadFlow.Utility.DateTimeNew.Now;
doc.EditUserID = CurrentUserID;
doc.EditUserName = CurrentUserName;
}
doc.Contents = Contents;
doc.DirectoryID = DirID.ToGuid();
doc.Source = Source;
doc.Files = Files;
doc.ReadUsers = ReadUsers;
doc.Title = Title1.Trim1();
doc.DirectoryName = DocDir.GetName(doc.DirectoryID);
if (isAdd)
{
DOC.Add(doc);
RoadFlow.Platform.Log.Add("添加了文档", doc.Serialize(), RoadFlow.Platform.Log.Types.文档中心);
}
else
{
DOC.Update(doc);
RoadFlow.Platform.Log.Add("修改了文档", doc.Serialize(), RoadFlow.Platform.Log.Types.文档中心, oldxml, doc.Serialize());
}
//更新阅读人员
var users = doc.ReadUsers.IsNullOrEmpty() ? DocDir.GetReadUsers(doc.DirectoryID) : new RoadFlow.Platform.Organize().GetAllUsers(doc.ReadUsers);
DocReadUsers.Delete(doc.ID);
bool isWeiXin = RoadFlow.Platform.WeiXin.Config.IsUse;
RoadFlow.Platform.WeiXin.Message weiXinMsg = new RoadFlow.Platform.WeiXin.Message();
System.Text.StringBuilder wxUsers = new System.Text.StringBuilder();
foreach (var user in users)
{
RoadFlow.Data.Model.DocumentsReadUsers docReadUsers = new RoadFlow.Data.Model.DocumentsReadUsers();
docReadUsers.DocumentID = doc.ID;
docReadUsers.IsRead = 0;
docReadUsers.UserID = user.ID;
DocReadUsers.Add(docReadUsers);
if (isWeiXin)
{
wxUsers.Append(user.Account);
wxUsers.Append('|');
}
}
if (isWeiXin)
{
weiXinMsg.SendText(doc.Title, wxUsers.ToString().TrimEnd('|'), agentid: new RoadFlow.Platform.WeiXin.Agents().GetAgentIDByCode("weixinagents_documents"), async: true);
}
string url = string.Empty;
if (isAdd)
{
url = "'List.aspx" + Request.Url.Query + "'";
}
else
{
url = "'DocRead.aspx" + Request.Url.Query + "'";
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!');window.location=" + url + ";", true);
}
public int Update(RoadFlow.Data.Model.DocumentsReadUsers model)
{
return(this.dataDocumentsReadUsers.Update(model));
}
public int Add(RoadFlow.Data.Model.DocumentsReadUsers model)
{
return(this.dataDocumentsReadUsers.Add(model));
}
