/// <summary> /// Modified process cardmodule /// </summary> /// <param name="card"></param> /// <returns></returns> public static bool UpdateProcessCardModule(Kingdee.CAPP.Model.ProcessCardModule card) { string strsql = @"UPDATE [dbo].[ProcessCardModule] set [CardModuleXML]=@CardModuleXML ,[FixedMapValues]=@FixedMapValues ,[DetailMapValues]=@DetailMapValues ,[TitleMapValues]=@TitleMapValues ,[CreateTime]=@CreateTime ,[CreateBy]=@CreateBy ,[UpdateTime]=@UpdateTime ,[IsDelete]=@IsDelete ,[IsCheckout]=@IsCheckout where ID=@ID"; string xmlstr = SerializeHelper.Serialize <CardsXML>(card.CardModule); using (DbCommand cmd = db.GetSqlStringCommand(strsql)) { db.AddInParameter(cmd, "@ID", DbType.Guid, card.Id); db.AddInParameter(cmd, "@CardModuleXML", DbType.String, xmlstr); db.AddInParameter(cmd, "@FixedMapValues", DbType.String, card.FixedMapValues); db.AddInParameter(cmd, "@DetailMapValues", DbType.String, card.DetailMapValues); db.AddInParameter(cmd, "@TitleMapValues", DbType.String, card.TitleMapValues); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, DateTime.Now); db.AddInParameter(cmd, "@CreateBy", DbType.String, card.CreateBy); db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, DateTime.Now); db.AddInParameter(cmd, "@IsDelete", DbType.Int16, 0); db.AddInParameter(cmd, "@IsCheckout", DbType.Boolean, false); db.ExecuteScalar(cmd); return(true); } }
/// <summary> /// insert process card module /// </summary> /// <param name="card"></param> /// <returns></returns> public static Guid AddProcessCard(Kingdee.CAPP.Model.ProcessCardModule card) { string strsql = @"INSERT INTO [dbo].[ProcessCardModule] ( [ID] ,[Name] ,[CardModuleXML] ,[FixedMapValues] ,[DetailMapValues] ,[TitleMapValues] ,[CreateTime] ,[CreateBy] ,[UpdateTime] ,[IsDelete] ,[IsCheckout]) VALUES ( @ID ,@Name ,@CardModuleXML ,@FixedMapValues ,@DetailMapValues ,@TitleMapValues ,@CreateTime ,@CreateBy ,@UpdateTime ,@IsDelete ,@IsCheckout)"; string xmlstr = SerializeHelper.Serialize <CardsXML>(card.CardModule); using (DbCommand cmd = db.GetSqlStringCommand(strsql)) { Guid id = Guid.NewGuid(); db.AddInParameter(cmd, "@ID", DbType.Guid, id); db.AddInParameter(cmd, "@Name", DbType.String, card.Name); db.AddInParameter(cmd, "@CardModuleXML", DbType.String, xmlstr); db.AddInParameter(cmd, "@FixedMapValues", DbType.String, card.FixedMapValues); db.AddInParameter(cmd, "@DetailMapValues", DbType.String, card.DetailMapValues); db.AddInParameter(cmd, "@TitleMapValues", DbType.String, card.TitleMapValues); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, DateTime.Now); db.AddInParameter(cmd, "@CreateBy", DbType.String, card.CreateBy); db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, DateTime.Now); db.AddInParameter(cmd, "@IsDelete", DbType.Int16, 0); db.AddInParameter(cmd, "@IsCheckout", DbType.Boolean, false); db.ExecuteScalar(cmd); card.Id = id; return(id); } }