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);
}
