using Restaurant.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Restaurant.DAL
{
public class OperServer
{
SqlDBHelper db = new SqlDBHelper();
Result result = new Result();
public Result Insert(string aid,string fid)
{
try {
DateTime time = db.Get_DbServerTime();
string sql = "insert into Manage([FoodID],[AID],[MDate])"+"values({0},'{1}','{2}')";
sql=string.Format(sql,Convert.ToInt32(fid),aid,time);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "成功!";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
}
}
using Restaurant.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Restaurant.DAL
{
public class OperServer
{
SqlDBHelper db = new SqlDBHelper();
Result result = new Result();
public Result Insert(string aid,string fid)
{
try {
DateTime time = db.Get_DbServerTime();
string sql = "insert into Manage([FoodID],[AID],[MDate])"+"values({0},'{1}','{2}')";
sql=string.Format(sql,Convert.ToInt32(fid),aid,time);
db.ExecuteNonQuery(sql);
result.code = true;
result.Info = "成功!";
}
catch (Exception ex)
{
result.code = false;
result.Info = ex.Message;
}
return result;
}
}
}