/// <summary>
/// Execute the sql of update
/// </summary>
/// <param name="crafts_CurPlan_Modle"></param>
/// <returns></returns>
public int Update_One_Plan_Table(Crafts_CurPlan_Modle crafts_CurPlan_Modle)
{
using (var con = GetOpenConnection())
{
return(con.Execute(crafts_CurPlan_Dal.Update_One_Plan_Table(crafts_CurPlan_Modle)));
}
}
/// <summary>
/// the sql of insert
/// </summary>
/// <param name="crafts_CurPlan_Modle"></param>
/// <returns></returns>
public string Insert_One_Plan__Table(Crafts_CurPlan_Modle crafts_CurPlan_Modle)
{
string _insert_one_sql = "INSERT INTO [AMS].[dbo].[Crafts_CurPlan]"
+ "([WorkOrderNo],[WorkOrderName],[WorkOrderDescripe],[PlanNumber]"
+ ",[DoneNumber],[PassRate]) VALUES('" + crafts_CurPlan_Modle.WorkOrderNo
+ "','" + crafts_CurPlan_Modle.WorkOrderName + "','"
+ crafts_CurPlan_Modle.WorkOrderDescripe + "',"
+ crafts_CurPlan_Modle.PlanNumber + "," + crafts_CurPlan_Modle.DoneNumber
+ ",'" + crafts_CurPlan_Modle.PassRate + "')";
return(_insert_one_sql);
}
/// <summary>
/// the sql of update
/// </summary>
/// <param name="crafts_CurPlan_Modle"></param>
/// <returns></returns>
public string Update_One_Plan_Table(Crafts_CurPlan_Modle crafts_CurPlan_Modle)
{
string _update_one_sql = "UPDATE [AMS].[dbo].[Crafts_CurPlan]"
+ "SET [WorkOrderNo] = '" + crafts_CurPlan_Modle.WorkOrderNo
+ "',[WorkOrderName] = '" + crafts_CurPlan_Modle.WorkOrderName + "',[WorkOrderDescripe] = '"
+ crafts_CurPlan_Modle.WorkOrderDescripe + "',[PlanNumber] = "
+ crafts_CurPlan_Modle.PlanNumber + ",[DoneNumber] = "
+ crafts_CurPlan_Modle.DoneNumber + ",[PassRate] = '"
+ crafts_CurPlan_Modle.PassRate + "' WHERE ID = "
+ crafts_CurPlan_Modle.ID;
return(_update_one_sql);
}
