/// <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); }