protected void IsNotice_CheckedChanged(object sender, EventArgs e)
{
var ccb = sender as ConfirmCheckBox;
if (ccb != null)
{
var item = ccb.Parent.Parent as GridDataItem;
if (item != null)
{
var noteId = new Guid(item.GetDataKeyValue("NoticeID").ToString());
var isNote = ccb.Checked;
try
{
var result = _shopActivityNotice.UpdateIsNotice(isNote, noteId);
if (result)
{
NoteGrid.Rebind();
}
}
catch
{
RAM.Alert("设置公告失败！");
}
}
}
}
//下
protected void DownOrderIndex(object sender, ImageClickEventArgs e)
{
var imageButton = (ImageButton)sender;
var item = (GridDataItem)imageButton.Parent.Parent;
var noticeID = new Guid(item.GetDataKeyValue("NoticeID").ToString());
int orderIndex = Convert.ToInt32(item.GetDataKeyValue("OrderIndex").ToString());
var result = _shopActivityNotice.UpdateOrderIndex(noticeID, orderIndex + 1);
if (result)
{
NoteGrid.Rebind();
}
else
{
RAM.Alert("操作无效！");
}
}
/// <summary>
/// Method to insert number on cell focus
/// </summary>
/// <param name="sender">The object that initiated the event.</param>
/// <param name="e">The event arguments for the event.</param>
private void InsertNumber(object sender, RoutedEventArgs e)
{
if (CheckBoxEnableNumber.IsChecked == true)
{
TextBox currentCell = sender as TextBox;
string selectedNumber = this.FindSelectedNumber();
if (!currentCell.Name.Contains("Note"))
{
currentCell.Text = selectedNumber;
}
else
{
string cellname = currentCell.Name;
string x = cellname.Substring(8, 1);
string y = cellname.Substring(9, 1);
string gamecellName = "Cell" + x + y;
TextBox gameCell = FindName(gamecellName) as TextBox;
if (string.IsNullOrWhiteSpace(gameCell.Text))
{
List <string> tags = new List <string>();
string currentTags = currentCell.Text;
foreach (char c in currentTags)
{
tags.Add(c.ToString());
}
if (!tags.Contains(selectedNumber))
{
tags.Add(selectedNumber);
}
List <string> sortedTags = tags.OrderBy(c => c).ToList();
currentCell.Text = string.Empty;
foreach (var tag in sortedTags)
{
currentCell.Text += tag;
}
NoteGrid.Focus();
}
}
}
}
protected void txt_OrderIndex_OnTextChanged(object sender, EventArgs e)
{
var textBox = (TextBox)sender;
var dataItem = ((GridDataItem)textBox.Parent.Parent);
if (dataItem != null)
{
try
{
var noticeId = new Guid(dataItem.GetDataKeyValue("NoticeID").ToString());
var orderIndex = Convert.ToInt32(textBox.Text);
orderIndex = orderIndex > 0 ? orderIndex : 1;
_shopActivityNotice.UpdateOrderIndex(noticeId, orderIndex);
}
catch (Exception ex)
{
RAM.Alert("无效的操作。" + ex.Message);
}
}
NoteGrid.Rebind();
}
//删除
protected void NoteGrid_DeleteCommand(object sender, GridCommandEventArgs e)
{
var editedItem = (GridDataItem)e.Item;
var noteId = new Guid(editedItem.GetDataKeyValue("NoticeID").ToString());
try
{
var result = _shopActivityNotice.DeleteShopActivityNoticeInfo(noteId);
if (result)
{
NoteGrid.Rebind();
}
else
{
RAM.Alert("操作无效！");
}
}
catch
{
RAM.Alert("删除失败！");
}
}
protected void IsShow_CheckedChanged(object sender, EventArgs e)
{
var ccb = sender as ConfirmCheckBox;
if (ccb != null)
{
var item = ccb.Parent.Parent as GridDataItem;
if (item != null)
{
var noticeID = new Guid(item.GetDataKeyValue("NoticeID").ToString());
bool isShow = ccb.Checked;
var success = _shopActivityNotice.UpdateIsShow(isShow, noticeID);
if (success)
{
NoteGrid.Rebind();
}
else
{
RAM.Alert("设置显示失败！");
}
}
}
}
public void display()
{
using (SqlConnection ConObj = new SqlConnection(constr))
{
ConObj.Open();
try
{
SqlCommand cmd = new SqlCommand("Display_StickyNotes", ConObj);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uname", SqlDbType.VarChar).Value = uname.Trim();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
NoteGrid.DataSource = reader;
NoteGrid.DataBind();
}
catch (Exception exp)
{
note.Text += exp.Message;
}
}
}
