public int RemoveText(string text, IUnitOfData unit) { string sql = "DELETE FROM {0} WHERE {1} = @txt {2} ".AkFormat(TableName, TXTFileName, AndFilterSql); SqlParameter sql1 = new SqlParameter("@txt", text); // SqlParameter sql2 = new SqlParameter("@sign", SignName); return(unit.RegisterSqlCommand(sql, sql1)); }
public void InsertActive(ActiveModel bean) { // throw new NotImplementedException(); string _sql = "INSERT INTO SNS_ACTIVITIES( FID ,USERID ,USERNAME,ACTIVITYITEMTYPE," + " ACTIVITYITEMACTION,SOURCEID,PRIVACYSTATUS ,CREATE_ID,REFERENCEID,REFERENCENAME " + " ,CREATE_TIME,UPDATE_ID ,UPDATE_TIME,FControlUnitID,ISDELETE ,SACT_TITLE ,SACT_SUBCONTENT,ACTIVITYFROM,OWNERID,ACTIVITYSTATUS)" + " VALUES ( @FID ,@USERID ,@USERNAME,@ACTIVITYITEMTYPE," + " @ACTIVITYITEMACTION,@SOURCEID,@PRIVACYSTATUS ,@CREATE_ID,@REFERENCEID,@REFERENCENAME " + " ,@CREATE_TIME,@UPDATE_ID ,@UPDATE_TIME,@FControlUnitID,@ISDELETE ,@SACT_TITLE ,@SACT_SUBCONTENT,@ACTIVITYFROM,@OWNERID,@ACTIVITYSTATUS)"; List <SqlParameter> pams = new List <SqlParameter>(); pams.Add(new SqlParameter("@FID", SqlDbType.VarChar) { SqlValue = fUnitOfData.GetUniId() }); pams.Add(new SqlParameter("@USERID", SqlDbType.VarChar) { SqlValue = bean.UserId }); pams.Add(new SqlParameter("@USERNAME", SqlDbType.VarChar) { SqlValue = bean.UserName }); pams.Add(new SqlParameter("@ACTIVITYITEMTYPE", SqlDbType.NVarChar) { Value = bean.ItemType }); pams.Add(new SqlParameter("@PRIVACYSTATUS", SqlDbType.NVarChar) { SqlValue = bean.PrivacyStatus }); pams.Add(new SqlParameter("@ACTIVITYITEMACTION", SqlDbType.NVarChar) { SqlValue = bean.ItemAction }); pams.Add(new SqlParameter("@CREATE_ID", SqlDbType.NVarChar) { SqlValue = bean.UserId.IsEmpty() ? AtawAppContext.Current.UserId : bean.UserId }); pams.Add(new SqlParameter("@CREATE_TIME", SqlDbType.DateTime) { SqlValue = fUnitOfData.Now }); pams.Add(new SqlParameter("@UPDATE_ID", SqlDbType.NVarChar) { SqlValue = bean.FID }); pams.Add(new SqlParameter("@UPDATE_TIME", SqlDbType.NVarChar) { SqlValue = fUnitOfData.Now }); pams.Add(new SqlParameter("@FControlUnitID", SqlDbType.NVarChar) { SqlValue = bean.FControlUnitID.IsEmpty() ? AtawAppContext.Current.FControlUnitID : bean.FControlUnitID }); pams.Add(new SqlParameter("@ISDELETE", SqlDbType.Bit) { SqlValue = 0 }); pams.Add(new SqlParameter("@SOURCEID", SqlDbType.NVarChar) { SqlValue = bean.SourceId }); pams.Add(new SqlParameter("@SACT_TITLE", SqlDbType.NVarChar) { SqlValue = bean.Title }); pams.Add(new SqlParameter("@SACT_SUBCONTENT", SqlDbType.NVarChar) { SqlValue = bean.SubContent }); pams.Add(new SqlParameter("@ACTIVITYFROM", SqlDbType.NVarChar) { SqlValue = bean.ActivityFrom }); pams.Add(new SqlParameter("@OWNERID", SqlDbType.NVarChar) { SqlValue = bean.OwnerID }); pams.Add(new SqlParameter("@ACTIVITYSTATUS", SqlDbType.Int) { SqlValue = 0 }); pams.Add(new SqlParameter("@REFERENCEID", SqlDbType.NVarChar) { SqlValue = bean.ReferenceID }); pams.Add(new SqlParameter("@REFERENCENAME", SqlDbType.NVarChar) { SqlValue = bean.ReferenceName }); fUnitOfData.RegisterSqlCommand(_sql, pams.ToArray()); }
public void InsertMessage(MessageModel bean) { // throw new NotImplementedException(); string _sql = "INSERT INTO ATAW_MESSAGES(FID,TENANT_ID,APPLICATION_ID,ORGANIZATION_ID,MODULE_ID," + "SOURCE_ID,SEND_ID,RECEIVE_ID,BODY,TYPE,CATEGORY,PRIVACY,ISHANDLED,CREATE_ID,CREATE_TIME" + " VALUES (@FID,@TENANT_ID,@APPLICATION_ID,@ORGANIZATION_ID," + "@MODULE_ID,@SOURCE_ID,@SEND_ID,@RECEIVE_ID,@BODY,@TYPE,@CATEGORY,@PRIVACY,@ISHANDLED,@CREATE_ID,@CREATE_TIME)"; List <SqlParameter> pams = new List <SqlParameter>(); pams.Add(new SqlParameter("@FID", SqlDbType.NVarChar) { SqlValue = fUnitOfData.GetUniId() }); pams.Add(new SqlParameter("@TENANT_ID", SqlDbType.NVarChar) { SqlValue = bean.TenantID }); pams.Add(new SqlParameter("@APPLICATION_ID", SqlDbType.NVarChar) { SqlValue = bean.ApplicationID }); pams.Add(new SqlParameter("@ORGANIZATION_ID", SqlDbType.NVarChar) { Value = bean.OrganizationID }); pams.Add(new SqlParameter("@MODULE_ID", SqlDbType.NVarChar) { SqlValue = bean.ModuleID }); pams.Add(new SqlParameter("@SOURCE_ID", SqlDbType.NVarChar) { SqlValue = bean.SourceID }); pams.Add(new SqlParameter("@SEND_ID", SqlDbType.NVarChar) { SqlValue = bean.SendID }); pams.Add(new SqlParameter("@RECEIVE_ID", SqlDbType.NVarChar) { SqlValue = bean.ReceiveID }); pams.Add(new SqlParameter("@BODY", SqlDbType.NVarChar) { SqlValue = bean.Body }); pams.Add(new SqlParameter("@TYPE", SqlDbType.NVarChar) { SqlValue = bean.Type }); pams.Add(new SqlParameter("@CATEGORY", SqlDbType.NVarChar) { SqlValue = bean.Category }); pams.Add(new SqlParameter("@PRIVACY", SqlDbType.NVarChar) { SqlValue = bean.Privacy }); pams.Add(new SqlParameter("@ISHANDLED", SqlDbType.NVarChar) { SqlValue = bean.IsHandled }); pams.Add(new SqlParameter("@CREATE_ID", SqlDbType.NVarChar) { SqlValue = AtawAppContext.Current.UserId }); pams.Add(new SqlParameter("@CREATE_TIME", SqlDbType.DateTime) { SqlValue = fUnitOfData.Now }); fUnitOfData.RegisterSqlCommand(_sql, pams.ToArray()); }