/// <summary>
/// 获取雷达组SQL字符串
/// </summary>
/// <param name="group">雷达组对象</param>
/// <returns></returns>
private string GetRadarGroupSqlString(RadarGroup group)
{
string sql = string.Empty;
if (group != null)
{
sql = string.Format(group.Id <= 0 ? "insert into t_base_radargroup_info (group_name, owner_shiploader_id, group_type) values ('{0}', {1}, {2})" : "update t_base_radargroup_info set group_name = '{0}', owner_shiploader_id = {1}, group_type = {2} where group_id = {3}", group.Name, group.OwnerShiploaderId, group.GroupType, group.Id);
}
return(sql);
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Save_Click(object sender, EventArgs e)
{
if (this.dataGridView_Main.Rows.Count == 0)
{
return;
}
List <RadarGroup> list = new List <RadarGroup>();
foreach (DataGridViewRow row in this.dataGridView_Main.Rows)
{
if (row.Cells["Column_Id"].Value.ToString().Equals("0") || row.Cells["Column_Changed"].Value.ToString().Equals("1"))
{
RadarGroup group = DataGridViewUtil.ConvertDataGridViewRow2Obect <RadarGroup>(row);
if (group.OwnerShiploaderId > 0)
{
list.Add(group);
}
else
{
MessageBox.Show("所属装船机不得为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
}
bool result;
try { result = this.dataService.SaveRadarGroups(list); }
catch (Exception ex)
{
string errorMessage = "雷达组信息保存时出现问题：" + ex.Message;
MessageBox.Show(errorMessage, "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (result)
{
MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DataSourceRefresh();
}
else
{
MessageBox.Show("保存失败", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 保存雷达组信息
/// </summary>
/// <param name="loader">雷达组对象</param>
/// <returns></returns>
public int SaveRadarGroup(RadarGroup group)
{
return(this.provider.ExecuteSql(this.GetRadarGroupSqlString(group)));
}
