public int edit(RestaurentDTO rest)
{
string sql = string.Format("UPDATE quanan SET name = '{0}', address = '{1}', opentime = '{2}', closetime = '{3}' where id = '{4}'",
rest.Name, rest.Address, rest.OpenTime, rest.CloseTime, rest.ID);
return(ProcessData.ExcuteNonQuery(sql));
}
public int insert(RestaurentDTO restaurant)
{
string sql = string.Format("insert into quanan(name, address, opentime, closetime) values" +
"('{0}', '{1}', '{2}', '{3}')",
restaurant.Name, restaurant.Address, restaurant.OpenTime, restaurant.CloseTime);
return(ProcessData.ExcuteNonQuery(sql));
}
private RestaurentDTO GetRestaurentInfo()
{
RestaurentDTO rest = new RestaurentDTO();
if (update)
{
rest.ID = int.Parse(lbID.Text);
}
rest.Name = txtName.Text;
rest.Address = txtAddr.Text;
string opentime = nOH.Value + ":" + nOM.Value;
rest.OpenTime = opentime;
string closetime = nCH.Value + ":" + nCM.Value;
rest.CloseTime = closetime;
return(rest);
}
private void btnAdd_Click(object sender, EventArgs e)
{
RestaurentDTO rest = GetRestaurentInfo();
if (update)
{
if (UpdateRest != null)
{
UpdateRest(rest);
}
}
else
{
if (AddRest != null)
{
AddRest(rest);
}
}
this.Close();
}
public int update(RestaurentDTO rest)
{
return(restDAO.update(rest));
}
public int insert(RestaurentDTO rest)
{
return(restDAO.insert(rest));
}
private void UpdateFrm_UpdateRest(RestaurentDTO rest)
{
restWS.update(rest);
gvRest.DataSource = restWS.readAll().Tables[0];
}
private void AddForm_AddRest(RestaurentDTO rest)
{
restWS.insert(rest);
gvRest.DataSource = restWS.readAll().Tables[0];
}
