public static int Insert(Event e)
{
int result = 0;
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_insert_schedule_device`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_device", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = e.device_id });
cmd.Parameters.Add(new MySqlParameter("@_user", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = e.user_id });
cmd.Parameters.Add(new MySqlParameter("@_parent", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = e.parent_id });
cmd.Parameters.Add(new MySqlParameter("@_time_begin", MySqlDbType.DateTime) { Direction = System.Data.ParameterDirection.Input, Value = e.Begin });
cmd.Parameters.Add(new MySqlParameter("@_time_end", MySqlDbType.DateTime) { Direction = System.Data.ParameterDirection.Input, Value = e.End });
cmd.Parameters.Add(new MySqlParameter("@_loop", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = e.loop });
cmd.Parameters.Add(new MySqlParameter("@_comment", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = e.Content });
cmd.Parameters.Add(new MySqlParameter("@result", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Output, Value = 0 });
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
result = Convert.ToInt32(cmd.Parameters["@result"].Value);
};
conn.Close();
};
}
catch (Exception ex)
{
Console.WriteLine(ex.GetBaseException().ToString());
}
return result;
}
public bool Add(ref Event E)
{
if (this.Mode == ModeGroup.None)
{
this.Events.Add(E);
E.Left = this.Left;
E.Width = this.Width;
return true;
}
if (E.Id == 7)
{
Console.Write(E.Id);
}
if (this.Mode == ModeGroup.Vertical)
{
bool canAdd = true;
foreach (Event e in this.Events)
{
double h = 0;
int min = (e.BeginIndex <= E.BeginIndex) ? e.BeginIndex : E.BeginIndex;
int max = (e.BeginIndex <= E.BeginIndex) ? E.BeginIndex : e.BeginIndex;
for (int i = min; i < max; i++)
{
bool isEx = false;
foreach (int j in ExpansionIndex)
{
if (i == j)
{
isEx = true;
break;
}
}
if (isEx)
h += 120;
else h += 60;
}
if (e.BeginIndex < E.BeginIndex || (e.BeginIndex == E.BeginIndex && e.Top <= E.Top))
{
h -= e.Top;
h += E.Top;
if (e.Height >= h)
{
canAdd = false;
break;
}
}
else
{
h += e.Top;
h -= E.Top;
if (E.Height >= h)
{
canAdd = false;
break;
}
}
}
if (canAdd)
{
this.Events.Add(E);
E.Left = this.Left;
E.Width = this.Width;
return true;
}
}
return false;
}
public static void delete(Event e)
{
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_delete_schedule`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_s_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = e.Id });
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
};
conn.Close();
};
}
catch (Exception)
{
}
}