/// <summary> /// 将机型保存到数据库 /// </summary> /// <param name="mode"></param> /// <returns></returns> public static bool Save(ModeZheWangSet mode, All.Class.DataReadAndWrite Conn) { Delete(mode.ID, Conn); //字符串 string sql = "insert into SetZheWang ({0}) values ({1})"; string title = "ModeId,Mode,ModeInfo {0}{1}{2}"; string value = "'{0}','{1}','{2}'{3}{4}{5}"; //标题 string playFile = ",PlayFile1"; string start = ",Start1"; string end = ",End1"; title = string.Format(title, playFile, start, end); //值 playFile = string.Format(",'{0}'", mode.PlayFile); start = string.Format(",{0}", mode.Start); end = string.Format(",{0}", mode.End); value = string.Format(value, mode.ID, mode.Mode, mode.Info, playFile, start, end); //组合后写入数据库 sql = string.Format(sql, title, value); return(Conn.Write(sql) == 1); }
///// <summary> ///// 机型转化为可传递的字符串 ///// </summary> ///// <returns></returns> //public string ClassToStr() //{ // Dictionary<string, string> buff = new Dictionary<string, string>(); // buff.Add("ID", this.ID); // buff.Add("Mode", this.Mode); // buff.Add("Info", this.Info); // buff.Add("PlayFile1", PlayFile); // buff.Add("Star1", Start.ToString()); // buff.Add("End1", End.ToString()); // return All.Class.SSFile.Dictionary2Text(buff); //} ///// <summary> ///// 字符串还原为机型 ///// </summary> ///// <param name="str"></param> ///// <returns></returns> //public static ModeZheWangSet StrToClass(string str) //{ // ModeZheWangSet result = new ModeZheWangSet(); // Dictionary<string, string> buff = All.Class.SSFile.Text2Dictionary(str); // result.ID = buff["ID"]; // result.Mode = buff["Mode"]; // result.Info = buff["Info"]; // result.PlayFile = buff["PlayFile1"]; // result.Start = All.Class.Num.ToInt(buff["Start1"]); // result.End = All.Class.Num.ToInt(buff["End1"]); // return result; //} #endregion /// <summary> /// 根据机型ID得到机型 /// </summary> /// <param name="modeID"></param> /// <returns></returns> public static ModeZheWangSet GetMode(string modeID, All.Class.DataReadAndWrite Conn) { ModeZheWangSet result = new ModeZheWangSet(); using (DataTable dt = Conn.Read(string.Format("select * from SetZheWang where ModeID='{0}'", modeID))) { if (dt != null && dt.Rows.Count >= 1) { result.ID = All.Class.Num.ToString(dt.Rows[0]["ModeID"]); result.Mode = All.Class.Num.ToString(dt.Rows[0]["Mode"]); result.Info = All.Class.Num.ToString(dt.Rows[0]["ModeInfo"]); result.PlayFile = All.Class.Num.ToString(dt.Rows[0]["PlayFile1"]); result.Start = All.Class.Num.ToInt(dt.Rows[0]["Start1"]); result.End = All.Class.Num.ToInt(dt.Rows[0]["End1"]); } } return(result); }
/// <summary> /// 获取所有机型 /// </summary> /// <returns></returns> public static List <ModeZheWangSet> GetModeList(All.Class.DataReadAndWrite Conn) { List <ModeZheWangSet> result = new List <ModeZheWangSet>(); using (DataTable dt = Conn.Read("select ModeId,Mode,ModeInfo from SetZheWang order by ID desc")) { if (dt != null && dt.Rows.Count > 0) { ModeZheWangSet tmpModeZheWangSet; for (int i = 0; i < dt.Rows.Count; i++) { tmpModeZheWangSet = new ModeZheWangSet(); tmpModeZheWangSet.ID = All.Class.Num.ToString(dt.Rows[i]["ModeID"]); tmpModeZheWangSet.Mode = All.Class.Num.ToString(dt.Rows[i]["Mode"]); tmpModeZheWangSet.Info = All.Class.Num.ToString(dt.Rows[i]["ModeInfo"]); result.Add(tmpModeZheWangSet); } } } return(result); }