/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(MExpressItemConfig model) { #region SQL语句 const string sql = @" INSERT INTO [T_PrintItem] ( [ItemID] ,[Font] ,[FontSize] ,[SeqNo] ,[Visable] ,[UUID] ,[TemplateName] ,[ItemlName] ,[ItemlCode] ,[Wight] ,[Helght] ,[LeftAway] ,[TopAway] ,[PrintColor] ) VALUES ( @ItemID ,@Font ,@FontSize ,@SeqNo ,@Visable ,@UUID ,@TemplateName ,@ItemlName ,@ItemlCode ,@Wight ,@Helght ,@LeftAway ,@TopAway ,@PrintColor );"; #endregion var res = SqlHelper.ExecuteScalar(CommandType.Text, sql, new SQLiteParameter("@ItemID", SqlHelper.ToNullDBValue(model.ItemID)), new SQLiteParameter("@Font", SqlHelper.ToNullDBValue(model.Font)), new SQLiteParameter("@FontSize", SqlHelper.ToNullDBValue(model.FontSize)), new SQLiteParameter("@SeqNo", SqlHelper.ToNullDBValue(model.SeqNo)), new SQLiteParameter("@Visable", SqlHelper.ToNullDBValue(model.Visable)), new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)), new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)), new SQLiteParameter("@ItemlName", SqlHelper.ToNullDBValue(model.ItemlName)), new SQLiteParameter("@ItemlCode", SqlHelper.ToNullDBValue(model.ItemlCode)), new SQLiteParameter("@Wight", SqlHelper.ToNullDBValue(model.Wight)), new SQLiteParameter("@Helght", SqlHelper.ToNullDBValue(model.Helght)), new SQLiteParameter("@LeftAway", SqlHelper.ToNullDBValue(model.LeftAway)), new SQLiteParameter("@TopAway", SqlHelper.ToNullDBValue(model.TopAway)), new SQLiteParameter("@PrintColor", SqlHelper.ToNullDBValue(model.PrintColor)) ); return(res == null ? 0 : Convert.ToInt32(res)); }
/// <summary> /// 选好遍历界面控件 /// </summary> /// <param name="objControlCollection"></param> public void InitialControl(Control.ControlCollection controlCollection) { foreach (Control objControl in controlCollection) { TXTextBox myTextBox = objControl as TXTextBox; if (myTextBox == null) { continue; } MExpressItemConfig myItemConfig = myTextBox.Tag as MExpressItemConfig; if (myItemConfig == null) { continue; } myItemConfig.LeftAway = myTextBox.Location.X; myItemConfig.TopAway = myTextBox.Location.Y; m_ItemConfigBll.Update(myItemConfig); } }
/// <summary> /// 创建配置项 /// </summary> /// <returns></returns> private TXTextBox CreateTextBox(MExpressItemConfig ItemConfig) { try { TXTextBox myTextBox = new TXTextBox(); myTextBox.Name = ItemConfig.ItemlCode; myTextBox.Text = ItemConfig.ItemlName; myTextBox.IsCanDrag = true; myTextBox.Multiline = true; myTextBox.Size = new Size(ItemConfig.Wight, ItemConfig.Helght); myTextBox.Location = new Point(ItemConfig.LeftAway, ItemConfig.TopAway); myTextBox.Font = new Font(new FontFamily(ItemConfig.Font), Convert.ToInt32(ItemConfig.FontSize)); myTextBox.Tag = ItemConfig; return(myTextBox); } catch (Exception) { return(new TXTextBox()); } }
/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(MExpressItemConfig model) { #region SQL语句 const string sql = @" UPDATE [T_PrintItem] SET [ItemID] = @ItemID ,[Font] = @Font ,[FontSize] = @FontSize ,[SeqNo] = @SeqNo ,[Visable] = @Visable ,[UUID] = @UUID ,[TemplateName] = @TemplateName ,[ItemlName] = @ItemlName ,[ItemlCode] = @ItemlCode ,[Wight] = @Wight ,[Helght] = @Helght ,[LeftAway] = @LeftAway ,[TopAway] = @TopAway ,[PrintColor] = @PrintColor WHERE [ItemID] = @ItemID"; #endregion return(SqlHelper.ExecuteNonQuery(CommandType.Text, sql, new SQLiteParameter("@ItemID", SqlHelper.ToNullDBValue(model.ItemID)), new SQLiteParameter("@Font", SqlHelper.ToNullDBValue(model.Font)), new SQLiteParameter("@FontSize", SqlHelper.ToNullDBValue(model.FontSize)), new SQLiteParameter("@SeqNo", SqlHelper.ToNullDBValue(model.SeqNo)), new SQLiteParameter("@Visable", SqlHelper.ToNullDBValue(model.Visable)), new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)), new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)), new SQLiteParameter("@ItemlName", SqlHelper.ToNullDBValue(model.ItemlName)), new SQLiteParameter("@ItemlCode", SqlHelper.ToNullDBValue(model.ItemlCode)), new SQLiteParameter("@Wight", SqlHelper.ToNullDBValue(model.Wight)), new SQLiteParameter("@Helght", SqlHelper.ToNullDBValue(model.Helght)), new SQLiteParameter("@LeftAway", SqlHelper.ToNullDBValue(model.LeftAway)), new SQLiteParameter("@TopAway", SqlHelper.ToNullDBValue(model.TopAway)), new SQLiteParameter("@PrintColor", SqlHelper.ToNullDBValue(model.PrintColor)) )); }
/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(MExpressItemConfig model) { return(_dao.Update(model)); }
/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(MExpressItemConfig model) { return(_dao.Insert(model)); }