public void CheckNewGroupMsg(string loginName) { DataSet ds = this.GetGroupMessage(loginName, false); if (ds == null && ds.Tables["ds"].Rows.Count == 0) { return; } for (int i = 0; i < ds.Tables["ds"].Rows.Count; i++) { string SendName = ds.Tables["ds"].Rows[i]["SendName"].ToString().Trim(); string Topic = ds.Tables["ds"].Rows[i]["Topic"].ToString().Trim(); string Context = ds.Tables["ds"].Rows[i]["Context"].ToString().Trim(); string CreateBy = ds.Tables["ds"].Rows[i]["CreateBy"].ToString().Trim(); int MessageID = Convert.ToInt32(ds.Tables["ds"].Rows[i]["MessageID"]); Tz888.Model.InnerInfo model = new Tz888.Model.InnerInfo(); model.SendName = SendName; model.ReceiveName = loginName; model.Topic = Topic; model.Context = Context; model.ChangeBy = CreateBy; this.SendInfoWithGroupCheck(model, MessageID); } }
public bool SaveInfoIDAL(Tz888.Model.InnerInfo model) { bool result = false; SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@ReceivedMan", SqlDbType.Char, 16), new SqlParameter("@Topic", SqlDbType.VarChar, 50), new SqlParameter("@Context", SqlDbType.VarChar, -1), new SqlParameter("@Size", SqlDbType.Int), // new SqlParameter("@IsReaded",SqlDbType.Int), new SqlParameter("@ChangeBy", SqlDbType.Char, 16), new SqlParameter("@SendID", SqlDbType.Int), }; parameters[0].Value = model.SendName.Trim(); parameters[1].Value = model.ReceiveName.Trim(); parameters[2].Value = model.Topic.Trim(); parameters[3].Value = model.Context.Trim(); parameters[4].Value = model.Topic.Length + model.Context.Length; // parameters[5].Value = 0; parameters[5].Value = model.ChangeBy; parameters[6].Value = 0; try { result = DbHelperSQL.RunProcLob("InnerInfoSendTabSave", parameters); } catch (Exception err) { throw err; } finally { } return(result); }
public Tz888.Model.InnerInfo GetInfoContext(int InfoId, int infoTable) { Tz888.Model.InnerInfo model = new Tz888.Model.InnerInfo(); DataTable dt = new DataTable(); string tableName = ""; string selectCondition = ""; string selectValue = ""; switch (infoTable) { case 0: //收件箱 tableName = "InnerInfoReceivedTab"; selectCondition = "ReceivedId=" + InfoId; dt = coon.GetList(tableName, "topic", "ReceivedId", 1, 1, 0, 1, selectCondition); selectValue = dt.Rows[0][0].ToString(); if ((selectValue != null) && (selectValue != "")) { model.Topic = selectValue; } dt = coon.GetList(tableName, "SendedMan", "ReceivedId", 1, 1, 0, 1, selectCondition); selectValue = dt.Rows[0][0].ToString(); if ((selectValue != null) && (selectValue != "")) { model.SendName = selectValue; } dt = coon.GetList(tableName, "ReceivedTime", "ReceivedId", 1, 1, 0, 1, selectCondition); model.InfoTime = (DateTime)dt.Rows[0][0]; dt = coon.GetList(tableName, "Context", "ReceivedId", 1, 1, 0, 1, selectCondition); selectValue = dt.Rows[0][0].ToString(); if ((selectValue != null) && (selectValue != "")) { model.Context = selectValue; } break; case 1: //发件箱 tableName = "InnerInfoSendTab"; selectCondition = "SendId=" + InfoId; dt = coon.GetList(tableName, "ReceivedMan,topic,Context", "ReceivedId", 1, 1, 0, 1, selectCondition); if ((dt != null) && (dt.Rows.Count != 0)) { model.ReceiveName = dt.Rows[0][0].ToString(); model.Topic = dt.Rows[0][1].ToString(); model.Context = dt.Rows[0][2].ToString(); } break; case 2: //垃圾箱信息 tableName = "InnerInfoWasterTab"; selectCondition = "wasterId=" + InfoId; dt = coon.GetList(tableName, "ReceivedMan,topic,Context,SendedMan", "wasterId", 1, 1, 0, 1, selectCondition); if ((dt != null) && (dt.Rows.Count != 0)) { model.ReceiveName = dt.Rows[0][0].ToString(); model.Topic = dt.Rows[0][1].ToString(); model.Context = dt.Rows[0][2].ToString(); model.SendName = dt.Rows[0][3].ToString(); } break; default: tableName = ""; break; } return(model); }