private void InsUpdDelSeason(char Event, int id)
{
var msg = "";
if (Event == 'I' || Event == 'U')
{
var objSeason = new SeasonClass(id, txtSeason.Text);
msg = BL_Season.InsUpdDelSeason(Event, objSeason, out id);
}
else
{
var objSeason = new SeasonClass(id, "");
msg = BL_Season.InsUpdDelSeason(Event, objSeason, out id);
}
if (DatabaseMessage.ContainMessage(msg))
{
_msgbox.ShowSuccess(msg);
}
else
{
_msgbox.ShowWarning(msg);
}
FillGridview();
ClearAll();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (!DataGridViewUtil.CheckPerrmisson(this, sender, e))
{
return;
}
try
{
if (e.RowIndex > -1 && e.ColumnIndex > -1)
{
list = DataGridViewUtil.BindingListToList <SeasonClass>(dataGridView1.DataSource);
// DataGridViewUtil.BindingListToList<ListItem<String>>(dataGridView1.DataSource);
SeasonClass item = (SeasonClass)list[e.RowIndex];
switch (this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value)
{
case "删除":
if (GlobalMessageBox.Show("是否确认操作？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
if (GlobalUtil.EngineUnconnectioned(this))
{
return;
}
InteractResult result = GlobalCache.ServerProxy.DeleteSeason(item.SeasonKey);
switch (result.ExeResult)
{
case ExeResult.Success:
this.dataGridView1.DataSource = null;
list.Remove(item);
UpdateData();
break;
case ExeResult.Error:
GlobalMessageBox.Show(result.Msg);
break;
}
break;
}
}
}
catch (Exception ex)
{
GlobalUtil.ShowError(ex);
}
finally
{
GlobalUtil.UnLockPage(this);
}
}
public static List <SeasonClass> GetSeason(int Event, int id, string code, string code1)
{
var lst = new List <SeasonClass>();
var dt = DlSeason.GetSeason(Event, id, code, code1);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var obj = new SeasonClass(Convert.ToInt32(dr["Id"]), dr["Season"].ToString());
lst.Add(obj);
}
}
return(lst);
}
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
DataGridView dataGridView = (DataGridView)sender;
try
{
//检查现有的列表是否有重复名称
List <SeasonClass> sizeGroups = DataGridViewUtil.BindingListToList <SeasonClass>(dataGridView1.DataSource);
SeasonClass item = dataGridView1.Rows[e.RowIndex].DataBoundItem as SeasonClass;
if (e.ColumnIndex == Column1.Index)
{
if (e.FormattedValue == null || String.IsNullOrEmpty(e.FormattedValue.ToString()))
{
GlobalMessageBox.Show("名称不能为空！");
dataGridView.CancelEdit();
return;
}
else
{
SeasonClass existedItem = sizeGroups?.Find(t => t != item && t.SeasonKey.Equals(e.FormattedValue));
if (sizeGroups.Contains(item))
{
if (existedItem != null)
{
GlobalMessageBox.Show("名称已存在！");
dataGridView.CancelEdit();
return;
}
}
}
}
}
catch (Exception)
{
GlobalMessageBox.Show("输入格式错误！");
dataGridView.CancelEdit();
}
}
private void Initialize()
{
this.skinTextBoxName.SkinTxt.Text = string.Empty;
this.dataGridView1.AutoGenerateColumns = false;
List <ListItem <string> > confList = GlobalCache.GetParameterConfig(configKey);
if (list == null)
{
list = new List <SeasonClass>();
}
foreach (var configItem in confList)
{
SeasonClass sItem = new SeasonClass();
sItem.SeasonKey = configItem.Key;
sItem.SeasonValue = configItem.Value;
list.Add(sItem);
}
//new SortableBindingList<GiftTicketTemplate>( list)
dataGridViewPagingSumCtrl.BindingDataSource(DataGridViewUtil.ListToBindingList(list));
}
private void BaseButtonAdd_Click(object sender, EventArgs e)
{
try
{
String value = this.skinTextBoxName.SkinTxt.Text.Trim(); if (String.IsNullOrEmpty(value))
{
this.skinTextBoxName.Focus();
return;
}
if (list.Exists(t => t.SeasonKey == value))
{
GlobalMessageBox.Show("名称已存在！");
return;
}
if (GlobalUtil.EngineUnconnectioned(this))
{
return;
}
this.dataGridView1.DataSource = null;
if (!list.Exists(t => t.SeasonKey == value))
{
SeasonClass curSeason = new SeasonClass();
curSeason.SeasonKey = value;
curSeason.SeasonValue = value;
list.Add(curSeason);
}
UpdateData();
}
catch (Exception ex)
{
GlobalUtil.ShowError(ex);
}
finally
{
GlobalUtil.UnLockPage(this);
}
}
private void dataGridView1_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
DataGridView dataGridView = (DataGridView)sender;
try
{
SeasonClass group = dataGridView.Rows[e.RowIndex].DataBoundItem as SeasonClass;
InteractResult result = GlobalCache.ServerProxy.UpdateSeason(group.SeasonValue, group.SeasonKey);
switch (result.ExeResult)
{
case ExeResult.Success:
group.SeasonValue = group.SeasonKey;
ParameterConfig config = SetUpConfig();
UpdateCache(config);
dataGridView.RefreshEdit();
break;
case ExeResult.Error:
GlobalMessageBox.Show(result.Msg);
break;
default:
break;
}
}
catch (Exception ex)
{
CommonGlobalUtil.ShowError(ex);
}
}
public static string InsUpdDelSeason(char Event, SeasonClass obj, out int returnId)
{
returnId = 0;
try
{
var cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_IUD_tbl_Season";
cmd.Connection = DL_CCommon.ConnectionForCommonDb();
cmd.Parameters.AddWithValue("@EVENT", Event);
cmd.Parameters.AddWithValue("@ID", obj.Id);
cmd.Parameters.AddWithValue("@Season", obj.Season);
var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outparameter);
var outId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outId);
cmd.ExecuteNonQuery();
var msg = cmd.Parameters[outparameter.ParameterName].Value;
returnId = Convert.ToInt32(cmd.Parameters[outId.ParameterName].Value);
return(Convert.ToString(msg));
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
DL_CCommon.ConnectionForCommonDb().Close();
}
}
public static string InsUpdDelSeason(char Event, SeasonClass obj, out int id)
{
id = 0;
return(DlSeason.InsUpdDelSeason(Event, obj, out id));
}
