/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.MessageToObject DataRowToModel(DataRow row)
{
Model.MessageToObject model = new Model.MessageToObject();
if (row != null)
{
if (row["AutoID"] != null && row["AutoID"].ToString() != "")
{
model.AutoID = long.Parse(row["AutoID"].ToString());
}
if (row["MsgID"] != null && row["MsgID"].ToString() != "")
{
model.MsgID = long.Parse(row["MsgID"].ToString());
}
if (row["ObjType"] != null)
{
model.ObjType = row["ObjType"].ToString();
}
if (row["ObjValue"] != null)
{
model.ObjValue = row["ObjValue"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.MessageToObject GetModel(long AutoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AutoID,MsgID,ObjType,ObjValue from MessageToObject");
strSql.Append(" where AutoID=@AutoID limit 1");
MySqlParameter[] parameters = {
new MySqlParameter("@AutoID", MySqlDbType.Int64) };
parameters[0].Value = AutoID;
Model.MessageToObject model = new Model.MessageToObject();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
protected void RbtnSubmit_Click(object sender, EventArgs e)
{
string msgType = RCB_Type.SelectedValue;
string closeBy = "";
if (msgType.Equals("Popup"))
{
closeBy = RCB_DisType.SelectedValue;
}
else if (msgType.Equals("Roll"))
{
if (!RadButton2.Checked && RTB_RollTimes.Text.Trim().Equals(""))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('滚动次数不能为空！');", true);
return;
}
closeBy = RadButton2.Checked ? "-1" : RTB_RollTimes.Text;
}
if (RadDatePicker1.DbSelectedDate == null)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c", "OpenAlert('抱歉，有效期限不能为空！');", true);
return;
}
DateTime availableTime = (DateTime)RadDatePicker1.DbSelectedDate;
DateTime expiredTime = RadDatePicker2.DbSelectedDate==null? new DateTime(2050,12,31) : (DateTime)RadDatePicker2.DbSelectedDate;
string content = TabStrip1.SelectedTab.Value.Equals("2") ? (RadButton1.Checked ? CheckStr(ContentEditor.Content) : ContentEditor.Content) : ContentText.Text;
if (content.Trim().Equals(""))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，公告内容不能为空！');", true);
return;
}
RadTreeView regionTreeView = RadDropDownTree1.Controls[0] as RadTreeView;
if (!RadButton5.Checked && RadListBox1.CheckedItems.Count == 0 && regionTreeView.SelectedNodes.Count == 0 && RTB_SIM.Text.Trim().Equals(""))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，请设置对象发送条件！！');", true);
return;
}
if (!RadButton5.Checked && !RadButton3.Checked && !RadButton4.Checked)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，请选择对象条件关系！！');", true);
return;
}
Model.Message msgModel = new Model.Message();
msgModel.Contents = content;
msgModel.MessageType = msgType;
msgModel.DataType = TabStrip1.SelectedTab.Value.Equals("2") ? "DataType_Html" : "DataType_Text";
msgModel.AndOr = RadButton3.Checked;
msgModel.AvailableTime = availableTime;
msgModel.DisappearType = closeBy;
msgModel.ExpiredTime = expiredTime;
msgModel.IsValid = true;
msgModel.LastModifyTime = DateTime.Now;
msgModel.Memo = "";
msgModel.Orders = 0;
msgModel.Publisher = user.UserInfo.UserID;
long msgId = 0;
bool isAdd = false;
Model.Log logModel = new Model.Log();
try
{
logModel.OperationItem = "添加公告";
logModel.Operator = user.UserInfo.UserID;
logModel.OperationTime = DateTime.Now;
logModel.OperationDetail = "类型:"+msgType ;
msgId =msg.Add(msgModel);
if (msgId > 0)
{
if (RadButton5.Checked)
{
Model.MessageToObject mtoModel = new Model.MessageToObject();
mtoModel.MsgID = msgId;
mtoModel.ObjType = "2";
mtoModel.ObjValue = "";
isAdd = mto.Add(mtoModel);
}
else
{
//身份
isAdd = true;
foreach (RadListBoxItem rbi in RadListBox1.CheckedItems)
{
isAdd = false;
Model.MessageToObject mtoModel = new Model.MessageToObject();
mtoModel.MsgID = msgId;
mtoModel.ObjType = "0";
mtoModel.ObjValue = rbi.Value;
isAdd = mto.Add(mtoModel);
if (!isAdd)
{
break;
}
}
//区域
if (isAdd)
{
isAdd = true;
if (!regionTreeView.SelectedValue.Equals("Area_Jfs"))
{
isAdd = false;
Model.MessageToObject mtoModel = new Model.MessageToObject();
mtoModel.MsgID = msgId;
mtoModel.ObjType = "0";
mtoModel.ObjValue = regionTreeView.SelectedValue;
isAdd = mto.Add(mtoModel);
}
}
//用户
if (isAdd)
{
isAdd = true;
if (RTB_SIM.Text.Trim() != "")
{
string[] SimNoArr = RTB_SIM.Text.Split(',');
foreach (string simNo in SimNoArr)
{
if (!simNo.Trim().Equals(""))
{
isAdd = false;
Model.MessageToObject mtoModel = new Model.MessageToObject();
mtoModel.MsgID = msgId;
mtoModel.ObjType = "1";
mtoModel.ObjValue = simNo.Trim();
isAdd = mto.Add(mtoModel);
if (!isAdd)
{
break;
}
}
}
}
}
}
}
if (msgId != 0 && isAdd)
{
logModel.Memo = "成功";
}
else
{
logModel.Memo = "失败！";
}
}
catch (Exception ex)
{
logModel.Memo = "异常：" + ex.Message;
}
finally
{
log.Add(logModel);
if (msgId != 0 && isAdd)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c", "OpenAlert('恭喜！编辑成功！');", true);
}
else
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！编辑失败！');", true);
}
}
}
